Data Replication Prerequisite Tasks

1. 1. Create a database.
To replicate data to a database target, the database administrator must create a target database. The database must meet the minimum system requirements.
2. 2. Create database users.
To replicate data to a database target, the database administrator must create a database user account in the target database. Each database user account must have the CREATE, DELETE, DROP, INSERT, SELECT, and UPDATE privileges. You must have a database user account for each Data Replication task that writes to that database. You can use the same database user account for multiple Data Replication tasks. If you use the same database user account for multiple groups, ensure that the Data Replication tasks do not overwrite data in the same target tables.
3. 3. Create a directory for the flat files.
To replicate data to a flat file, create a directory to store the flat files.
4. 4. Download and run the Secure Agent.
To replicate data to a flat file or database target, you must download and run at least one Secure Agent on a machine in your network.
5. 5. Optionally, create source and target connections.
6. 6. Optionally, create a schedule.
Create a schedule to run Data Replication tasks at specified times or on regular intervals.