HOWTO: Reset Informatica connection password to backend Oracle database

HOWTO: Reset Informatica connection password to backend Oracle database

Issue: Having had the backend Oracle database change from 10g -> 11g, I now find when running a Task in Informatica it hangs with an invalid password message, which is odd as I’m sure the Admin console db connections are all ok!:

Screenshot1 showing the Workflow Monitor failing a task:

 

 

 

 

 

First Error Code: 1022

Error Code: CMN_1022 Database driver error…
CMN_1022[
Database driver error…
Function Name : Logon
ORA-01017: Invalid username/password; logon denied

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

Solution: The cause is that an individual Task uses a given database user to connect to the backend and process its commands separate from those defined at AdminConsole level. On the Task Properties page the following two parameters are used to set this up:

Task Properties page connection parameters

 

 

 

 

 

 

$Source Connection Value

$Target Connection Value

Hopefully the same username is appearing here as in the above Informatica error msg! By selecting the edit button beside these parameters you can select a number of predefined Connection objects to transform data. Unfortunately you are not able to directly edit the password here…

connection browser with no edit button

 

 

 

 

 

 

 

To do this use the ‘Connections->Relational…’ item from the top bar menu.

Relational connections browser screen

 

 

 

 

 

 

 

Then use the edit button to change/update the required connection details, such as password etc.

Relational connection object definition editor