This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Oracle Instant Client
User has LDAP authentication enabled for Oracle database but Alteryx does not natively support LDAP authentication for Oracle.
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...