Early access | Load Data into Database Module

The Load Data into Database Module is an early access feature. It is not part of the Tosca BI Modules And Samples.tsu subset. To get the Module, please contact Tricentis Support.

The Load Data into Database Module loads any data set from an ODBC or file into a target. This target can be another ODBC connection, a Teradata database, or the local caching database. This allows you to perform multi-source comparisons if your data is spread across different database systems and you want to bring all data to the same system to perform the necessary joins.

The Load Data into Database Module can be a preparatory step for Row by Row Comparison TestCases.

When you run the Row by Row Comparison TestCase, the target into which you loaded your data sets becomes the source of your data, and you can compare it to another target.

If you want to use a Teradata target, you need to perform additional steps before you can start testing. For more information, see chapter "Set up Teradata as a target".

Example

This example shows how to use the Load Data into Database Module in Reconciliation tests.

The TestCase Sample TestCase consists of three TestSteps. You created two of these TestSteps with the Load Data into Database Module, and one TestStep with the Complete Row by Row Comparison Module.

Tosca BI processes the TestCase in the following way:

• TestStep Load Data into Database - from file loads data from the file Customer_Data.csv into the specified target ODBC connection.

• TestStep Load Data into Database - from ODBC loads data from an ODBC connection into the same target ODBC connection that you used in the first TestStep. If you have a Tosca BI license, you can use the SQL Editor to create and test SQL statements.

• TestStep Complete Row by Row Comparison uses the target ODBC connection from the first two TestSteps as a source. It compares this source to the target file Customer_Export.csv.