How to update Data Connection password for IMAM Import Areas via imam.sh | .bat command

Content

Follow the steps below to update the Data Connection password for IMAM Import Areas via the imam.sh | .bat command.

1) Run the imam command to generate a .csv file with a list of the Data Connections and impacted Import Areas:

On Unix / Linux
<IS Install path>/ASBNode/bin/imam.sh --action testDC -s <<serverName>> -p <<port>> -u isadmin -w ***** -v

On Windows
<IS Install path>\ASBNode\bin\imam.bat --action testDC -s <<serverName>> -p <<port>> -u isadmin -w ***** -v

NOTE:

• Two hyphens (--) are required for action.
• By default, the csv file will be created under C:\Windows\Temp path on Windows server and under /tmp path on Linux and Unix servers.
• The CSV file will be in the following format with COMMA separator.

DataConnectionName, DataConnectionConnectionType, DataConnectionDatabase, AssociatedImportAreas, DataConnectionUserName, DataConnectionPassword

Example:
HDFS_Conn,HDFSFileConnector,clifford.ibm.com,HDFS, srmitta@IBM.COM ,<<Change Password>>

2) Replace <<Change Password>> with new password in .csv file and save changes.

3) Run the imam command below to update the password for the Data Connection / Import Areas.

On Unix / Linux
imam.sh --action updateDCPwd -s server -p port -u isadmin -w ***** -fp /tmp/carve.ibm.com_TestDataConnectionResults7580047693249905483.csv

On Windows
imam.bat --action updateDCPwd -s server -p port -u isadmin -w ***** -fp C:\Temp\carve.ibm.com_TestDataConnectionResults7580047693249905483.csv

4) Repeat STEP 1 and verify the .csv file if there are any Import Areas that still report <<Change Password>>, if yes, then repeat STEP 2 and 3.

5) Log into InfoSphere Metadata Asset Manager web console and verify successful Data Connection in Import Areas.