Data Source Validation

The validation of a Data Source ensures that all of its components are consistent. The Data Source Designer checks the syntax of files when they are uploaded, but overall consistency must be checked when saving a new or edited Data Source.

When you click the Check Design toolbar item, the Data Source Designer performs a validation based on the following criteria:

• Verify that the tables and columns of the Data Source design exist in the specified data source.
• Verify that all items in each defined set originate in the same join tree.
• Verify that all items reference existing columns.
• Verify that derived tables have valid SQL queries.

• Verify that all items and sets in the security file exist in the Data Source design (if a security file has been uploaded). 
   

  In special cases where you need to create a design before the data source is available, the verification of tables and columns related to a data source can be omitted. This can be accomplished by setting a parameter in the server configuration file.

If validation fails, a message appears to help you correct the error(s). Make the necessary changes to the settings and save your design. If the settings are in the uploaded files, edit the files and upload them again. 
In addition to clicking the Check Design toolbar item, validation also occurs when:

• Opening the Data Source Designer—this check detects any inconsistencies in Data Source designs from uploaded files.
• Navigating from tab-to-tab under certain circumstances—this check detects problems on the tab where they occur.
• Changing the data source.
• Exporting the Data Source design file.
• Clicking the OK button to exit the Data Source Designer. 

Unless you clicked the Check Design item, no message appears when these validations succeed. When validation fails, however, a message always appears to help you correct the error(s).