Understanding Data Source Registration

A data source registers the schema and sample data design files. The extracted application fields from the data source files are placed into the template files to create the final report.

The data source can be PS Query, Connected Query, Composite Query, or XML files.

Note:

PeopleSoft queries with in tree prompts are not allowed as a data source.

For PS Query data sources, BI Publisher runs RunToFile() to obtain the XML data for a report. The RunToFile function uses the language code specified in a user's profile to obtain the data. If you want to run a report that requires to be translated, you must create a user and in the user profile select the language code for which the report has to be translated. Use this user to run the report for translation. For example, if you want a report to be translated into Spanish, you need to select the language code for Spanish in the user profile, and use this user to run the report.

Benefits of data source registration include the ability to:

1. Reuse previously registered data sources with multiple report definitions.

2. Take advantage of built-in bursting features.

   See Setting Bursting Options.

Note:

When creating a report definition, you can select a PS Query, Connected Query, or Composite Query data source that has not yet been registered and that data source is registered automatically when you save the report definition. However, all other types of data sources must be registered before they can be associated with a report definition.

Note:

You can check the format of an XML output file by opening it using any supported browser. The browser opens the file and alerts you to any problems, such as unclosed tags.