How to update an existing encrypt adapter connection password via a command line


Technique

Product: Reporting Server
Release: 8205
Primary OS: Linux
Solution Date:

Problem

How to update an existing adapter's encrypted password via a command instead of using the Reporting Server's Web Console.

Solution

To update an existing adapter's encrypted password via a command line, refer to edastart Command Option for Updating Connection Attributes and 



use the UPDATE_PROFILE command in release 7.7.07M / 8.2M gen 1074 or higher:



UPDATE_PROFILE prof SUFFIX suffix CONNECTION conname NEW_PASS passwd



where:



prof: Is the name of the profile in which to change the attributes.



suffix: Is the suffix for the adapter whose connection attributes are being updated.



conname: Is the name of the connection for which the attributes are being updated.



passwd: Is the new password for the connection.



Any profile (edasprof.prf, user/group/role profile) can be updated using this command. Please note, the user needs to have privilege ADPTP to execute it. 



For example, to update Oracle Adapter connection CON01 in the Server's Global profile (edasprof), specify the following:



        UPDATE_PROFILE edasprof SUFFIX SQLORA CONNECTION CON01 NEW_PASS NewPassword



For additional information, refer to the How to Change the Connection Attributes for an Adapter From the Command Line section of the 8205 Server Administration manual.