Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Example of Oracle connection string for DW

Questions
Tags
Users
Badges
Neil Williams
JAZZ DEVELOPER (66●1●6●7) Apr 08 '13, 8:24 a.m.
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

0 votes

1 answer
6,888 views
0 votes

One answer

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

2 votes

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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,516
× 6,132
× 403

Question asked: Apr 08 '13, 8:24 a.m.

Question was seen: 6,888 times

Last updated: Apr 08 '13, 8:41 a.m.

Confirmation Cancel Confirm