Changing Orcale Client Configuration from TNS file to LDAP

[harsesh]

Our Organization had decided to stop using TNS files to connecting to Oracle, and have switch to LDAP

1. How can we update and existing Altreyx Oracle connecting to point to LDAP server instead of and TNSfile name

[rafalolbert · Accepted solution]

Hi harsesh,

A while back we've decided to make our Oracle connections independent from tnsnames.ora setup and this is how we do it.

Both for 'Input Data', 'Output Data' and 'Dynamic Input' tools we go to: 'Other Databases' -> 'Oracle OCI...' and this is the setup form:

For 'TNS Server Name' please insert the full connection string like:

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = port))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = service)))

Please update the 3x parameters as you would otherwise do in the TNS file and provide your credentials and this should work as expected.

We've been operating this access method across a few Oracle data sources for the last few years - this method gives you independence, control and full visibility.

Provided your Oracle tech has a load balancing mechanism, you can provide multiple hosts and this will work as expected. 

Have fun and all the best!

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

[harsesh]

Thanks a Lot