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

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

It's all about the answers!

Related questions

Example of Oracle connection string for DW

One answer

Your answer