Data Engineering Integration
- Data Engineering Integration 10.4.0
- All Products
jdbc:<subprotocol>:<subname>
jdbc:informatica:oracle://<host>:<port>;SID=<value>
jdbc:oracle:thin:@//<host>:<port>:<SID>
jdbc:informatica:db2://<host>:<port>;DatabaseName=<value>
jdbc:db2://<host>:<port>/<database_name>
jdbc:informatica:sqlserver://<host>;DatabaseName=<value>
jdbc:sqlserver://<host>;DatabaseName=<value>
jdbc:netezza://<host>:<port>/<database_name>
jdbc:pivotal:greenplum://<host>:<port>;/database_name=<value>
jdbc:postgressql://<host>:<port>/<database_name>
jdbc:teradata://<host>/database_name=<value>,tmode=<value>,charset=<value>
jdbc:spark://<Azure host name>:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/<cluster ID>;AuthMech=3;UID=token;
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;
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<host>)(PORT=<port_number>)) (CONNECT_DATA=(SERVICE_NAME=<service_name>)))"
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>
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>