Error while running DBLINK query in Informatica

Posted on 2009-04-29
Last Modified: 2012-05-06

Can anyone please advise on why I am getting error while running session in informatica for sql query with dblink such as
select name from t1@EXPT. when I run this query in Toad, it works fine on database in which dblink has been created but throgh informatica it gives me below mentioned error-

READER_1_1_1> RR_4035 SQL Error [

ORA-01017: invalid username/password; logon denied

ORA-02063: preceding line from EXPT

Database driver error...
Question by:sunilbains
    LVL 2

    Accepted Solution

    This happens when the connection information stored in the informatica repository is not up to date with the current user/password information for that database.  Go to the Workflow manager, select connections from the menu bar at the top and select the type of connection (usually relational for a database). Then find the connection string for EXPT and click edit.  It will show you the username you are using to connect to the database.  The password is also there but it is hidden.  This is where you can update the password for the userid you are connect with.  click ok after updating the password and try again.

    Author Closing Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Database tuning – How to start and what to tune. This question is frequently asked by many people, both online and offline. There is no hard and fast rule-of-thumb for performance tuning, however, before beginning the tuning process one should a…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now