In this section: How to: |
Synonyms define unique names, or aliases, for each Hive table that is accessible from a server. Synonyms are useful because they hide the location and identity of the underlying data source from client applications. They also provide support for extended metadata features of the server, such as virtual fields and additional security mechanisms.
Using synonyms allows an object to be moved or renamed while enabling client applications to continue functioning without modification. The only modification required is a redefinition of the synonym on the server. The result of creating a synonym is a Master File and Access File based on a given Hive table.
To create a synonym, you must have previously configured the adapter and a connection.
or
From the Data Management Console, expand the Applications folder.
The Select Adapter dialog box opens.
The Select Synonym Candidate dialog box opens.
The Create Synonym for MongoDB dialog box opens.
The Status pane indicates that the synonym was created successfully. The synonym is created and added under the specified application directory.
How to: |
SQL Data Type mapping options are available in a report available from the Web Console.
To access the Data Type Report:
The Filter Data Types Report page opens, as shown in the following image.
The Filter Data Types Report is displayed, as shown in the following image.
Note: You can also display the report as a PDF by selecting the Show Report in PDF check box.
WebFOCUS |