Define connections in the Tosca BI Connection Manager
Database and Tosca BI tests require you to define a connection to the source of your data. This connection contains necessary information for your tests, such as data source type, user credentials, or table metadata.
The Tosca BI Connection Manager allows you to create and centrally manage the following connections:
-
BI connections for tests you create with the Tosca BI Wizards
-
Database connections for your database tests
It saves your connections to the Configurations section in Tosca Commander.
This means you don't have to define a connection for every TestCase you create. Instead, you can reference the connections stored in the Configurations section.
You can define an unlimited number of ODBC or SQLite connections in the Connection Manager. If users in a multi-user workspace have different rights on the same data source, you can define the same connection with different specifications multiple times. Use different connection names and different user credentials.
For information on how to create a new connection with the Connection Manager, see chapter "Create a new connection".
Use BI connections
You can create a BI connection using an ODBC data source or ODBC connection string.
BI connections include metadata. This means that included SQL statements tell the Tosca BI Wizards how to read all relevant tables, columns, and constraint information from the database system you intend to use.
You can use BI connections in the following tests:
-
Tests you create with the Vital Checks: File to Database and Vital Checks: Database to Database Wizard
-
Tests you create with the Field Tests: Single Database and Field Tests: Database to Database Wizards
Use Database connections
You can create a Database connection using an ODBC data source, ODBC connection string, or SQLite connection string. Database connections do not include metadata.
You can use Database connections in the following tests:
-
Tests you create with the Metadata comparison Module
-
Tests you create with the Row by Row Comparison Module
-
Tests you create with the BI DB Expert Module