Emailing the Data comparison output – RightData

You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

Emailing the Data comparison output

Let’s execute a TDR using an Email widget and send the data comparison output to an email address.

To learn more, let us walk through the below procedure:

Click the ‘SCENARIO STUDIO’ module.
Hover on the ‘Scenario Builder’ snippet from the left pane options.
Click the ‘Technical Data Recon’ option.

Note: Either clicking the Technical Data Recon option or Create TDR Scenario button navigates to a new TDR create and edit page

Path 01: SCENARIO STUDIO > Scenario Builder > Technical Data Recon

Path 02: SCENARIO STUDIO > Create TDR Scenario

The user is navigated to a new TDR session page in create and edit mode.
From the Data Source tab, let’s drag and drop an ‘RDBMS Tables’ icon on to the TDR session page.
Double tap the ‘RDBMS Tables’ widget.

An ‘RDBMS Tables’ pop-up window is displayed.
Let’s select ‘PostgreSQL’ from the Database Type drop-down list.
Select ‘PostgreSQL Northwind_QA’ from the Connection Name drop-down list.

Note: As the user selects the ‘Connection Name’ (PostgreSQL Northwind_QA here) the Parallelism, Packet Size along with Server, Database, Port, and User Id are populated.

Click the ‘Additional Settings’ button.

An ‘Additional Settings’ pop-up window is displayed with Parallelism, Packet Size, and Packetize by field options.

Note: By default, Parallelism is set to 1 and Packet Size by 50000 records

User can modify the Parallelism and Packet Size based on their requirements and click the ‘Save’ button to save the changes.
A ‘Reset to default’ button is used to reset the ‘Parallelism’ and ‘Packet Size’ to default values when changed.
When hovered on the info button against the text fields the user is assisted with information.
Click the ‘X’ button to close the ‘Additional Settings’ pop-up window.

The user is navigated to the ‘RDBMS Tables’ session page.
Click the ‘Select’ button.

The ‘RDBMS Table’ widget is closed saving the widget data and further collapsing into the TDR session page in create and edit mode.

From the Data Source tab, drag and drop another ‘RDBMS Tables’ widget as Target Data Source.

Note: The ‘RDBMS Tables’ icon including the remaining icons from the Data Source tab gets disabled as the user drags the ‘Target Data Source’ onto the TDR session page in create and edit mode.

Double tap the ‘RDBMS Tables’ widget.

An ‘RDBMS Tables’ pop-up window is displayed.
Select ‘Database Type’ as ‘Redshift’ and ‘Connection Name’ as ‘Redshift-QA.’

Note: As the user selects the ‘Connection Name’ (Redshift-QA here) drop-down list, the Parallelism, Packet Size along with Server, Database, Port, and User Id will be populated

Click the ‘Additional Settings’ button.

An ‘Additional Settings’ pop-up window is displayed and has Parallelism, Packet Size, and Packetize by text field options.

Note: By default, Parallelism is set to 1 and Packet Size by 50000 records.

Users can also modify the Parallelism and Packet Size based on their requirements and click the ‘Save’ button to save the changes.
A ‘Reset to default’ button is used to reset the ‘Parallelism’ and ‘Packet Size’ to default values when changed.
When hovered on the info button against different text fields the user is assisted with information.
Click the ‘X’ button to close the ‘Additional Settings’ pop-up window.

The user is navigated to the ‘RDBMS Tables’ session page.
Click the ‘Select’ button.

The ‘RDBMS Tables’ widget is closed saving the data and collapsing into the TDR session page in create and edit mode.
Click the ‘Compare’ tab.

From the ‘Compare’ tab, drag and drop the ‘Data Compare’ widget onto the TDR session page in create and edit mode.

Note: The ‘Count Compare’ and also the ‘Data Compare’ icons are disabled as the user drags any icon onto the TDR session page in create and edit mode.

A Count Compare pop-up window is displayed.
Now, click the ‘Filter’ button of ‘PostgreSQL Northwind_QA.’

A ‘Filter’ pop-up slide screen with Schema / Owner, Object Name, and Max. No. of Values field options are displayed.
Let’s, select ‘information_schema’ from Schema / Owner drop-down list.
Click the ‘Get Metadata’ button.

Note: By default, Max. No. of Values is set to 500.

‘Get Metadata’ button populates the selected Schema tables (pg_catalog).
Click the Filter button of Redshift-QA Connection Name.

A ‘Filter’ slide screen is displayed with different field options such as Schema / Owner, Object Name, and Max. No. of Values.
Let’s again, select a similar Schema ‘information_schema’ from the Schema / Owner drop-down list.
Click the ‘Get Metadata’ button.

‘Get Metadata’ button populates the selected Schema tables (information_schema) of Redshift-QA.
Now, click the ‘Propose’ button.

Mapping similar fields for both the Connection Names (PostgreSQL Northwind_QA and Redshift-QA) are displayed.
40 similar fields have been mapped between the two Connections (PostgreSQL Northwind_QA and Redshift-QA)

Note: There are 60 field values in PostgreSQL Northwind_QA and 40 field values in Redshift-QA

Click the ‘Save’ button.

The ‘Data Compare’ widget is closed saving the widget data and collapsing into the TDR session page in create and edit mode.
Click the ‘Additional Options’ tab.

Drag and drop the ‘Email widget’ onto TDR create and edit page.
Click the ‘Email Settings’ widget.

An ‘Email Settings’ pop-up window is displayed.
Click the ‘Save’ button.

Note: The email ids are greyed due to confidential data.

The Email Settings widget is closed saving the data and collapsing into the TDR session page in create and edit mode.
Click the ‘Execute Now’ button.

The user is navigated to a new tab displaying the ‘Scenario Execution Summary’ results of that particular TDR Scenario (Sample TDR Execution).
The ‘Data’ count is displayed under ‘Compare Results’ tab.

Note: This is an Errored Scenario.

Click the number ‘4’ for the second pair comparison.

This action creates a new tab just beside the ‘Scenario Execution Summary’ displaying all the mismatched Data.

The user can view the email comparison results as shown below.