Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Install
  4. Data Archive Installation
  5. Data Vault Installation
  6. Application Accelerator Installation
  7. Application Retirement for Healthcare Accelerator Installation
  8. MongoDB Accelerator Installation
  9. Salesforce Accelerator Installation
  10. After You Install
  11. Data Archive Upgrade
  12. Data Vault Upgrade
  13. Upgrading Oracle History Data
  14. Upgrading PeopleSoft History Data
  15. ILM Data Validation Option Setup
  16. Data Archive Source and Target Database Requirements
  17. Data Archive Connectivity
  18. Data Archive Uninstallation
  19. SAP Application Retirement
  20. Database Users and Privileges
  21. Data Visualization Designer Installation
  22. Data Archive Installation Requirements Checklist and Architecture Options

Installation and Upgrade Guide

Installation and Upgrade Guide

Source Database Requirements

Source Database Requirements

Verify the source database requirements. The source database is the location where you archive data from and is typically referred to as the production database. You can verify the requirements before or after the installation.
You can archive data from the following source database types:
  • IBM DB2
  • Informix
  • JDBC
  • Microsoft SQL Server
  • MongoDB
  • Netezza
  • Oracle
  • Sybase ASE
  • Teradata
  • Salesforce
For other databases, for example MySQL, use a generic JDBC driver to connect to the source database as a generic JDBC source connection.
You may need to create a staging tablespace or have additional staging space available on the source database. The staging tablespace creates space for the data only and not the index.
Data Archive requires a staging tablespace in the following cases:
  • Live archiving jobs.
  • Archive jobs that use Oracle partition exchange to purge data from the source database.
Data Archive requires staging space for retirement jobs that retire SAP applications with attachments.

0 COMMENTS

We’d like to hear from you!