Changing the Adapter Configuration

How to:

Change the Connection Attributes for an Adapter From the Command Line

The Configured Adapters folder or pane lists the adapters that have already been configured for the current operational instance.

The following general information applies.

Right-click an Adapter folder in the navigation pane and choose from the tasks that are available for that adapter. The following table lists and describes the available tasks, or functions.

Function	Description
Add connection	Adds a connection for adapters that have the functionality to support multiple connections. These can be created in any level profile.
Change Settings	Displays the Change Setting page, where you can change a variety of settings in effect for the selected adapter.
Remove	Removes the adapter configurations and all connection settings from the list of configured adapters.
Help	Provides specific information for the adapter.

Open the Adapter folder in the navigation pane and right-click a version or connection to choose from the tasks that are available for the selected adapter. The following table lists and describes the available tasks or functions.

Function	Description
Show DBMS objects (for different adapters, the working for this option can vary)	Opens the first Create Synonym pane, where you can begin to enter the information required to create a synonym. These panes vary for different adapters. For information, click the ? next to each parameter.
Properties	Enables you to view and change connection parameters. Note: Duplicate entries are not verified.
Test	Runs a select statement for name/owner against a catalog table with a limit of up to 15 records. See How to Test an Adapter Connection.
Duplicate Connection	Creates a new connection with the same parameters and a different connection name.
Test Bulk	Issues a report on whether bulk load is supported for this adapter.
Test DBMS Case Sensitivity	Issues a report on case sensitivity for this adapter.
Impact Analysis	Produces a report of the synonyms that use the connection.
Delete/Remove	Deletes connection settings. Note: Entries are deleted from the profile in which they were created.

Syntax: How to Change the Connection Attributes for an Adapter From the Command Line

The UPDATE_PROFILE option of the edastart -x command enables you to change adapter connection attributes, including the password for an adapter connection. The user must have privilege ADPTP to execute it. The syntax is

UPDATE_PROFILE profile SUFFIX suffix CONNECTION conname NEW_PASS password

where:

profile

Is the name of the profile in which to store the connection attributes, for example, edasprof.

Any profile (edasprof.prf , user/group/role profile) can be updated using this command.

suffix

Is the suffix value for the adapter.

conname

Is the adapter connection to be updated.

password

Is the new password.

Note: The password will be encrypted when it is written to the profile.

The following command updates the password for connection CON01 for the Adapter for Oracle to NewPasswd1 and stores the connection attributes in edasprof.prf.

edastart -x "EX UPDATE_PROFILE edasprof SUFFIX SQLORA CONNDECTION CON01 NEW_PASS NewPasswd1"

The following command updates the password for connection CON02 for the Adapter for SQL Server to NewPasswd2 and stores the connection attributes in user1.prf.

edastart -x "EX UPDATE_PROFILE user1 SUFFIX SQLMSS CONNECTION CON02 NEW_PASS NewPasswd2"

The keywords in the command can be replaced by commas. For example:

edastart -x "EX UPDATE edasprof,SQLORA,CON01,NewPasswd1"

	WebFOCUS