Data Validator allows the conversion of any object belonging to the Loader Types classification, into a Data Validator job, using the Exchange Load Job Import Validate Export workflow. This ensures seamless transfer of data from a SPF/HxGN SDx based system to another SPF/HxGN SDx based system using the Exchange Data functionality and Data Validator. For more information, see Configure the Exchange Data functionality.
For any object to be used to process data in CSV files, the IVTLJob, IVTLValidationJob, IVTLJobExportDetails, IVTLJobImportDetails, and ISPFConfigurationItem optional interfaces must be added. This schema is required to convert any type of object belonging to the Loader Types classification to a Data Validator job.
You can create a load job for the different types of objects being transferred. The load job itself is created manually or automatically depending on the configuration of the Exchange Data functionality.
The Exchange Load Job Import Validate Export workflow is specified as one of the arguments on the user-defined method configured for running the Exchange Data feature. For more information, see Create a user-defined method for exchanging data. Based on the information specified in the method, the report configuration object and the associated export details object are used to process the load job in the SDVExchangeLoadJob job step of the workflow. After the object is converted into a Data Validator job, the import, validate, and export steps are executed automatically in the Data Validator Job Management module.
The following table provides the process steps used by the workflow:
|
Process step name |
Description |
Arguments |
|---|---|---|
|
SDVExchangeLoadJob |
Converts the load job to a Data Validator job |
None |
|
Import |
Runs the import of the supplied data to the staging area database using a defined job definition. |
None |
|
Validate |
Runs the validation rules on the imported data and generates a validation report. If there are validation errors, the validation report must be approved before the workflow can continue. |
Arg1: VTLValidationReportFile |
|
Export |
Transfers the data to the target system and loads the data to the database. This step starts automatically if there are no validation errors. |
None |
You must use the SDVExchangeLoadJob process step in any custom workflow you configure
for transferring data using the Exchange Data functionality.