Example of Oracle connection string for DW
![](http://jazz.net/_images/myphoto/7f9a96290ea6ec0178bc7ed444d05a97.jpg)
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
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
![](http://jazz.net/_images/myphoto/7f9a96290ea6ec0178bc7ed444d05a97.jpg)
Hello Neil,
the connection string should be the service name.
The entry in my tnsnames.ora looks like this:
Best Regards
Francesco
the connection string should be the service name.
The entry in my tnsnames.ora looks like this:
RIDW = (DESCRIPTION =and I use RIDW as SQL*Net connect string.
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = RIDW)
)
)
Best Regards
Francesco