Set up your DI connection details
Tosca Cloud supports the following Data Integrity connection types:
-
ODBC data source uses an ODBC connection you set up in the ODBC Data Source Administrator.
-
Connection string uses an ODBC connection string to connect to your data source
-
SQLite uses a native SQLite connection to read your database.
Fill in your connection details
To set up a DI connection, you need to specify certain details based on its type:
|
Item |
Description |
|---|---|
|
Connection name |
A unique name for your connection in your Tosca Cloud workspace. Use this name to refer to your connection in the |
|
ODBC data source |
The name of the ODBC data source you want to use, as shown in the ODBC Data Source Administrator. |
|
Description |
An optional field to add notes on your connection. |
|
Credentials->User ID |
The user ID to access the connection set in the ODBC Data Source Administrator. |
|
Credentials->Password |
The password for user ID. |
|
Timeout->Connection |
Time in seconds after which Tosca Cloud aborts a connection attempt. |
|
Timeout->Command |
Time in seconds after which Tosca Cloud aborts the SQL query and reports it as failed. |
|
Item |
Description |
|---|---|
|
Connection name |
A unique name for your connection in your Tosca Cloud workspace. Use this name to refer to your connection in the |
|
Connection string |
The applicable ODBC connection string. Can contain user ID and password. |
|
Description |
An optional field to add notes on your connection. |
|
Credentials->User ID |
The user ID to access your ODBC Data source. This field is optional and overrides the user ID you provide in your connection string. |
|
Credentials->Password |
The password for the given user ID to your ODBC data source. This field is optional and overrides the password you provide in your connection string. |
|
Timeout->Connection |
Time in seconds after which Tosca Cloud aborts an active connection. |
|
Timeout->Command |
Time in seconds after which Tosca Cloud aborts the SQL query and reports it as failed. |
|
Item |
Description |
|---|---|
|
Connection name |
A unique name for your connection in your Tosca Cloud workspace. Use this name to refer to your connection in the |
|
Use cashing database |
Connects to the caching database that Data Integrity modules use to store data in the agent machine. Selecting this disables the connection string option. |
|
Connection string |
The applicable SQLite connection string. |
|
Description |
An optional field to add notes on your connection. |