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. Data Validation
  12. Bulk File Uploader
  13. Data Vault Administration Tool
  14. Data Vault Logs
  15. User Account Privileges
  16. ssasql Command Line Program
  17. Data Vault Audit Log
  18. Appendix A: Sample Configuration Files

Data Vault Administrator Guide

Data Vault Administrator Guide

Configuration Parameters

Configuration Parameters

To use the bulk file uploader, configure the following parameters in the [SERVICE] section of the ssa.ini file:
TASK_DIRECTORY
Defines the directory that contains the master XML file. You can provide any directory that has read/write permissions.
SSAJOBLOG
Defines the directory in which the job-level logs are created.
SSASERVICELOG
Defines the directory in which the service log files are created.
MAXJOBS
The number of bulk file uploader jobs that can run in parallel. The default value for this parameter is five. If you increase this parameter, consider also increasing the server threads to avoid starvation of archive jobs.
For example:
[SERVICE] MAXJOBS = 10
LOADPARAM
A list of comma separated values that the bulk file uploader uses as command line arguments. The syntax is <ARG1>: <VAL1>, <ARG2>: <VAL2>, ..., <ARGN>: <VALN>
k
The number of parallel threads used for creating the SCT file.
Mem
The maximum memory in MB that the uploader can use for one loading job.
lr
Passes outlier values to the bulk file uploader in the same way that other values are passed to the uploader.
For example:
[SERVICE]
LOADPARAM = k : 2 , lr:'TIMESTAMP:R:99:99:9999:99:99:99 9999999:2016-07-21-00.23.23.000000000000'

Example

The following text is an example of the bulk file uploader configuration parameters in the ssa.ini file:
[SERVICE] SSA_Connection = fas SSAJOBLOG = E:\6431\fas_logs ADDRESS = LOADBUFFER = 32768 SSA_UID = dba SSA_Database = meta EMAIL = 0 LOADPARAM = j:2,k:2,lr:'INT:R:-0001,DOUBLE:R:-1.1E+111,TIMESTAMP:R:0001-01-01-01.09.01.000000000001' JOBRETRY = 0 TIMEOUT = 15 SSA_PWD = B1E786394FB4762B9A83EE2329162A59 SSASERVICELOG = E:\6431\fas_logs TASK_DIRECTORY = E:\sct_ssaservice\mdata

0 COMMENTS

We’d like to hear from you!