JDBC Connection

image_pdfimage_print

The JDBC connection allows the connection to a relational database for which no specific connection type is available. GenericDB uses the JDBC driver provided by the database manufacturer.

Main Settings

URL:

The URL JDBC connection string. The correct syntax of the URL should be found in the documentation of the database vendor.

User Name:

User name for the connection to the database (optional).

Password:

Password for the connection to the database (optional).

Advanced Settings

Driver Class:

The Java class of the JDBC driver. (Most newer JDBC drivers don’t require the manual setting of the driver class)

Note: Additional JDBC parameters must be part of the Connection URL. Make sure you use the correct separator: ; or &.

Integration of the JDBC driver

The JDBC driver’s .jar file must be copied into the Jedox Integrator installation directory: …\tomcat\webapps\etlserver\WEB-INF\lib_external. The JedoxSuiteTomcatService has to be restarted afterwards.

Here is an list of some popular JDBC drivers, and the class name that needs to be used:

Database

 Driver class

 JDBC URL prefix

 JDBC jar filename

 Link

Amazon Redshift

com.amazon.redshift.jdbc4.Driver

jdbc:redshift://

RedshiftJDBC4.jar

https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC4.jar

Apache SOLR

org.apache.solr.client.solrj.io.sql.DriverImpl

jdbc:solr//

N/A

http://lucene.apache.org/solr/

Firebird SQL

org.firebirdsql.jdbc.FBDriver

jdbc:firebirdsql://

jaybird-full-xxx.jar

http://www.firebirdsql.org/en/jdbc-driver/

Greenplum

org.postgresql.Driver

jdbc:postgresql://

postgresql-8.x-xxx.jdbc4.jar

http://jdbc.postgresql.org/download.html

Informix

com.informix.jdbc.IfxDriver

jdbc:informix-sqli://

ifxjdbc.jar

http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc

Netezza

org.netezza.Driver

jdbc:netezza://

N/A

http://www.netezza.com

Pervasive

com.pervasive.jdbc.v2.Driver

jdbc:pervasive://

N/A

http://www.pervasivedb.com/download/Pages/PDBDownloads. aspx

SAP SQL Anywhere

com.sybase.jdbc4.jdbc.SybDriver

jdbc:sybase:Tds:

N/A

https://www.sap.com/products/sql-anywhere.html

Teradata

com.teradata.jdbc.TeraDriver

jdbc:teradata://

terajdbc4.jar

http://downloads.teradata.com/download/connectivity/jdbc-driver

Vertica

com.vertica.Driver

jdbc:vertica://

N/A

http://www.vertica.com/support/myvertica/

Note: These drivers are not tested with Jedox Integrator or Jedox Cloud. The list is not complete and not necessarily up to date.

image_pdfimage_print