Data Vault Administrator Guide

Back Next

Data Vault ODBC Data Source Parameters

When you create an ODBC data source that uses the Data Vault ODBC driver, you must configure the parameters required for the Data Vault ODBC driver.

The following table describes the parameters that you set for a data source that uses the Data Vault ODBC driver:

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.

The following table describes the advanced parameters that you can set for a data source that uses the Data Vault ODBC driver:

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: 1252 (ANSI - Latin I) 65001 (UTF-8)
Date, Time, Number formats	Format to use for date, time, and numeric values. Select from one of the following options: ISO Regional settings
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: Commit. The ODBC driver commits all transactions before the next query. Rollback. The ODBC driver rolls back all transactions before the next query. 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.