Configure data validation - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

If you have generated your CSV files using the Exchange Data functionality or created your own CSV files, you must configure data validation of your CSVs by creating import mappings, validation rules, export mappings, and job definitions in the Data Validator Administration module.

Data Validator imports files in CSV format into the staging system where the validation takes place.

  • Data Validator uses import definitions to map the column headers in the input CSV file to the correct column headers for objects, properties, and relationships in the staging area.

  • The import mapping not only uses the physical column headers that already exist in the input data file, but it also supports other column headers that are computed or provided by the user during the import process.

  • Data Validator validates the quality of the incoming data in the supplied files before they are loaded into the system.

For more information, see Using Data Validator Administration.