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: 

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:

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: