Table of Contents

Search

  1. About the Data Vault Administrator Guide
  2. Introduction to the Data Vault
  3. Data Vault Service Startup and Shutdown
  4. Data Vault Configuration
  5. Data Vault SSL Setup
  6. Data Vault ODBC Setup
  7. Data Vault Administration
  8. Data Repartitioning
  9. Partial Data Vault Copy
  10. Archived Data Migration
  11. Bulk File Uploader
  12. Data Vault Administration Tool
  13. Data Vault Logs
  14. User Account Privileges
  15. ssasql Command Line Program
  16. Data Vault Audit Log
  17. Sample Configuration Files

Data Vault Administrator Guide

Data Vault Administrator Guide

Data Vault ODBC Data Source Parameters

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.

0 COMMENTS

We’d like to hear from you!