Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Informatica Workflow not able to connect to source database.

657574Sep 5 2008 — edited Apr 12 2010

Hi,

I have completed the installation of OBI Apps.All the test connections are working fine and I have also configured the Relational Connection in Informatica Workflow.The passwords,username and connect string are correct.Still when I run a ETL all the tasks that need to connect to source database fail.I checked the session logs of those workflow and it gave me following error:

READER_1_1_1> DBG_21438 Reader: Source is [UPG11i], user [obiee]
READER_1_1_1> CMN_1761 Timestamp Event: [Fri Sep 05 18:01:37 2008]
READER_1_1_1> RR_4036 Error connecting to database [
Database driver error...
Function Name : Logon
ORA-12154: TNS:could not resolve the connect identifier specified

Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [obiee] and connection string [UPG11i].]

From DAC I am able to connect to the databases.There seems to be some problem in the relational connections.What are the drivers involved and where should they be installed.

Please help.

Thanks and regards,
Soumya.

This post has been answered by Damon A. Runion-Oracle on Sep 5 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2010

Added on Sep 5 2008

#business-intelligence-applications, #workflow

4 comments

6,572 views