SQLAlchemy create_engine connection string with Microsoft ODBC datasource User DSN

Question

Does anyone know how to pass connection string into create_engine function? I use Window and has a ODBC datasource with DSN that set up by IT department.

My ODBC DSN connects to Postgres database.

Does anyone know the library or connection string to make this to work?

Note that I cannot ask them for the username and password to access the Postgres directly. I only can connect via ODBC only.

Thank you very much.

Answer 1

The below worked for me:

engine=create_engine("mssql+pyodbc://user:password@DSNSTRING")