Set up your Data Integrity connection details
Tosca Cloud supports the following Data Integrity connection (DI connections) 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 Note that you can't change the connection name after you save your connection. |
|
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. |