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