tUniservBTGeneric (deprecated)
Executes a process created with the Uniserv product DQ Batch
Suite.
tUniservBTGeneric sends the data to
the DQ Batch Suite and starts the specified DQ Batch
Suite Job. When the Job execution is finished, the results are returned to the
Data Quality Service Hub Studio for further
processing.
tUniservBTGeneric Standard properties
These properties are used to configure tUniservBTGeneric running in the Standard Job framework.
The Standard
tUniservBTGeneric component belongs to the Data Quality family.
Basic settings
Schema and Edit |
A schema is a row description. It defines the number of fields Click Edit
Click Sync Click Retrieve Schema to create a |
Host name |
Host on which the Master Server of DQ |
Port |
Port number on which the DQ Batch |
Client Server |
Name of the client server of the DQ Batch |
User name |
User name for the registration on the DQ |
Password |
Password of the stated user. To enter the password, click the […] button next to the |
Job directory |
Directory in the DQ Batch |
Job name |
Name of the DQ Batch Suite job |
Job file path |
File path under which the DQ Batch |
Advanced settings
Temporary directory |
Directory in which the temporary files created during job |
Input Parameters |
These parameters must correspond to the parameters in the function
File location: State whether the
Directory: If the File location =
File name: Name of the delimiter
No. of header rec.: 0 = no header
Field separator: Field separator |
Output Parameters |
These parameters must correspond to the parameters in the function
File location: State whether the
Directory: If the File location =
File name: Name of the output
No. of header rec.: 0 = no header
Field separator: Field separator |
Global Variables
Global Variables |
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
tUniservBTGeneric sends data to |
Limitation |
To use tUniservBTGeneric, the Note:
Please note the following:
|
Â
Execution of a Job in the Data Quality Service Hub
Studio
This scenario describes a DQ Batch Suite job which
execution results are processed in the Data Quality Service Hub
Studio. The input source for the job is provided by the Data Quality Service Hub Studio.
The job was completely defined in the DQ Batch
Suite and saved under the name “BTGeneric_Sample”. In the function Input, the file “btinput.csv” was
specified as the input file saved in the job directory and all fields were assigned. The
file is not yet existent physically as it will only be provided by the Data Quality Service Hub Studio, so that the job cannot yet
run.
In the Data Quality Service Hub Studio, the input
source (here a table from an Oracle database) for this scenario was already saved in the
Repository, so that all schema metadata is
available.
Procedure
-
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. -
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. -
Drag the following components from the Palette into the design workspace: two tMap components, tOracleOutput
and tUniservBTGeneric. -
Connect tMap with tUniservBTGeneric first.
Accept the schema from tUniservBTGeneric by
clicking Yes on the prompt window. -
Connect the other components via the Row >
Main link. -
Double-click tUniservBTGeneric to open its
Basic Settings view. -
Enter the connection data for the DQ Batch
Suite job. Note that the absolute path must be entered in the
field Job File Path. -
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. -
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. -
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. -
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. -
Then define how to process the execution results of the job, including which
components will be used. -
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.