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

ssadbcopy for Data Import

ssadbcopy for Data Import

Imports data to a target system for a partial Data Vault copy. Run the ssadbcopy command on the target Data Vault system.
The ssadbcopy command uses the following syntax:
ssadbcopy -i <TAR_archive_file_location> [-a <insert_mode (0,1)>] [-r <temporary_file_directory>] [-h (displays help screen) -u <Data_Vault_administrator_user>[/password] -c (cleans up the SCT files from the staging location)
The following table describes the ssadbcopy command arguments:
Option
Argument
Description
-i
TAR_archive_file_location
Required. Full path of the directory on the target Data Vault system that contains the TAR archive file, including the TAR archive file name.
-a
insert_mode
Optional. Determines how the utility inserts data. Specify one of the following options:
  • 0. Appends data to existing tables.
  • 1. Drops and creates the data and structures. Use this mode if the table structure or data model on the source system is different than the structure on the target system.
Default is 0.
-r
temporary_file_directory
Location of the temporary directory on the target Data Vault system. The utility creates the ssadbcopy_temp folder in the specified directory and then creates the runtime files, log file, and export files inside of it.
If you run two parallel ssadbcopy export jobs, do not use the same directory for -r.
Default is the current working directory.
-h
-
Optional. Displays onscreen help. The help shows the syntax of the command and the possible flags.
-u
Data Vault_administrator_user>[/password]
Required. Name and password of the Data Vault administrator user account.
-c
Optional. Removes the SCT files from the -l directory after successful migration.

0 COMMENTS

We’d like to hear from you!