Microsoft Excel Source Data Synchronization Task Example
You want to import prospective inpatient payment details from a Microsoft Excel file to analyze the data.
Configure a Data Synchronization task with the insert operation and configure the following objects:
- Source
The source object for a Data Synchronization task corresponds to worksheets present in the Microsoft Excel file used for creating a connection. Use the Microsoft Excel source connection to connect to the Microsoft Excel file and read data from the worksheet.
- Target
Use a .csv file as the target object in the Data Synchronization task. The target object file must contain the tables you select in the source object.
- Mapping
Map the primary fields of the source object to the flat file target object.
The following image shows mapping of the fields:
Note: When you run the Data Synchronization task, the Secure Agent writes the retrieved tables to the target.CSV file.
