Accessing Data and Creating Synonyms


Before you can create a procedure that reports against a data source, your application must be able to access the data and understand how the data is organized. To obtain this information, your application reads a synonym which generally consists of two files:

  • A Master File that describes the data for WebFOCUS reporting. This file contains field names and formats for the columns in the data source. The synonym also contains an alias for the data source.
  • An Access File that contains additional information needed by WebFOCUS to access data. This information, which is required by many data sources, includes the real name and location of the data source.

Often, a synonym already exists on the server, and reporting can begin at once. However, if the synonym you need does not exist on the server, an authorized server or application administrator can create it directly from Developer Studio using the Create Synonym tool.