JDBC Connection

Access level: read

The JDBC connection enables 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.

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

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

Integration of the JDBC driver

Jedox customers should contact Jedox Customer Portal for details on integrating with JDBC.

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://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-download-driver.html

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

https://jdbc.postgresql.org/download/

Informix

com.informix.jdbc.IfxDriver

jdbc:informix-sqli://

ifxjdbc.jar

https://www.ibm.com/support/pages/download-informix-products

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.

Notes:

  • User and password credentials are the only supported form of authentication for the JDBC connection, regardless of the type(s) of authentication supported in the source / target system of the connection.

  • The JDBC connection only allows read access (extract types Relational and RelationalTable) and usage in load type RelationalSQL. "Relational" type loads are not allowed.

  • Using Snowflake connection and JDBC - Snowflake connection can cause a difference in the extracts of the same time data, as each connection type uses a different format for the query result set (relational extract). The JDBC connection uses JSON as the result format, while the native Snowflake connector uses the default Arrow format.

 

Updated September 27, 2024