Amazon Aurora Connector > Synchronization tasks with Amazon Aurora > Amazon Aurora sources in synchronization task
  

Amazon Aurora sources in synchronization task

When you configure a synchronization task to use an Amazon Aurora source, you can read data from a single or multiple object.
To optimize performance, you can configure a filter on the Data Filters tab. You can also configure an advanced filter to define a more complex filter condition, which can include multiple conditions by using the AND or OR logical operators.
The following table describes the Amazon Aurora source properties:
Property
Description
Connection
Name of the Amazon Aurora source connection.
Source Type
Type of the Amazon Aurora source object available.
You can choose from the following source types:
  • - Single
  • - Multiple
Source Object
Name of the Amazon Aurora source object.
Display source fields in alphabetical order
Displays source fields in alphabetical order. By default, fields appear in the order returned by the source system.
When you configure a synchronization task, you can configure the advanced source properties. The advanced source properties appear on the Schedule page of the Synchronization Task wizard.
The following table describes the Amazon Aurora advanced source properties:
Property
Description
Pre SQL
Pre-SQL command to run before reading data from the source.
Post SQL
Post-SQL command to run after reading data from the source.
Output is deterministic
When you configure this property, the Secure Agent does not stage source data for recovery if transformations in the pipeline produce repeatable data.
Output is repeatable
When the output is deterministic and the output is repeatable, the Secure Agent does not stage the source data for recovery.