Connecting to DB2 with SSL using Python's SQL Alchemy

[Benjamin Singleton]

Hi,

I was hoping that somewhere here could walk me through connecting to a DB2 database with SSL enabled using Python's SQL Alchemy. In the past (prior to SSL), I had successfully connected as follows:

** Note: I first used easy_install to install ibm_db and ibm_db_sa.

from sqlalchemy import create_engine

engine = create_engine(r"db2+ibm_db://username:pass...@host.com:port/schema")

 

How do I amend this code to connect using SSL?

Thanks for your assistance,

Ben

[Cam]

I'm having the same issue

[Saba Kauser]

Can you try the following:

import sqlalchemy

from sqlalchemy import *

import ibm_db_sa

db2 =sqlalchemy.create_engine('ibm_db_sa://username:password@host:port/databser;SECURITY=SSL;SSLCLIENTKEYSTOREDB=path to *.kdb;SSLCLIENTKEYSTASH=path to *.sth;')

conn = db2.connect()

or

import sqlalchemy

from sqlalchemy import *

import ibm_db_sa

db2 =sqlalchemy.create_engine('ibm_db_sa://username:password@host:port/databse;SECURITY=SSL;SSLServerCertificate=server.arm;')


conn = db2.connect()

 

You can find more information on setting up SSL connection here:

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/t0053518.html