Skip to main content

Source and Destination

You must create required identity providers and data sources before creating a job. They are created in Admin Center under Identity Stores and Data Sources tab respectively. After creating the providers, you need to specify the providers in Select Your Source and Destination page.

To configure the settings for the providers:

  1. On the Select Your Source and Destination page, do the following:

    • Your Source: Specify the data source or identity store from which to move data.
    • Your Destination: Specify the data source or Identity store to move data to.

    Provide the following information for the selected providers:

    • Microsoft Active Directory

      Specify a container. To include sub containers, select the checkbox Include Sub Containers.

      • In case of a source, the job will fetch data from the container.
      • In case of a destination the job will create or update data in the container.

    • Microsoft Entra ID

      Specify a container. To include sub containers, select the checkbox Include Sub Containers.

      • In case of a source, the job will fetch data from the container.
      • In case of a destination, the job will create or update data in the container.

    • Generic LDAP

      You don't need to provide any additional information for this provider.

    • Google Workspace

      Specify a container. To include sub containers, select the checkbox Include Sub Containers.

      • In case of a source, the job will fetch data from the container.
      • In case of a destination, the job will create or update data in the container.

    • Microsoft Access

      In the Table Name dropdown list, select the table you want to use.

      The list displays the tables in the selected Microsoft Access database.

    • Microsoft Excel

      In the Select Sheet Name dropdown list, select the sheet you want to use.

      The list displays the sheets in the selected Microsoft Excel file.

      1. In case of Excel as destination (with Replace file-discard existing content option selected on the Destination Provider page of the Job wizard), if any sheet name of the Excel file is of two or less character the Synchronize job corrupts all the sheets in that Excel file.

      2. In case of Excel as destination (with Delete option selected on the Create Object page of the Job wizard), If the Excel file schema is of more than 127 columns the job fails.

    • Oracle

      In the Table or View dropdown list, select the database table you want to use.

      The list displays the tables in the Oracle database.

      In case the type column of Oracle database isn't set as Datetime then time stamp functionality of Synchronize don't work. The given type needs to be converted into Datetime explicitly while configuring the Synchronize job.

    • ODBC

      In Table Name box, enter the name of the table you want to use.

    • Microsoft SQL Server

      In the Table or View dropdown list, select the database table you want to use.

      The list displays the tables in the Microsoft SQL Server database.

    • Text Driver/CSV

      You don't need to provide any additional information for this provider.

  2. Click Next Step.