Procedure - Cloud - 8.0

Uniserv

Version
Cloud
8.0
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Uniserv components
Data Quality and Preparation > Third-party systems > Data Quality components > Uniserv components
Design and Development > Third-party systems > Data Quality components > Uniserv components
Last publication date
2024-02-20

Procedure

  1. In the Repository view, expand the Metadata node and the directory in which you saved the source. Then drag this source into the design workspace.
    The dialog box below appears.
  2. Select tOracleInput and then click OK to close the dialog box.
    The component is displayed in the workspace. The table used in this scenario is called LOCATIONS.
  3. Drag the following components from the Palette into the design workspace: two tMap components, tOracleOutput and tUniservBTGeneric.
  4. Connect tMap with tUniservBTGeneric first.
    Accept the schema from tUniservBTGeneric by clicking Yes on the prompt window.
  5. Connect the other components via the Row > Main link.
  6. Double-click tUniservBTGeneric to open its Basic Settings view.
  7. Enter the connection data for the DQ Batch Suite job. Note that the absolute path must be entered in the field Job File Path.
  8. Click Retrieve Schema to automatically create a schema for tUniservBTGeneric from the input and output definitions of the DQ Batch Suite job and automatically fill in the fields in the Advanced Settings.
  9. Check the details in the Advanced Settings view. The definitions for input and output must be defined exactly the same as the DQ Batch Suite job. If necessary, adapt the path for the temporary files.
  10. Double-click tMap_1 to open the schema mapping window. On the left is the structure of the input source, on the right is the schema of tUniservBTGeneric (and thus the input for the DQ Batch Suite job). At the bottom is the Schema Editor, where you can find the attributes of the individual columns and edit them.
  11. Assign the columns of the input source to the respective columns of tUniservBTGeneric. For this purpose, select a column of the input source and drag it onto the appropriate column on the right side.
    Click OK to close the dialog box.
  12. Then define how to process the execution results of the job, including which components will be used.
  13. Before starting the Job, make sure that all path details are correct, the server of the DQ Batch Suite is running and that you are able to access the job.