Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Archive 6.5 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Backing Up and Restoring the Data Vault
  3. Configuring Centera as a Remote Data Vault Store
  4. Configuring Data Archive for a Legacy Source Using Legacy Adapters
  5. Data Archive Seamless Access for PeopleSoft
  6. Data Archive Transaction Restore API
  7. Dropping and Truncating Partitions in Data Archive
  8. High Availability Configuration for the Data Archive and File Archive Service Versions 6.1 to 6.3
  9. 0955-High Availability Configuration for the Data Vault Version 6.4 and Later
  10. How to Create Business Rules to Archive and Purge Transactional Data
  11. How to Uninstall Data Archive 5.1
  12. How to Uninstall Data Archive 5.3
  13. How to Use Scripts to Change Database User Passwords in the ILM Repository
  14. IBM DB2 Database Connectivity and Setup for Data Archive
  15. Installing Data Visualization
  16. Integrating Third-Party Schedulers in ILM Engine
  17. Parallel Processing in Data Archive
  18. Seamless Access Configuration for Siebel Applications
  19. Seamless Access Setup for Oracle E-Business Suite
  20. Seamless Access Setup for Oracle R12 in Data Archive
  21. Using the Data Vault Service JDBC Driver to Connect to the Data Vault
  22. Using Multiple Engines in an ILM Environment
  23. Using PowerExchange ODBC Connections in a Data Archive Retirement Project
  24. Discovering Foreign Key Relationships in Enterprise Data Manager

Data Archive How-To Guide

Data Archive How-To Guide

Back Next

Step 2. Set Up the Target Connection

Step 2. Set Up the Target Connection

In Data Archive, create a target connection to the Data Vault and set the archive store type to EMC Centera.
The following table describes the properties that you need to set for the target connection:
Property
Description
Connection Name
Archive target name. Use the name to differentiate archive target connections.
When you create an archive project and you assign a target, you select the connection name that you define here. You can use the connection name to display a list of all connection types or filter the list of connections by name.
Connection Description
Long text description for the connection name. To manage connections, you can use this field to filter the list of connections.
Connection Type
Type of target connection. The connection type determines the connection properties you need to define.
Set the connection type to Data Vault.
Application Version
Business application and application versions that the database connection type supports. The connection type determines the application version available.
Staging Directory
Location where the archive job creates the BCP files.
Number of Rows Per File
Maximum number of rows in the BCP files. When a BCP file reaches the maximum number of rows, the archive job creates another BCP file and adds subsequent rows to the new file.
Data Vault SCT Files Directory
Directory where the Data Vault Service creates the SCT files.
Data Vault Connection Name
Set to the default connection name
FAS
.
Data Vault Folder Name
Name of the folder in the Data Vault where you archive the data.
When you run the standalone job to create the archive folder, you provide the target connection. The job takes the folder name that from the target connection and creates the folder using the name you enter here.
Data Vault Host
Host name of the machine where the Data Vault Service is running.
Data Vault Port
Port number used by the Data Vault Agent to connect to the Data Vault Service. Default is 8600.
Data Vault Administration Port
Port number used by the Data Vault Administration Tool and command line program to connect to the Data Vault Service. Default is 8500.
Data Vault User
User name for the Data Vault Service administrator user account to log in to the Data Vault schema.
Data Vault User Password
Password for the Data Vault Service administrator user account.
Confirm Password
Confirmation of the Data Vault user password.
Add-On URL
URL for the Data Vault Service for External Attachments component. Required to convert external attachments from a proprietary format into regular format. Scripts are used to convert the attachments.
Use Mined Source Schema
Indicates whether to use the schema from the source instance mined in the Enterprise Data Manager. If enabled, the Data Vault Loader job uses the mined source schema structure from the Enterprise Data Manager to create the schemas in the Data Vault folder. The job creates the same schema structure in the Data Vault folder and adds the transactional tables to the corresponding schema. The job creates the dbo schema and adds the metadata tables to the dbo schema.
If not enabled, the Data Vault Loader job creates the dbo schema in the archive folder. The job adds all transactional tables across all schemas and metadata tables to the dbo schema.
The Data Vault Loader job uses the schema structure from the source instance that you mined in the Enterprise Data Manager. You may need to re-mine the source instance before you run the Data Vault Loader job if the source connection schema is different from the mined schema. Schema names can vary between instances. For example, you mined a development instance. You exported metadata from the development instance and imported the metadata into the production instance. If the schema names are different in development and production, you must re-mine the production instance.
Archive Store Type
Type of storage for the Data Vault. The store type can be an external storage platform.
Set to EMC Centera.
XRI
Extensible Resource Identifier (XRI) that describes the XAM server and the location of the XAM credentials file for the Centera XAM connection.
0 COMMENTS
We’d like to hear from you!