Table of Contents

Search

  1. Preface
  2. Part 1: Hadoop Integration
  3. Part 2: Databricks Integration
  4. Appendix A: Connections Reference

JDBC Connection String

JDBC Connection String

Specify the connection string in the JDBC connection to connect to the database.
Specify the connection string in the following format:
jdbc:<subprotocol>:<subname>
Use the following sample connection strings that you can enter for the applicable database type:
  • DataDirect Oracle JDBC driver:
    jdbc:informatica:oracle://<host>:<port>;SID=<value>
  • Oracle JDBC driver:
    jdbc:oracle:thin:@//<host>:<port>:<SID>
  • DataDirect IBM DB2 JDBC driver:
    jdbc:informatica:db2://<host>:<port>;DatabaseName=<value>
  • IBM DB2 JDBC driver:
    jdbc:db2://<host>:<port>/<database_name>
  • DataDirect Microsoft SQL Server JDBC driver:
    jdbc:informatica:sqlserver://<host>;DatabaseName=<value>
  • Microsoft SQL Server JDBC driver:
    jdbc:sqlserver://<host>;DatabaseName=<value>
  • Netezza JDBC driver:
    jdbc:netezza://<host>:<port>/<database_name>
  • Pivotal Greenplum driver:
    jdbc:pivotal:greenplum://<host>:<port>;/database_name=<value>
  • Postgres Greenplum driver:
    jdbc:postgressql://<host>:<port>/<database_name>
  • Teradata JDBC driver:
    jdbc:teradata://<host>/database_name=<value>,tmode=<value>,charset=<value>
  • JDBC driver for Delta Lake:
    jdbc:spark://<host name>:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/<cluster ID>;AuthMech=3;UID=token;PWD=<token string>
Use the following sample connection strings that you can enter for an SSL-enabled applicable database type:
  • DataDirect Oracle JDBC driver:
    jdbc:informatica:oracle://<host_name>:<port>;CatalogOptions=6;ServiceName=<service_name>;trustStorePassword=<truststore_password>; keyStorePassword=<keystore_password>;CryptoProtocolVersion=TLSv1.2;keyStore=<keystore_location_of_ewallet.p12_file>; trustStore=<truststore_location_of_truststore.p12_file>;HostNameInCertificate=<database_host_name>;encryptionMethod=SSL; ValidateServerCertificate=True;
  • Oracle JDBC driver:
    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<host>)(PORT=<port_number>)) (CONNECT_DATA=(SERVICE_NAME=<service_name>)))"
  • DataDirect Microsoft SQL Server JDBC driver:
    jdbc:informatica:sqlserver://<host_name>:<port>;databaseName=<database_name>;EncryptionMethod=SSL; CryptoProtocolVersion=<TLSv1.2_or_TLSv1.1_or_TLSv1>;ValidateServerCertificate=false;TrustStore=<truststore_location>; TrustStorePassword=<truststore_password>
  • Microsoft SQL Server JDBC driver:
    jdbc:sqlserver://<host_name>:<port>;databaseName=<database_name>;integratedSecurity=false;encrypt=true;trustServerCertificate=true; TrustStore=/<truststore_location>;TrustStorePassword=<truststore_password>;user=<user_name>;password=<password>
For more information about the connection string to use with specific drivers, see the vendor documentation.