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. LDAP User Authentication
  16. Auditing
  17. Running Jobs from External Applications
  18. Upgrading Oracle History Data
  19. Upgrading PeopleSoft History Data
  20. Data Archive Maintenance
  21. Storage Classifications
  22. Appendix A: Datetime and Numeric Formatting
  23. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Teradata Target Connections

Teradata Target Connections

Define archive target connection properties to archive data to Teradata databases.
You can configure the following target connection properties:
Host
Host of the target application database server.
Database Name
Unique identifier or system identifier for the target database server.
Admin Schema Name
Default administration database user for the target database server, such as SYSTEM.
Admin Login Name
Login name for the administration database server. This user does not require special permissions as it is only used to connect to the target database. You can provide any user name, such as a database connection user or a read-only user.
Password
Password for the administration login name.
Apps Schema Name
Application database user that owns the tables that you want to archive to. Also commonly referred to as the history application user.
Application Login Name
Login name for the target application database user.
Password
Password for the application login name.
Drop Destination Indexes
Controls whether the archive job drops the index on the history database before it inserts data in the history database. Use to improve performance when the archive job copies data to the destination.
Disable Triggers
Determines whether the system disables insert, update, and delete triggers when teh archive job deletes rows from tables.
If enabled, the system disables triggers when the archive job deletes data from the source.
If disabled, the system retains the triggers.
Default is enabled.
Only valid for restore archive jobs.

0 COMMENTS

We’d like to hear from you!