JDBC Connection

image_pdfimage_print

The JDBC connection allows the connection to a relational database for which no specific connection type is available. This connection type uses the JDBC driver URL provided by the database manufacturer. Supported relational databases may also be used in this connection type to modify the URL connection string in a very flexible way. See Systems Supported by Jedox Integrator for URL prefixes and driver classes.

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).

Driver Class:

The Java class of the JDBC driver. This setting is necessary for stable usage of the JDBC driver.

Advanced Settings

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