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)

Additional JDBC parameters can also be set here.

 
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 need 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

MariaDB

org.mariadb.jdbc.Driver

 

mariadb-java-client-1.3.6.jar

https://downloads.mariadb.org/connector-java/

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

http://go.sap.com/product/data-mgmt/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. The list is not complete and not necessarily up to date.

image_pdfimage_print