Encrypted connection to SQL Server
Posted: Fri Jan 05, 2018 3:01 pm
Hello,
We need to code a set of parallel jobs that connect to a SQL Server source database that has encryption turned on. They gave us CA-signed certificates to install on the DataStage server and client.
We have never configured an encrypted SQL Server connection so we need a bit of step-by-step help.
We know that there are several ODBC wire driver security options that can be configured in odbc.ini, to point to the trust store.
We know that WebSphere has a trust and key store but we do not know whether that is the correct place where to import the certificates or whether an ad hoc trust store needs to be created (and how).
Any insight is greatly appreciated.
Marco
We need to code a set of parallel jobs that connect to a SQL Server source database that has encryption turned on. They gave us CA-signed certificates to install on the DataStage server and client.
We have never configured an encrypted SQL Server connection so we need a bit of step-by-step help.
We know that there are several ODBC wire driver security options that can be configured in odbc.ini, to point to the trust store.
We know that WebSphere has a trust and key store but we do not know whether that is the correct place where to import the certificates or whether an ad hoc trust store needs to be created (and how).
Any insight is greatly appreciated.
Marco