Amazon Aurora Connector enables you to securely read data from or write data to Amazon Aurora databases.
You can use Amazon Aurora objects as sources and targets in synchronization tasks, mappings, and mapping tasks.
You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.
When you use Amazon Aurora Connector to write data, you can perform insert, update, upsert or delete operations. When you configure field mappings in a synchronization task or mapping task, you can create a lookup to an Amazon Aurora object.
Note: You cannot create an unconnected lookup when you configure field mappings.
Example
You work in the IT department of an international bank and are responsible for storing huge volumes of transaction files in a relational database. You want to store the data in Amazon Aurora database to avoid data loss if the relational database fails. You can use Amazon Aurora Connector to upload huge volumes of transactional files to Amazon Aurora from any location and at any time. You can back up data in Aurora for disaster recovery purposes and retrieve the data later.