Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Step 6. Populate Seamless Data Access Schemas with Views and Synonyms

Step 6. Populate Seamless Data Access Schemas with Views and Synonyms

The Create Seamless Data Access Script standalone job generates a script. The script contains the statements necessary to create the required views and synonyms for seamless access. After you review the script and ensure its accuracy, run the script to create the views and synonyms, and populate the schemas with the views and synonyms.
Run the Create Seamless Data Access Script standalone job once for the archive schema and once for the combined schema.
  1. Click
    Jobs
    Schedule a Job
    .
  2. Click
    Schedule Jobs
    .
  3. Select the
    Create Seamless Data Access Script
    job from the list of values, and click
    Select
    .
  4. Enter a value for the job parameters.
  5. Click
    Schedule
    to run the job.
  6. You can navigate to
    Jobs
    View Current Jobs
    to monitor the progress of this job. Wait until this job finishes before proceeding to the next step.
  7. Run the script generated by the
    Create Seamless Data Access Script
    job. The script runs in the location you specify in
    Create Seamless Data Access Script
    job parameters.

0 COMMENTS

We’d like to hear from you!