Creating Synonyms

Synonyms define unique names (or aliases) for each table, view, transaction or procedure that is accessible from the server. Synonyms are useful because they hide the underlying data source location, identity, transaction or procedure from client applications. They also provide support for extended metadata features of the server, such as virtual fields and additional security mechanisms.

You can create synonyms for supported adapters from the Web Console or the Data Management Console.

Note: Although all synonym creation panes have the same look and feel, the parameters are specific to each adapter. To obtain detailed information for an adapter, click a ? next to a parameter.

Procedure: How to Create a Synonym

To create a synonym, you must have previously configured the adapter. You can create a synonym from the Applications or Adapters pages of the Web Console.

From the Web Console menu bar, click Applications.
The Applications page opens.
Click the New button and select Synonym from the drop-down menu.
The Select adapter to configure or Select connection to create synonym pane opens.
Click a connection for the configured adapter.
The first of a series of synonym creation panes opens.
Enter values for the parameters required by the adapter as described in the synonym creation parameters reference.
After entering the parameter values, click Create Synonym.
The Status pane indicates that the synonym was created successfully.

Note: You can also create a synonym from the Adapters page by right-clicking a configured adapter connection and selecting Create Synonym.