Oracle DB Connection Set Up (PL SQL Developer) Enquire

MrDaniels

Hi gurus,

Could you please share some light.

I'm trying to connect to an Oracle Database.

Currently we use PL SQL Developer that only requires Username, Password and the Database Name.

I have been trying to use the Oracle options from Alteryx, and they are asking me for Host, Port, or Server Name. 

Any idea how to connect to Alteryx using same credentials as in PL SQL Developer?

Thanks in advance,

Cheers,

Mr Daniels.

Mchappell67

Hi -

SQL Dev is most likely using a Tnsnames.ora file to define the Database dropdown options.  You can either setup an ODBC connection using the same parameters (user, pass, db) as in your screenshot, or look into the tnsnames.ora file and get all of the parameters you need for the other connection types (server, port, sid).

Mark