Create a target connection for each database or storage type that you want to archive data to. The target database is the location where you want to archive data to. The target can be another database, which is typically referred to as the history or archive database. Or, the target can be the Data Vault.
If you installed the Data Visualization component, the target connection is the connection that Data Archive uses to retrieve data for reports. When you create a connection to the Data Vault, Data Archive uses the target connection information to create a data source. If you change the target connection information, Data Archive updates the data source.
For restore jobs, the target database is the production database that you want to restore data to. If you want to restore archived data, create a new target connection for the source or production database. In the restore scenario, the source database becomes the archive target.
You can create target connections to the following databases: