| Icon | Full Name | Abbreviation | Description |
| Cockpit | The cockpit gives an overview of the application. This overview can be of two types one view is the view for the individual who is logged in at this time and another view is the group view. You can toggle between the two views with the provided toggle switch. | ||
| Admin Console | An Admin Console gives an overview of how an Admin pro user can control different users’ activities and other security parameters at an administrative level. | ||
| System Preferences | System Preferences is a part of Admin console module. Using system preferences, we can set and perform different preferences activities with respect to the application | ||
| Query Studio (Global Query Settings) | Global Query Settings is a part of System Preferences. Using Global Query Settings, the user can set all the queries related functionalities like the Scalar and Aggregate Functions. Apart from these functionalities, the user can also set other query parameters like Joins, Join Operators, Filter Operators, Summary Data Types, Non-Summary Data Types, and Additional Settings. | ||
| Instance Preferences | Using Instance Preferences, an admin pro-user can configure the following settings such as Global Settings, Email Settings, LDAP Settings, and FTP Settings | ||
| Third-Party Integration | Third-Party Integration is a part of the System Preferences session page. Using this preference, an admin pro-user can use different third-party integrations and add instances related to Jira, Azure DevOps, Q-Test, HP QC ALM, and IMDB. | ||
| Middleware Information | Using Middleware Information, the user can view the middleware current running status and if it is accidentally stopped; the user can also restart it. Here within Middleware Information tile, an admin pro-user can perform different actions such as Check Middleware Status, Restart MiddleWare, and Get Logs. | ||
| Reporting Characteristics | The Reporting Characteristics such as Quality Dimensions, Risk Categories, and Data Domains are helpful in setting up different checks for the Validation Rules widgets by the users. These Reporting Characteristics can be chosen from the Validation Rules widgets while creating different Validation Scenarios. Apart from this, the user can also add new Reporting Characteristics from the click of a button. Some of the Quality Dimensions listed here are Accuracy, Consistency, Integrity, Timeliness, Uniqueness, Validity, Completeness etc. | ||
| Available Drivers | Available Drivers is a part of the System Preferences session page. Using this option, an Admin Pro-user can download the Available Drivers software from a variety of available options such as Hive, SAP HANA, TERADATA, Redshift, Amazon S3, and Impala. | ||
| API Tokens | This session gives an admin pro-user the details of API Tokens of different Scenarios. An admin can perform the following actions such as Copy, Change Expiry Date, Activate, DeActivate, History, and Re-generate an API Token. Apart from this, the user can also Migrate an old API to a new API. | ||
| Data Retention | Data Retention is a part of System Preferences session page. Data Retention helps in retaining the Data and as an admin pro-user, the user has the following options such as Retain all, Retain data for the recent number of runs, Retain data only for the last number of days, and Retain data since (Data Retention date format). | ||
| Server License Configuration | Server License Configuration is a part of System Preferences session page. Using this option, an admin pro-user can extend the server license either through an online or offline procedure. Apart from this, an admin pro-user can also view the details of used/total Pro User License Keys and Display User License Keys. | ||
| Custom Email Template | An admin pro-user can create a Custom Email Template by adding the custom header and custom body/layout. The email templates are classified into three categories namely Default template, Custom template with default layout, and Custom template with custom layout. | ||
| Frontend Logs | Under the Frontend Logs session, an admin pro-user can check the Frontend Logs information such as the User Logs details, Log Files related to the user, and File Content related to a particular log. | ||
| Troubleshoot | The Troubleshoot option is a part of System Preferences session page. With this preference setting, an Admin pro-user can troubleshoot the Folder Paths-related issues at the click of a button. | ||
| Profiles | The profiles option is a part of the Admin Console module. All the user/users created details of profile names, source names, source types, user-created details, profile-created date and time, profile-modified details, and profile-modified date and time are displayed under this session in a tabular grid pattern. | ||
| Content Management System | Using CMS, Users can search Queries, Query Chains, Scenarios, or Jobs based on different search criteria such as Profile Name, Created On, Created By, and Folder options. Apart from this, the user can also download, import, export, and bulk copy different contents from the ‘Content Management’ session page located in the Admin Console module. | ||
| Security | An Admin pro-user can use this Security option to control different Users and their activities. Users and User Groups are its components. | ||
| Users/User Groups/All Users/Logged in Users |
Users: Under the users’ session, an admin pro-user can view the details of ‘All Users’ and the ‘current logged in user’ details. Apart from this an admin pro-user can also add a new user, or unlock different users.
User Groups: An admin pro-user can add users to different user groups. To add a new user group, an admin has to enter the details such as the Group Name, Description, Users, and Profiles.
All Users: We can view this icon in the cockpit module. This icon shows all users activities which includes system activity, reconciliations, asset inventory, validations, and database metrics details.
Logged in Users: Logged in users icon displays only the logged in users. |
||
| Data Management | Data Management is a part of the Security option. Under the Data Management session, an admin pro-user can view the individual dashboard details of Reconciliation Scenario Exception Data, Query Chain Snapshot Data, Validation Scenario Exception Data, RD Internal Tables, Scenario Original Ingested Data, and Others. | ||
| Recycle Bin | Using this feature, users can restore the deleted content such as Profiles, User Groups, Queries, Query Chains, Jobs, and all other Scenario types namely FDRs, TDRs, Validations, BDVs, and QPTs. The default retention time period is set to 30 days. Users can also change the default retention time period based on their requirements. The contents in the Recycle Bin get deleted permanently beyond the specified retention time period. | ||
| Query Studio Module | Using Query Studio module, users can run different Queries, Query Chains, and Auto Generate Queries. | ||
| Query Explorer | The created Queries, query chains and folders are displayed within the query explorer session page. We can perform different actions such as create, rename, copy, and move any selected folders or files. | ||
| Query | The Query is a part of the Query Studio module. Using Query, users can execute single or multiple SQL Queries by selecting the desired data source profile. Users can also add a Variable and run queries accordingly. | ||
| Query Chain | Query Chain is a part of the QUERY STUDIO module. A Query Chain runs and executes data using different profiles. A Transformation tab transforms the data. The transformed data is loaded to an Output tab. Users can also send the executed Query Chain data to the desired email address through an Email widget from the additional options tab. | ||
| Auto Generate Queries | This is a faster way to generate multiple queries in simple and easy steps. We can just upload an excel file with the query definition and create all the queries in one go. | ||
 |
Explore Extracts | Explore extracts displays the details of all the executed Query Chains. Here, we can view Extract Name, DB View Name, query chain name, Status, Record Count, Actions like (View, Download, Delete, history) duration, executed by, executed on, and path. | |
| Explore Data Profiling | Explore Data Profiling is a part of the Query Studio module. This session gives a depth analysis of Data Profiling widget details used in different Query Chains. It has a tabular grid with details such as Profiling Name, Database View Name, QueryChain Name, Status, Actions, Duration, Executed By, Executed On, and Path. | ||
| Variable Explorer | Using Variable Explorer, users can add a value to a variable through Variable Builder. Users can append these variables in REST API or SOAP API and run them in any Query Chains, FDRs, or Validation scenarios. Variable Explorer has 3 main tabs namely Predefined variables, Predefined functions, and User-defined variables. New variables created by users will be added to the User-defined variables list. | ||
| Scenario Studio | Using Scenario Studio, users can create different scenarios such as Functional Data Reconciliation (FDR), Validation, Technical Data Reconciliation (TDR), Bulk Data Validation (BDV), Auto Generate FDR Scenarios, and Query Performance Testing (QPT). | ||
| Scenario Explorer | Scenario Explorer is a part of the Scenario Studio module. This session gives the details of different Scenarios created by users such as FDRs (Functional Data Reconciliation), Validations, TDRs (Technical Data Reconciliation), BDVs (Bulk Data Validation), Auto Generate FDR Scenarios, and QPTs (Query Performance Testing). It has a tabular grid with details such as Name, Path, Created By, Created On, Modified By, and Last-Modified. | ||
| Functional Data Reconciliation | FDR | Functional Data Reconciliation is a part of the Scenario Studio module. Using FDR, users can compare a pair of data sets (source and target) to the field by field level and this option is the most comprehensive way to reconcile data between all DataTrust supported data sources. | |
| Business Rule Validations/Validations | BRV validates all DataTrust supported data sources against the pre-delivered set of validation rules or custom business rules which can be created using the application’s rule builder. | ||
| Technical Data Reconciliation/TDR Session Monitor |
Technical Data Reconciliation: Technical Data Reconciliation (TDR) is a part of the Scenario Studio module. Using TDR, users can perform a row count of data comparison between multiple pairs of data sets.
TDR Session Monitor: TDR (Technical Data Reconciliation) Session Monitor is a part of the Scenario Studio module. This session gives the details of all the TDR Scenarios In-Progress, Completed, Errored, and ALL Sessions status. |
||
| Bulk Data Validation | BDV | Validating data in bulk can be a challenging task when data is distributed over multiple tables/views/files. Moreover, if there are many datasources and many validation rules to be applied, creating different scenarios for each datasource and going through the ordeal of applying different rules on each of them separately becomes exhausting. Bulk data validation (BDV) scenario helps you to overcome this challenge in an easy way. | |
| Auto Generate FDR Scenarios | Using Auto Generate FDR Scenarios option, we can create bulk FDR scenarios at one go. we can create Auto generate FDRs in 2 different ways namely Auto generate FDR using Data source or Auto generate FDR using Excel file. | ||
| Query Performance Testing | QPT | Users can test the performance of SQL queries against a baseline ‘expected runtime’. The actual query runtime can be compared with the expected runtime and categorize the scenario outcome into – Pass, Information, Warning, or Fail. | |
| FDR Session Monitor | FDR (Functional Data Reconciliation) Session Monitor is a part of the Scenario Studio module. This Session gives the details of all the FDR Scenarios Running, Passed, Failed, or Errored status. | ||
| Validation Session Monitor | The Validation Session Monitor is a part of the Scenario Studio module. This session gives the details of all the Validation Scenarios Running, Passed, Failed, and Errored status. | ||
| Reconciliation output | Reconciliation output gives the summary details of all FDR scenarios like the scenario name, folder path, executed by, start time, end time, duration, and result status. | ||
| Validation Output | Validation output provides the summary of all the validation scenarios such as Scenario Name, Executed By user details, Executed On date and time details, execution duration, dataset count, and passed, failed, or errored status details. | ||
| Batch Console | Using Batch Console, users can design and run a Job. | ||
| Job Explorer | Using Job Explorer, we can retrieve all the information related to Jobs such as created, All Jobs, Scheduled, and Running. Apart from this, we can also view the specific Job’s path, last run time, next run time, status, duration, created by, modified by, and last modified details. | ||
| Job Designer | Job Designer is a part of Batch Console module. Job Designer can group the scenarios logically to find a pendency if any and configure the execution. The Job Designer has three types of scheduling options namely Execute Now, Execute On, and Repeat Schedule. | ||
| Reporting | DataTrust visualizes data reporting metrics using different types of dashboards such as data quality metrics, data quality dimensions, Row counts compare, reconciliations, scenario execution history, and Asset Inventory. | ||
| Data Quality Metrics Dashboard | This is used for reporting the data quality metrics by scenario type with top ten analysis. Data exceptions count by data points with the drill-down capability. | ||
| data quality dimensions Dashboard | This is used for reporting data quality, Health metrics by risk category, data domain hierarchy and by data quality dimensions, along with drill-down capability and historical trend reporting. This dashboard is more centered towards data governance teams, where the validations performed or categorized into data quality dimensions like accuracy, completeness, integrity, conformity, consistency, etc. | ||
| Row counts compare Dashboard | This dashboard provides the TDR row count comparison result of the dataset between source and target systems. We can view the details such as number of unique scenarios, total number of unique pairs, number of pairs matching, number of pairs mismatching, and number of pairs errored. | ||
| Reconciliations Dashboard | This dashboard provides the FDR data comparison result in daily, weekly and monthly buckets. We can view the details such as number of unique scenarios, total number of unique pairs, number of pairs matching, number of pairs mismatching, and number of pairs errored. | ||
| scenario execution history dashboard | This dashboard provides the history data by given number of days. Here, we can view the past 10 days scenario exception reports along with the number of scenario session runs. Apart from this, we can also view different scenario execution statuses like pass, fail or errored. | ||
| Asset Inventory dashboard | This dashboard provides the list of all assets created in the system. Here, we can view the list of all scenario assets created by logged-in user and also scenario assets created by all users. | ||
| Incident Management Digital Board | IMDB | It is DataTrust’s native “Incident Management Digital Board”. IMDB collaborates well with Scenarios. It is built based on KANBAN approach Once IMDB option becomes part of the Scenarios. Incident management, fixing of bugs, executing scenarios repeatedly based on the status of the incident …etc… can happen with lot of ease. This whole mechanism helps CICD process tremendously in Agile Scrum deployment process as part of DevOps integration. | |
| Notification | Notifications are the activity alerts of the logged-in user. | ||
| New Session | Clicking the new session icon navigates the user to the same page where the user was but in a new tab. | ||
| Bookmarks | Bookmarks icon is used to bookmark any required folder or file and to quickly access them when required in any furture point of time. | ||
| User Profile | The logged-in user profile picture is visible here. | ||
| Settings/Custom validation report |
Settings: A settings icon is used to add the basic settings when required by the user.
Custom validation report: Using this icon, we can prepare a custom validation report based on specific columns as per the requirement.
|
||
| Switch to All Users | We can view this icon in the cockpit module. This icon shows all users activities which includes system activity, reconciliations, asset inventory, validations, and database metrics details. | ||
| Switch to Single User | This icon shows the logged-in user activity such as system activity, reconciliations, asset inventory, validations, and database metrics details. | ||
| Edit | Edit button icon is used to edit any contents based on the users choice. | ||
| Copy/Duplicate/Duplicate FDR/Duplicate TDR/Duplicate Validation/Duplicate Query Chain/Duplicate BDV | A copy/duplicate icon is used to copy or dupliacte any content(s) based on the user requirement. Similarly, we can use the same icon to duplicate any FDR, TDR, Validation, BDV, or Query Chain based on the requirement. | ||
| Profile enable or disable/Toggle Switch/Copy or move/Bulk copy or export-import icon |
Profile enable/disable: A profile enable or disable icon is used to activate or deactivate any established profile connection based on the requirement.
Toggle switch: A toggle switch is used to switch inbetween two options.
Copy or Move: We can either switch between copy or move for selected queries, query chains, scenarios, or jobs within content management system.
Bulk copy or export-import icon: This icon is a part of content management system. Here, the user can switch between bulk copy or export/import options for queries, query chains, scenarios and jobs. |
||
| Show All/test connection/Test results | Show All icon is used to show all created folders and files in all explorer pages. The same icon also represents a test connection icon which is used to test any created connection profile. Apart from this, we can also use this icon to test result any selected variable. | ||
| Where Used List | A where used list icon displays the objects which are used in different scenarios. For example, a custom email template used in an FDR. | ||
| Rename | User can rename any contents. | ||
| Delete | A delete icon is used to delete any content. | ||
| Refresh | A ‘Refresh’ button is used to refresh any session page. | ||
| Export to CSV | An ‘Export to CSV’ icon is used to download and verify all the contents in a CSV format. | ||
| Fail execution status | This icon indicates the failed execution status of different Queries, Query Chains, scenarios, or jobs. | ||
| Pass execution status | This icon indicates the pass execution status of different Queries, Query Chains, scenarios, or jobs | ||
| Search | A search icon is used to search for any contents within a page | ||
| Plus Profile | A plus profile icon is used to add a new profile connection. | ||
| Folders only | Folders only icon displays only the folders and is found in all explorer session pages | ||
 |
Contents Only | Contents only icon displays only the contents/files and is found in all explorer session pages. | |
| History/Historical Mapping |
History: A history icon is used to check the overall history of different parameters such as user logged-in history, query chain execution history in explore data profiling page, etc.
Historical Mapping: Historical Mapping icon helps in mapping based on the previous mapping history.
|
||
| Choose Table Fields | Choose table fields icon is used to add or remove selected columns based on the user requirement. | ||
| Plus New Folder | A 'Plus new folder' icon is used to add a new folder and is available in all explorer session pages. | ||
| Load more | A load more icon is used to load more contents if a session page has more data. | ||
| Hamburger menu | A Hamburger menu icon is found in all explorer pages. Clicking this icon populates different options such as delete, rename, move, security, properties, and modules | ||
| Browser Folders/Root Folder |
Browser Folders: Browse folders icon is used to upload or browse local files into the DataTrust application.
Root Folder: This icon indicates the root folder |
||
| Calendar | Users can filter different queries, scenarios or jobs using this calendar icon. Apart from that user can also add an expiry date to an API token. | ||
| Generate export file | Generate export file is used to generate and export any execution report results. | ||
| Reference Data | Reference data icon represents referential integrity check validation. In this validation rule, we need to select the fields to be verified and provide the list of values to be verified against. | ||
| Range Check | 'Range Check' business rule enables the users to check the value for the selected field to meet the defined range criteria. | ||
| Length check | In length check validation rule, data length of the value in the selected field must meet the defined length criteria. | ||
| Presence Check | ‘Presence Check’ enables the users to apply business validation rules that should not be null for the selected fields. | ||
| Custom SQL | The custom SQL icon represents the custom SQL data source. | ||
| Projection | A Projection Transformation in Query Chain is used to change the existing Data Type in any column(s) and can also use to add the Alias Name column if required. | ||
| Positive check | ‘Positive Check’ enables the users to apply business validation rules to ensure the values in the selected field must always contain positive numbers. | ||
| Negative check | ‘Negative Check’ enables the users to apply business validation rules to ensure the values in the selected field must always contain negative numbers. | ||
| Auto Generate FDR | The auto-generate feature enables you to create data reconciliation scenarios in a faster and easy way. | ||
| RDBMS Table | This icon represents RDBMS Table datasources | ||
| Lowercase | ‘Lowercase Check’ enables the users to apply business validation rules to ensure the values in the selected field must always be in Lowercase. | ||
| Uppercase | ‘Uppercase Check’ enables the users to apply business validation rules to ensure the values in the selected field must always be in Uppercase. | ||
| SalesForce | This icon represents SalesForce datasource. | ||
 |
PowerBI | This icon represents PowerBI datasource. | |
| Tableau | This icon represents Tableau datasource. | ||
| REST API | This icon represents REST API datasource. | ||
| We can send the execution results of any execution through an email. | |||
| SAP Table | This icon represents SAP Table datasource. | ||
| SOAP API | This icon represents SOAP API datasource. | ||
| SAP Infoprovider | This icon represents SAP Infoprovider datasource. | ||
| Date format check | We can check Date format check validation rule using this icon | ||
| Pattern check | ‘Pattern Check’ enables the users to ensure the value for the selected field must be in the defined pattern format. | ||
| Custom Business Rule | Using ‘Custom Business Rule’, the user can apply different conditions on different columns to meet the defined custom business rule. | ||
| Duplicate Check | 'Duplicate Check' defines a rule that one or more combinations of the fields from the dataset should be unique. | ||
| Data Source | This icon represents all the data sources. | ||
| Transformations | Transformations icon is a part of Query Chain. Users can transform the data using different transformations such as Projections, aggregations, filters, de-dups, pivot, un-pivot, Join, union, and Fuzzy lookup | ||
| Aggregation | An Aggregation Transformation in Query Chain is used to perform different aggregate functions such as Count, Minimum, Maximum, Average, and Sum. | ||
| Additional options |
We can view this icon in query chains, scenarios, and Jobs. We can add additional options such as email, IMDB, Jira, XRAY, etc., to the executions.
We can also view additional options icon in the Map source & target fields widget which has different options such as allow duplicates in the comparison, save matching data, and automatically map new columns by name. |
||
| Add Comments/Add scenario level comments |
Add Comments: An Add comments icon is used to add any comments to widgets used in scenarios.
Add scenario level comments: This icon is used to add comments at a scenario level. |
||
| Special Character | In the ‘Special Character Check’ business validation rule, the values in the selected field must not contain any special characters excluding the defined exceptions. | ||
| Qlik | This icon represents Qlik datasource. | ||
| Jira | Jira is a third party integration tool and all the exceptions are recorded as bug in the Jira dashboard. | ||
| XRAY | XRAY is a third party integration tool and all the exceptions are recorded as bug in its dashboard. | ||
| Dataset Count | In this business validation rule, the record count of the selected dataset must meet the defined record count criteria. | ||
| Latest output | Latest output icon navigates the user to the latest FDR or validation scenario exceptions session page | ||
| Execution History | Execution history icon indicates the execution histories such as date and time for different queries, query chains, scenarios and Jobs | ||
| Line Chart | Clicking the Line Chart icon transforms the existing representation to line chart format. | ||
| Tabular view | Clicking the Tabular view icon transforms the existing representation to Tabular view format. | ||
| Expand | An expand icon is used to expand any page or window screen. | ||
| Close | A close icon is used to close a window or tab within the application. | ||
| Pie chart | Clicking the Pie chart icon transforms the existing representation to pie chart format. | ||
| User status | This icon lets other users in the application know about the selected user's active or inactive login status. | ||
| Plus user | This icon is used to add a new user to the application. | ||
| Locked users | If a user enters wrong login credentials for a couple of times, then this user will be moved to the locked users category and here an admin prouser has to unlock the locked user. | ||
| Plus user group | Plus user group icon is used to add a new user group as per the user requirement. | ||
| Restore | Restore icon is used to restore the deleted contents from the recycle bin page. | ||
| RecycleBin Info/Profile info |
RecycleBin Info: A RecycleBin Info icon gives information about its usage info such as delete, restore, and remaining days.
Profile info: The profile info icon gives the details of the selected profile. |
||
| Navigator | The navigator displays the schemas, folders, and tables. Users can pick a table from the navigator. | ||
| Compile | Users can compile any SQL in a query using this icon. | ||
| Pretty print | Prettyprint icon converts and presents the source code or other objects in a legible and attractive way | ||
| Save | A save icon saves an execution such as a query. | ||
| Execute now | An execute now icon executes any query, query chain, scenario, or job. | ||
| Help | Help icon gives the user the context of any feature within the application. | ||
| De Dups | This icon is a part of query chain. Using this icon, we can remove Duplicate data from the selected column(s) | ||
| pivot | This icon is a part of Query Chain transformation tab. Pivot transformation icon in query chain creates multiple columns from the unique row values of a single column. Pivot is an aggregation transformation where you select group by columns and generate pivot columns using aggregate functions. | ||
| Unpivot | This icon is a part of Query Chain transformation tab. The Unpivot transformation in Query Chain makes an unnormalized dataset into a more normalized version by expanding values from multiple columns in a single record into multiple records with the same values in a single column. | ||
| Join | This icon is a part of Query Chain transformation tab. Use the join transformation to combine data from two sources or streams in a mapping data flow. The output stream will include all columns from both sources matched based on a join condition. | ||
| Union | This icon is a part of Query Chain transformation tab. A Union transformation joins two similar or multiple sets of columns data into one. | ||
| Fuzzy Lookup | This icon is a part of Query Chain transformation tab. Using Fuzzy lookup, we can join two datasets using proximity matching | ||
| RD Output | All the transformed and executed data is finally collected in the RD Output tab in Query Chain. | ||
| Offline File | From the RD Output, we can offload the executed data. We can view this option in Query Chain. | ||
| Execute with Run-time parameters/Re-run |
Execute with Run-time parameters: Using this option, an end-user can change the parameters such as source and target profile, source and target columns count, packet size, parallelism, etc. during the run time.
Re-run: Re-run option helps to rerun only the errored DB Tables/queries/dataset pairs etc., without initiating the whole execution again. |
||
| Return to explorer | Return to explorer icon navigates the user to the explorer session page. | ||
| Monitor mode | A monitor mode is displayed when we run a query chain, FDR, or validation. | ||
| Enable external link for scenario exceptions | Users can now enable/disable the scenario exceptions summary external links. If users enable the scenario exceptions summary link from the exceptions summary page, an external link is generated where they can view the results even without logging into the console. | ||
| Iterative ingestion | We can iterate over a set of values and ingest the data. The iteration process takes place looping in between a set of key values. Currently, we have this option in Query chain and FDR. | ||
| Execution history JSON/JSON |
Execution history JSON: An execution history JSON is generated during query chain, scenarios, and Job execution.
JSON: We can use a JSON file as a Data source. |
||
| SAP Lite | This icon represents SAP Lite datasource. | ||
| Reconciliation output | We can take an FDR output (reconciliation output) as a datasource for comparison in another FDR scenario. | ||
| BW Extractor | BW Extractor icon represents BW Extractor datasource. | ||
| Metadata | We can use Metadata as a data source as a profile snapshot. | ||
| REST API | This icon represents REST API. We can use REST API as a data source in Query Chains, scenarios, and Jobs. | ||
| Fixed Width | We can use Fixed Width as a data source. | ||
| XML | We can use XML as a Data Source. | ||
| View | View icon is a part of explore extracts session page. Clicking this icon loads the selected query chain execution results in a new tab. | ||
| Download summary | This icon is used to download any execution results. | ||
| Create variable | Create variable icon is used to create a new variable. | ||
| Multiple selection | A multiple selection icon is used to add multiple inputs which may be values, columns, or tables based on the requirement. | ||
| Move | A move icon is used to move any file or folder to another location. | ||
| Generate RD service | We can use this icon to generate an API and run the execution outside the application. | ||
| Switch profile | A switch profile icon is used to switch the existing query, query chain or scenario profile connection. | ||
| Create new job | Clicking this icon navigates the user to a new Job designer session page. | ||
| SSRS (SQL Server Reporting Services) | We can use SSRS as a Data Source. | ||
| Map source and target fields | We can view this icon in both FDR and TDR. This icon is used to map both source and target widgets. | ||
| Smart Mapping | Smart mapping helps in mapping two familiar columns/rows based on similarity. | ||
| Delete all mappings | Delete all mappings icon deletes all the previously mapped columns/rows. | ||
| Delete selected mappings | Delete selected mappings icon deletes only the previously selected mapped columns/rows. | ||
| Upload Mappings | Upload Mappings icon helps in uploading the mappings from the local drive. | ||
| Re-sync | We have re-sync icon both in FDR and Validation scenarios. In FDR scenario, when we delete any source/target widget, we can able to re-sync the new columns using this icon. In validation scenario, we can view this icon in all the rules widgets where it refreshes the selected rule. | ||
| Threshold Options | Use this icon to add different threshold options such as Pass, Information, or Warning either in percentage or value format. We can view this option in FDR, TDR, Validation, QPT, and BDV. | ||
| Compare data for only matching keys | Compare data for only matching keys icon compares the data only with matching keys selection. | ||
| Identify missing records in source |
Identify missing records in source icon identifies only the source missing records. |
||
| Identify missing records in target | Identify missing records in target icon identifies only the target missing records. | ||
| Exception result snapshot limit | This icon helps in setting the exceptions result limit and the user can set the exceptions limit number accordingly. | ||
| Exception Control Off | If this setting is enabled, then user can override the selected record(s) statuses at each column level and vice-versa. | ||
| Source representation icon | In FDR and TDR exceptions summary, this icon represents the source data. | ||
| Target representation icon | In FDR and TDR exceptions summary, this icon represents the target data. | ||
| Execution result history | This icon displays an overall result execution history over a selected period of time. | ||
| Align Widget | We can line up all the validation widgets in proper alignment to avoid a cluttered design using Align Widget icon. | ||
| Switch to spreadsheet view | This icon helps to view any results in spreadsheet view. | ||
| do comparison on source (Push-down reconciliation) | This icon can be enabled when the source and target of a scenario is using the same connection profile. This option can improve the performance of the reconciliation process by 5X – 100X. | ||
| Switch compare widgets | This icon helps in switching between count and data compare options in a TDR. | ||
| Show pairs with exceptions | This icon is visible in TDR exception summary page. Using this icon, we can only view the pairs with exceptions. | ||
| Parallelism for pairs | Using this icon, we can set parallelism for the selected number of pairs within TDR. | ||
| Propose | Propose icon is used to map the common Table fields/columns that appear both in the source and the target fields. We can view this icon in both FDR and TDR. | ||
| Arrange object pairs by mapping order | This icon in the ‘Count Compare’ or ‘Data Compare’ widgets maps the randomly mapped objects in the top order within TDR. | ||
| Count Compare | Count compare compares the Row Count from the Source and Target Data sources and is a part of TDR. | ||
| Data Compare | Data Compare compares the Data from both the Source and Target profiles. | ||
| Key columns | Key columns icon can be viewed in both count and data compare widgets in a TDR. It is used to select the key columns in any selected table. | ||
| Object list entry view | We can add the list of objects manually with the help of this icon. We can view this icon in FDR, TDR, BDV, and QPT. | ||
| Delete selected mappings | Delete selected mappings icon deletes only the previously selected mapped columns/rows. | ||
| Delete all mappings | Delete all mappings icon deletes all the previously mapped columns/rows. | ||
| Switch to formatted view | This icon helps to view any results in formatted view. | ||
| Null check | Null check ensures that there are no null values in the selected columns. | ||
| Duplicate check | Duplicate checks are used to identify duplicate values. | ||
| Zero value check | zero value check is used to identify records for selected fields containing zero. | ||
| Numeric check | Numeric check is used to identify records for the selected columns with non numeric data. | ||
| Condition check | In condition check, we can give any specific condition that we want to fulfill. This rule can be applied to a table as a whole. | ||
| Row count check | In Row count check, we can specify the number of records we wish to validate. | ||
| Regex check | In this validation check, the contents of selected fields are against a regular expression. | ||
| List value check | List value check specifies a list of values that are valid for the column. | ||
| Minimum value check | This validation rule helps you specify the minimum value required for a particular field. | ||
| Maximum value check | This validation rule helps you specify the maximum value for a particular field. | ||
| Cascade | A cascade icon is present in QPT dashboard within all threshold tabs. Clicking this icon adds the same threshold value for the rest of the SQL queries for the selected threshold tab. | ||
 |
Pass threshold | When actual query execution time is below or equal to the expected runtime. | |
| Information threshold | When actual query runtime is more than the Pass threshold and less than the Information threshold. | ||
| Warning threshold | When actual query runtime is more than the Information threshold and less than the Warning threshold. | ||
| Log | A log icon displays the entire execution cycle of a scenario. | ||
| Override status | Using override status icon, we can override between 2 different statuses. | ||
 |
Drill into exceptions | Using this icon, we can further drill into scenario execution exceptions page. | |
| All Jobs | All Jobs icon displays all the created jobs. | ||
| Scheduled Jobs | Clicking this icon displays only the current scheduled jobs. | ||
| Running Jobs | Clicking this icon displays only the running jobs. | ||
| Scheduler enable and disable option | We can either enable or scheduler option from the system preferences session page. | ||
| Execute Now | Execute Now schedules the Job immediately as you perform the execution. | ||
| Execute On | Execute On schedules the Job at a specific future date and time. | ||
| Repeat Scheduler | Repeat Schedule schedules a Job at a specific future point of time (Minutes, Hours, Day, or Month) and here the Job execution is repetitive. | ||
| Condition widget | Condition widget is a part of Job Designer. We can add a condition using this icon. | ||
| Save schedule | Save schedule icons helps in saving the scheduled job configuration. |