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

ssasql Example

ssasql Example

The ssasql invocation in this example connects to a Data Vault repository database or Nucleus database instance called
vip
as
user1
, using a connection definition called
server1_vip
. The user authorization password is
PaSs1
. Session logging is turned on with the
-o1
flag. Following a successful connection, user1 is automatically placed in SQL mode (in the default schema associated with that user authorization).
ssasql -o1 server1_vip vip user1/PaSs1

0 COMMENTS

We’d like to hear from you!