Managing JDBC DataSource Aliases 

Use

You use this procedure to add or remove aliases for JDBC DataSources. Aliases are alternative names that are used by application components when they look up a JDBC DataSource. All aliases that are defined for a JDBC DataSource are available in the Dependent DataSource Aliases tab of a JDBC DataSource Resource Details area in the SAP NetWeaver Administrator. They become functional – that is, the system binds them in the naming – when the JDBC DataSource for which they are created is started.

When you perform and operation involving the default DataSource, you must restart the cluster node for the changes to take effect.

Prerequisites

You are in the Configuration Management → Infrastructure → Application Resources  function.

Procedure

Creating Aliases

...

       1.      Choose Create New Resource → New JDBC DataSource Alias.

       2.      Enter an arbitrary name for the alias.

       3.      Choose a DataSource for the alias to be directed to from the DataSource Name dropdown list box.

       4.      Choose Save.

Removing Aliases

...

       1.      Select All JDBC DataSource Aliases from the Show dropdown list box.

       2.      Select the alias to be removed.

       3.      Choose Delete Selected Resource.

Redirecting Aliases

...

       1.      Select All JDBC DataSource Aliases from the Show dropdown list box.

       2.      Select an alias from the list.

       3.      Choose Settings in the Resources Details area.

       4.      Choose the DataSource you want to redirect the alias to from the DataSource Name dropdown list box.

       5.      To save your changes, choose the Save button in the Resources Details area.