Alteryx designer Discussions

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

Oracle Connection

Highlighted
Asteroid

Good evening,

 

I am having problem with the Oracle connection.

 

I have the ORA-12154 with the input tool.

 

and Tried Manage in-DB and returns an error the says I need  valid connection string.

 

As attached.

 

I've already tried changing the host name for the IP and nothing happend..

 

Anyone can help?

 

Regards,

 

Tanai

Highlighted
Asteroid

If you have Windows machine please try the connection with ODBC 64 creating system DSN - If it works then we can eliminate the TNS issue. 

If error in creating DSN that means Oracle dll not able to find the TNS file or related entries for the TNS file or some environment variable issue

If no error then you can use the DSN entry in the In-DB setup

Labels