The Data Veracity Profile is used to select the particular database that Data Veracity will be connected. The profile can also generate the SQL scripts to be used for creating the database tables where the erroneous UDRs will be stored in.
The Data Veracity profile is loaded when you start a workflow that depends on it. Changes to the profile become effective when you restart the workflow.
Configuration
To create a new Data Veracity profile, click the New Configuration button from the Configuration dialog available from Build View, and then select Data Veracity Profile from the menu.
The contents of the menus in the menu bar may change depending on which configuration type has been opened in the currently active tab. The Data Veracity profile uses the standard menu items and buttons that are visible for all configurations, and these are described in Common Configuration Buttons.
UDR Tab
...
The following settings are available in the UDR Tab of the Data Veracity profile:
Setting | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
Database Profile | This is the database the agent will connect and send data to. Click the Browse... button to get a list of all the database profiles that are available. For further information see Database Profile. Data Veracity is supported for use with the following databases:
| ||||||||
UDR Type Mapping | |||||||||
UDR Type Mapping | UDRs to be used by the Data Veracity Profile are listed here | ||||||||
MIM Mapping | |||||||||
Use MIM | Select this check box to allow the use MIMs listed under the Named MIMs table. | ||||||||
Named MIMs | This list will display the user-defined MIMs that can be made available for use by the Data Veracity Forwarding Agent. | ||||||||
Generate SQL | This text box will generate the SQL statements for the selected UDRs' table schema and indexes for the TXN_ID, ERROR_CODE, INSERT_TIME and STATE field. The schema will be generated based on the number of UDRs in the UDR Type Mapping table. Click the SQL button to generate the SQL statements.
| ||||||||
Batch Tab
...
The following settings are available in the Batch Tab of the Data Veracity profile:
Setting | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
Database Profile | This is the database the agent will connect and send data to. Click the Browse... button to get a list of all the database profiles that are available. For further information see Database Profile. Data Veracity is supported for use with the following databases:
| ||||||||
Enabled | This checkbox enables the batch mode configuration. | ||||||||
Table Name | Enter the table name that is to be used with this profile. | ||||||||
MIM Mapping | |||||||||
Use MIM | Select this check box to allow the use MIMs listed under the Named MIMs table. | ||||||||
Named MIMs | This list will display the user-defined MIMs that can be made available for use by the Data Veracity Forwarding Agent. | ||||||||
Generate SQL | This text box will generate the SQL statements for the selected UDRs' table schema and indexes for the TXN_ID, ERROR_CODE, INSERT_TIME and STATE fields. The schema will be generated based on the number of UDRs in the UDR Type Mapping table. Click the SQL button to generate the SQL statements.
| ||||||||
Generate SQL Dialog Box
When a user clicks on the Generate SQL button in either tab, the associated dialog box will open. Here the generated SQL statement can be viewed.
...