Data Archive
- Data Archive 6.5
- All Products
ODBC Parameter
| Description
|
---|---|
Data Source Name
| Name of the ODBC data source.
|
Description
| Additional information to describe the data source.
|
Database name
| Name of the folder in the Data Vault to connect to.
|
Database user
| User account to log in to the Data Vault. The user account must be defined in Data Archive.
|
Connection name
| Name of a Data Archive connection to the Data Vault.
The connection name must match a target connection defined in the Data Archive Workbench.
|
Host
| Host name of the machine that hosts the Data Vault Service.
|
Port
| Port number to connect to the Data Vault.
|
ODBC Parameter
| Description
|
---|---|
Code page
| The code page to use for code page translations between the client and the Data Vault.
Select from one of the following options:
|
Date, Time, Number formats
| Format to use for date, time, and numeric values.
Select from one of the following options:
|
Autorefresh
| Configures the Data Vault ODBC driver to commit or roll back all transactions before each SELECT statement so that the client accesses the most recent version of the Data Vault archive folder.
Select the Autorefresh parameter and then set the parameter to one of the following options:
By default, the Autorefresh parameter is not enabled and the ODBC driver does not commit or roll back transactions before a SELECT statement.
|
Autocommit
| Configures the Data Vault ODBC Driver to commit transactions after each SQL command that modifies data such as an UPDATE or INSERT. Select the parameter to enable the ODBC driver to commit transactions after each SQL command that modifies data.
By default, the Autocommit parameter is not enabled and ODBC Driver does not commit transactions after each SQL command that modifies data.
|