Customizing JDBC Output Schema

The JDBC Query activity is provided with a defined schema for output that can be customized based on your requirements.

The output schema can be customized for the following operations:
  • getSnapshot
  • getTagDefinition
  • getArcvalue

Prerequisites

Ensure that you have created the schema file. For more information about the schema file format, refer to the Meta-model-template.xml file under Example > Schemas > Template.

Procedure

  1. From the menu, click Window > Preferences.
  2. In the Preferences dialog box, expand TIBCO Plug-ins > OSIsoft PI System, and then click JDBC Output Schema.
    The JDBC Output Schema pane is displayed.
  3. Next to the schema preference field, click Browse to specify the schema file that you have created.
  4. Click OK. Your customized schema is ready to be loaded.