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. Although most newer JDBC drivers don’t require the manual setting of the driver class, this setting results in stable usage of the JDBC driver.

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 a 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/

Disclaimer: 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