This content has been marked as final. Show 5 replies
Follow this link
If helps pls mark
I am stucjk in configuration step for connect string.
My DB is hosted on machine v-odidev1:1521 with serveice name XE.
i have created user POW_REP with password POW_REP.
what value should i enter in connect string as i have tried so many combinations but they are failing. :(
Make sure to have Oracle client on machine where informatica is installed.
Pls mark if any of info is helped.
I have oracle server and client installed on machine where i am installing INFORMATICA.
Also tnsping to XE works.
tnsping has following entry for XE
(ADDRESS = (PROTOCOL = TCP)(HOST = v-odidev1.persistent.co.in)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
Can you please tell what exactly i need to enter in connect_string?
in data base url you have to use hostname:port
dsn as XE