Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Workaround for connecting to Oracle with LDAP authentication

Alteryx
Alteryx
Created

Environment Details


Designer

  • All versions

Oracle

  • All supported versions that use LDAP authentication

Oracle Instant Client

  • 10.02
  • 11.01


Cause


User has LDAP authentication enabled for Oracle database but Alteryx does not natively support LDAP authentication for Oracle.



Resolution


This is a workaround to allow Designer to connect to an LDAP Oracle database.

 

If the user is receiving the error message ORA-12154 "TNS could not resolve service name", the SQLNET.ora file needs to be edited to include both LDAP and EZCONNECT in the NAMES.DIRECTORY_PATH.

Before attempting to edit the SQLNET.ora, confirm with your IT department or DBA that it is alright to do so. Also, confirm that an LDAP.ora file exists in the same directory as the SQLNET.ora file.

Instructions to implement the workaround:

 

1. Close Designer.

2. Open the SQLNET.ora file and edit the variable to reflect below:

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT) and then save.

 

 

3. After the SQLNET.ora file has been edited to reflect the image above, reopen Designer and test your Oracle connection.


Additional resources:
https://docs.oracle.com/
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Connect-to-an-Oracle-Databas...
https://docs.oracle.com/en/database/oracle/r-enterprise/1.5.1/oread/creating-and-modifying-environme...