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 Export Examples

ssadbcopy for Data Export Examples

You can run the ssadbopy command in data export mode with one or more options.
Copy data from one database and export files automatically with FTP server
You want copy data from one database and use an FTP server to automatically export files from the source Data Vault system to the target Data Vault system.
Run the ssadbcopy command with the following options:
ssadbcopy -f -n /u01/sct_stage -r /data/temp -d LOYALTY
The utility exports the data and structure for database name LOYALTY. The utility saves the data export files to the
/data/temp
directory on the source system. The utility uses an FTP server to transfer the data files and the data export files to the Data Vault target system. The utility transfers the data files to the
/u01/sct_stage
directory on the Data Vault target system. The utility transfers the data export files to the location that you configured in the FTP ini.file.
Copy data from one table and export the files manually
You want to copy data from one table and manually export files from the source Data Vault system to the target Data Vault system.
Run the ssadbcopy command with the following options:
ssadbcopy -n /u01/sct_stage -r /data/temp -d LOYALTY –s LOYALTY_AIR –t TICKET
The utility exports the data and structure for database LOYALTY, schema LOYALTY_AIR, table TICKET. The utility saves the data export files to the
/data/temp
directory on the source system. You transfer the SCT data files to the
/u01/sct_stage
directory on the Data Vault target system. You also transfer the data export files to a temporary directory on the Data Vault target system.
Copy data from one table and export the data files manually to a Data Vault instance with an external storage system
You want to copy data from one table and manually export the data files from the source Data Vault instance with a local file system to a target Data Vault instance with an external storage system.
Run the ssadbcopy command with the following options:
ssadbcopy -n cas://2_ssadbcopy_test/ -t LINEITEM -s TPC_H -d SDS -r /u01/IDV642_Lin64/temp -l /u01/IDV642_Lin64/temp -u dba/dba
The utility exports the data and structure for database SDS, schema TPC_H, table LINEITEM. The utility saves the data export files to the
/u01/IDV642_Lin64/temp
directory on the source system. You must manually transfer the SCT data files to the
/u01/IDV642_Lin64/temp
directory on the external storage system. You also transfer the data export files to a temporary directory in the external storage file system.

0 COMMENTS

We’d like to hear from you!