community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Changing Orcale Client Configuration from TNS file to LDAP

Atom

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

 

 

Bolide

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:

 

img.JPG

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?

Atom

Thanks a Lot

Labels