Friday, November 8, 2024

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


Uploading: 313980 of 313980 bytes uploaded.



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



No comments: