Informatica ODBC Connectivity Tests

Informatica connections can be configured using ODBC Drivers. This will be store in odbc.ini file.

cd $ODBC_HOME

./ssgodbc.aix64 -d datasource name -u username -p password

[Oracle_SSL]

Driver=/opt/sw/ODBC8.0/lib/DWora28.so

Description=DataDirect 7.1 Oracle Wire Protocol

IpAddress=12.12.1.12.12

PortNumber=1299

ServiceName=abc_service

EncryptionMethod=1

WithHold=1

TrustStore=/opt/sw/security/keystore.pem

Keystore=/opt/sw/wallets/ewallet.p12

KeystorePassword=keknekn

ValidateServerCertificate=1

CryptoProtocolVersion=TLSv1.2

./ssgodbc.aix64 -d datasource name -u username -p password

Sample String

------------------

[DB2_SSL]

Driver=/opt/sw/ODBC8.0/lib/DBdb227.so

Description=DataDirect 7.1 DB2 Wire Protocol

Database=Db2database

EncryptionMethod=1

GrantAuthId=LOCAL

GrantExecute=1

IpAddress=102.12.12.12

IsolationLevel=CURSOR_STABILITY

TcpPort=5029

WithHold=1

TrustStore=/opt/sw/security/keystore.pem

ValidateServerCertificate=1

CryptoProtocolVersion=TLSv1.2