Abhishek Singh
Abhishek Singh
@JeremyDel It would good to check database name if it is lowercase or uppercase. I am suspecting there is some mismatch in the metadata. ```sql select SYS_CONTEXT('userenv', 'DB_NAME') from dual;...
Also, is this on-prem or Autonomous database ?
Could you try after enabling quoting only for `database` ? ```yaml quoting: database: true ```
We are investigating this. We use python-oracledb as the underlying database driver. So, any external authentication method needs to be supported by the driver
@aadishsanghvi Could you let me know how do you connect to Oracle Database using SQLPlus and Kerberos Authentication ? I am interested in understanding the SQL net configuration used. Also,...
@aadishsanghvi I know of cx_Oracle and python-oracledb. Could you share the code using cx_Oracle to connect using Kerberos ?
Hi @aadishsanghvi We are working on it. The plan is to make this a part of `dbt-oracle==1.9.0` which we plan to release in January 2025.
dbt-oracle uses [python-oracledb](https://oracle.github.io/python-oracledb/) for Connecting to Database. We will check if the Python driver supports LDAP authentication
@VenkatArra Could you give some details ? - is the database On-prem or Autonomous Database in Cloud ? - is the LDAP server in OCI ? - Have you tried...