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

EXPORT Section

EXPORT Section

The EXPORT section of the ssa.ini file contains the parameters for data export from the Data Vault.
The following table describes the parameters in the EXPORT section of the ssa.ini file:
Column
Description
BUFFSIZE
The size (in MB) of the internal buffer used for an export operation.
Default is 64.
DELIMITER
The character used to delimit columns in the exported flat file. This parameter should only be set when MODE=1 (variable-length mode).
Default is | (vertical bar).
EOL
The end-of-line indicator in the exported flat file. This parameter is used only in fixed-length mode (MODE=0
)
. In variable-length mode (MODE=1), rows are always separated by the carriage return and line feed character combination (\r\n).
Default is \n.
MAXTEMPSIZE
The maximum size (in GB) for the temporary virtual file system created during the export operation.
Default is 8.
MODE
The way in which the exported data is written. There are two options: 0 (fixed-length mode) and 1 (variable-length mode). In fixed-length mode, each column has a fixed width; column values less than that width are padded with blank spaces. In variable-length mode, column values are separated from each other by a delimiter (set with the DELIMITER parameter); there is no space padding.
Default is 0 (fixed-length mode).
NULL
The character string that represents a null value in the exported flat file.
Default is NULL.
TEMPDIR
The directory where a temporary virtual file system will be created during the export operation.
Default is <DataVaultServiceDirectory>/temp.

0 COMMENTS

We’d like to hear from you!