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 synchronization task.
1In Data Integration, click New > Tasks.
2Select Synchronization Task, and click Create.
The Definition tab appears.
3Configure the following fields on the Definition tab:
Field
Description
Task Name
Name of the synchronization task.
For example,ZuoraAqua_Read_IncremetalLoad
Description
Description of the 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.
4Click Next.
The Source tab appears.
5Configure the following fields on the Source tab:
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.
6Click Next.
The Target tab appears.
7Configure the following fields on the Target tab:
Field
Description
Connection
Select a flat file connection.
Target Object
Click Create Target.
8Click Next.
The Data Filters tab appears.
9Select the filter object, filter field, and filter operator to create a data filter on the Data Filters page.
10Click Next.
The Field Mapping tab appears.
11Click Automatch on the Field Mapping tab to map source fields to target fields accordingly.
12Click Validate Mapping to validate the mapping.
13Click Next.
The Schedule tab appears where you can schedule the task for each requirement and save.
14Configure the advanced source properties on the Schedule tab.
15Click Save and then Finish.
16From the Explore page, select the task, and click Actions > Run.
In Monitor, you can monitor the status of the task.