Creating Synonyms

How to:

Create a Synonym

Reference:

Checking 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 sidebar, click Applications.

The Applications page opens.
Right-click an application directory, point to New, and click Synonym from the context menu.

The Connect to Data page opens.
Click the down arrow next of a connection or right-click a connection for a configured adapter and click Show DBMS objects.

If the connection is not for a DBMS adapter, the corresponding menu option may be Show files or some other item that indicates that you will select objects for which to create synonyms.

The synonym creation page opens.
Enter values for the parameters required by the adapter as described in the synonym creation parameters reference.
After entering the parameter values, click the button on the ribbon that triggers the synonym creation. It may be Next, or Create Base Synonyms, or some other option that identifies what is being created.

The Status page lists the synonyms in the application directory you selected.

Note:

You can also create a synonym from the Adapters page by clicking Connect to Data on the sidebar.
Right-clicking an application in the DMC also provides an New/Synonym via Synonym Editor option, which enable you to create a synonym using that tool. For more information, see the iWay DataMigrator User's Guide.

Reference: Checking Synonyms

Once you have created a synonym, you can view its properties by right-clicking the synonym and selecting Properties from the context menu.

The Properties page opens and shows the location, adapter, date last modified, and privileges of the connected user for this synonym.

Clicking the Check File button displays the number of errors, number of segments, number of fields, and length of all fields for the synonym.

	WebFOCUS