Data Synchronization Tasks Example
You are a business analyst in an organization. Your organization uses Zuora to manage all the subscription business spread across different locations. You need to extract data from Zuora to a flat file and load data to a cloud analytics environment to perform analytics on the subscription business.
Perform the following steps to read data from a Zuora source and write data to a flat file:
Note: You need to create a Zuora AQuA connection before you create the Data Synchronization task.
1. Click Task Wizards > Data Synchronization.
The Data Synchronization Task Wizard appears.
2. Click New to create a Data Synchronization task.
The Definition tab appears.
3. Configure the following fields on the Definition page:
Field | Description |
---|
Task Name | Name of the Data Synchronization task. For example,ZuoraAqua_Read_IncremetalLoad |
Description | Description of the Data Synchronization task. Maximum length is 255 characters. |
Task Operation | You can read data from a Zuora AQuA source. You cannot perform insert, update, upsert, or delete operations on a Zuora AQuA. |
4. Click Next.
The Source tab appears.
5. Configure the following fields on the Source page:
Field | Description |
---|
Connection | Select a Zuora AQuA connection you created. For example, ZuoraAQuAConnection |
Source Type | Select Single. |
Source Object | Select the required object from the list. |
6. Click Next.
The Target tab appears.
7. Configure the following fields on the Target page:
Field | Description |
---|
Connection | Select a flat file connection. |
Target Object | Click Create Target. |
8. Click Next.
The Data Filters tab appears.
9. Select the filter object, filter field, and filter operator to create a data filter on the Data Filters page.
10. Click Next.
The Field Mapping tab appears.
11. Click Automatch on the Field Mapping page to map source fields to target fields accordingly.
12. Click Validate Mapping to validate the mapping.
13. Click Next.
The Schedule tab appears where you can schedule the task for each requirement and save.
14. Configure the advanced source properties on the Schedule page.
15. Click Save and Run the task if you do not want to schedule the task.
After you run the task, the Monitor Log page appears where you can monitor the status of Data Synchronization tasks.