Workaround for connecting to Oracle with LDAP authentication

[TessaS]

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...

[IMSHAH]

Hello @TessaS, Can you please reupload the Image or fix the link of the image. We are having no luck with Oracle LDAP authenticaion - and your suggestion may work for us. Thanks a lot in before.