The JDBC Query activity is provided with a defined schema for output that can be customized based on your requirements.
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
From the menu, click
Window > Preferences.
In the
Preferences dialog box, expand
Tibco Plugins > OSIsoft PI System, and then click
JDBC Output Schema.
The
JDBC Output Schema pane is displayed.
Next to the
schema preference field, click
Browse to specify the schema file that you have created.
Click
OK. Your customized schema is ready to be loaded.
