Forming Oracle database connection using Host, Port, SID

shaunak_bangale

Looks like Oracle database connection can be formed through either standard way or TNS server way.

I have the standard parameters: Host, SID, Port

Oracle connection in Alteryx, however, asks for TNS Server Name, Username, Password.

Just by putting Host as TNS Server Name, the connection is not getting formed.

What is the best way to connect using these available parameters?

Which connection has it? I tried some of them and maybe there are called something different and I am not able to recognize it. 

Appreciate your help!

Regards

Shaunak

dataMack

In the Alteryx box for TNS name you put the name fron your TNSNAMES.ORA file, not the host and port- that stays in the TNSNAMES.ORA file

So, using the example TNSNAMES entry from the website I linked to in the message above:

ORA11 =
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = ORA11)
 )
)

You would just put 'ORA11' in the Alteryx box for TNS Name and thne your username and password.

You can think of the TNSNAMES.ORA as a mapping file that makes it easy for an end user to connect- all you ever have to remember is 'ORA11' and your credentials.  TNSNAME files are typically managed at the enterprise level and pushed down to users' machines.  That way if the host or port every changes, it won't impact your queries because that file handles the details of where to point when you want to connect to 'ORA11'