You can translate the question and the replies:

How to use Kerberos authentication with sqlalchemy

Hi, I try to find an example how to connect to python to denodo using sqlalchemy with kerberos. appreciate any guide. Best regards, Pon
user
06-10-2023 08:55:47 -0400
code

1 Answer

Hi, The easiest way to connect to the Denodo Platform from Python is to use the Denodo Dialect for SQLAlchemy or the psycopg2 driver. We recommend the use of the Denodo Dialect for SQLAlchemy for greater convenience as it is bulit on top of psycopg2 and offers . The SQLAlchemy option also makes it easy to work with pandas dataframes. However, if you need to establish a connection to Denodo using Kerberos or OAuth2 authentication, this is not supported by psycopg2 so you will need to switch to one of the options that make use of the Denodo ODBC driver. In this case we recommend the use of the turbodbc library. This option might also provide a minor performance improvement in some scenarios and, if you intend to use pandas dataframes, using the fetchallnumpy option may improve performance a bit more. For more information, please refer to the following documents, * [HOW TO CONNECT TO DENODO FROM PYTHON - A STARTER FOR DATA SCIENTISTS](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Python%20-%20a%20starter%20for%20Data%20Scientists). * [Denodo Dialect for SQLAlchemy - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Dialect%20for%20SQLAlchemy%20-%20User%20Manual). Hope this helps!
Denodo Team
09-10-2023 08:19:51 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here