Connecting to Data and Creating Synonyms

Aside from uploading data, you can create synonyms by connecting to various data sources. The Connect to Data wizard leads you through this process and allows you to establish a connection to many native data sources. The data source being used determines the type of metadata that is required. For example:

• When the server accesses a relational data source, it needs to know how to interpret the data stored there. You must create a synonym that describes the structure of the data source and the server mapping of the data types.
• When the server invokes a transaction or procedure, it needs to know how to build the request, what parameters to pass, and how to format an answer set from the response. You must create a synonym that describes the layout of the request or response area.

Whatever your data source, the adapter you are using manages the synonym creation process for you, creating a synonym that meets your specific requirements.

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 the question mark (?) next to a parameter.

This topic provides step-by-step information that you can use to connect to data in WebFOCUS.