Example of Oracle connection string for DW

Neil Williams (66●1●6●7) | 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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Francesco Chiossi (5.7k●1●11●19) | 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

It's all about the answers!

Related questions

Example of Oracle connection string for DW

One answer

Your answer