Purpose
- Export data from a Data Source to an Amazon RDS MySQL Data Target. You can specify mapping between attributes from the input Data Source to the attributes in the output Amazon RDS MySQL Data Target for any existing tables within the Data Target.
- Alternatively, this task can create a table that does not exist if the Amazon RDS MySQL Data Target selected uses the "OP task defined" option within the Data Target.
- As an advanced configuration, this task can run a post-execution SQL query script if needed.
- Use this task to write data to a Data Target at the end of a Job.
Category Location: All, System specific
Field Description
- Records that were updated after: Set a date based on the update of records for the export.
- Export all filtered records: Check this option if you'd like all records to be exported, even if they were not updated in the job.
- Select Data target: Select the data target that you've already created in Openprise.
Tips
- The Amazon RDS MySQL Data Target must already exist.
- Use the "OP task defined" selection in the Amazon RDS MySQL Data Target if a new table should be created.
- In order to map an attribute from the Amazon RDS MySQL Data Target, the attribute must be part of the Data Target configuration.
- It is possible to have multiple tasks output to the same Amazon RDS MySQL Data Target, so be careful to avoid unintended collisions.
Examples
- Push cleansed and normalized data back into Amazon RDS MySQL for processing by other downstream systems.
- Push enriched and cleansed data into an Amazon RDS MySQL data warehouse.