It's all about the answers!

Ask a question

Example of Oracle connection string for DW


Neil Williams (66157) | asked Apr 08 '13, 8:24 a.m.
JAZZ DEVELOPER
Folks,

I'm after a real example of an oracle connection string as used in RRDI, I have data warehouse database and am trying to point RRDI at the database.

I have the oracle client installed, I have an entry in the tnsnames.ora, RRDI has the 32 bit oracle driver but I just don't know what the connection string should be.

I found this example and have made some assumptions

"MYCOGNOSDATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = MYDATA.MYCOMPANY.COM)(PORT = 1521)) ) (CONNECT_DATA = (SID = GOSL) (SERVER = DEDICATED) ) )

I think the connection string for RRDI is just MYCOGNOSDATA

It then looks this up in the tnsnames.ora
"

Is this correct?

Thanks
Neil

One answer



permanent link
Francesco Chiossi (5.7k1719) | answered Apr 08 '13, 8:40 a.m.
edited Apr 08 '13, 8:41 a.m.
Hello Neil,

the connection string should be the service name.

The entry in my tnsnames.ora looks like this:
RIDW =
  (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = RIDW)
)
)
and I use RIDW as SQL*Net connect string.

Best Regards
Francesco

Your answer


Register or to post your answer.