Microsoft SQL Server Connector > Synchronization tasks with Microsoft SQL Server Connector > Synchronization task example
  

Synchronization task example

To perform the insert operation where you can read data from a Microsoft SQL Server Source and can write data to the Microsoft SQL Server target.
Perform the following steps to create a synchronization task::
Note: You need to create a Microsoft SQL Server connection before configuring the synchronization task.
    1. In Data Integration, click New > Tasks.
    2. Select Synchronization Task, and click Create.
    The Definition tab appears.
    3. Configure the following fields on the Definition tab:
    Field
    Description
    Task Name
    Name of the synchronization task.
    Description
    Description of the synchronization task.
    Maximum length is 255 characters.
    Task Operation
    Select the task operation that you want to perform.
    4. Click Next.
    The Source tab appears.
    5. Configure the following fields on the Source tab:
    Field
    Description
    Connection
    Select a Microsoft SQL Server connection you created.
    Source Type
    Select the source type.
    By default, Single is selected.
    Source Object
    Select the required object from the list.
    Display technical names instead of labels
    Displays technical names instead of business names.
    Display source fields in alphabetical order
    Displays source fields in alphabetical order. By default, fields appear in the order returned by the source system.
    6. Click Next.
    The Target tab appears.
    7. Configure the following fields on the Target tab:
    Field
    Description
    Connection
    Name of the active target connection.
    Target Object
    Name of target objects available in the connection. Select an existing object from the list or create a new object at the run time.
    Truncate Target
    When you enable the Truncate Target option, the Secure Agent truncates table before writing data to target. Default is false.
    Enable Target Bulk Load
    Uses Microsoft SQL Server bulk API to write data in bulk mode to Microsoft SQL Server.
    Display target fields in alphabetical order
    Displays target fields in alphabetical order. By default, fields appear in the order returned by the target system.
    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 tab 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 tab.
    15. Click Save > Finish.
    16. Select the synchronization task from the Explore page and click Actions > Run.
    In Monitor, you can monitor the status of the logs after you run the task.