Microsoft Azure Data Lake Target Data Synchronization Example
You are a Data Analyst in a financial enterprise. You need to perform data analysis on the business opportunities that you have in pipeline.
Configure a Data Synchronization task with the insert operation and configure the following objects:
- Source
- The source object for a Data Synchronization task is Salesforce. Use the Salesforce connection to connect to Salesforce and read data from the Opportunity object. Use the Opportunity source object in the Data Synchronization task. The source includes fields, such as Id, AccountID, Name, Amount, and ExpectedAmount.
- Target
- The target in a Data Synchronization task is Microsoft Azure Data Lake Store. Use the Microsoft Azure Data Lake Store connection to connect to Microsoft Azure Data Lake Store. The target includes fields, such as Id, AccountID, Name, Amount, and ExpectedRevenue.
- Mapping
- Map the primary fields of the Opportunity source object to the target object.
- The following image shows the mapping of the source with the Opportunity target:
- When you run the Data Synchronization task, the Secure Agent writes the retrieved opportunity information to the target table.
- The following image shows the data that the Secure Agent retrieves from Salesforce and writes to Microsoft Azure Data Lake based on the fields you mapped in the Data Synchronization task: