> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CData Sync

> This page outlines the steps to connect CData Sync to your Connect AI account.

## Prerequisites

Before you connect, you must first do the following:

* Connect a data source to your Connect AI account. See [Sources](/ja/Sources) for more information.
* Generate a Personal Access Token (PAT) on the [Settings](/ja/Settings#personal-access-tokens) page. Copy this down, as it acts as your password during authentication.

## Connect to Connect AI

To establish a connection from CData Sync to Connect AI, follow these steps.

<Steps>
  <Step>
    Log in to CData Sync.
  </Step>

  <Step>
    In the navigation menu, select **Connections**. Click **Add Connection**.
  </Step>

  <Step>
    On the **Select Connectors** page, select the **Sources** tab, and enter *CData Connect* in the search field.

    <Note>
      Click the download icon to download the connector if it is not already installed.
    </Note>
  </Step>

  <Step>
    Click **CData Connect** to configure the connection. A **New Connection** page appears.
  </Step>

  <Step>
    Enter the following settings for your connection for your source data.

    * **Connection name**—enter the name of your connection for display purposes.
    * **Auth Scheme**—use **Basic**.
    * **User**—Connect AI のユーザー名を入力します。ユーザー名は、Connect AI の画面の右上に表示されています。例：*[test@cdata.co.jp](mailto:test@cdata.co.jp)*
    * **Password**—[Settings](/ja/Settings#personal-access-tokens) ページで生成したPAT を入力します。
    * **URL**—Enter *`https://cloud.cdata.com/api`*.
    * **Default Catalog**—(optional) enter the name of your default catalog.
    * **Workspace**—(optional) enter the name of the workspace with which you want to connect.

    <Frame>
      <img src="https://mintcdn.com/cdata/TfqVmUuBCnNRmW2K/ja/images/cdatasync_source_connection.png?fit=max&auto=format&n=TfqVmUuBCnNRmW2K&q=85&s=c7da9bc5034e8d6a4d4362a8fe32a447" alt="" width="1946" height="1182" data-path="ja/images/cdatasync_source_connection.png" />
    </Frame>
  </Step>

  <Step>
    Click **Create & Test**. If the connection is successful, the Connect AI connection appears on the **Connections** page.
  </Step>
</Steps>

Now you need to configure your connection for your destination data. For this example, the destination data is a SQL Server database.

<Steps>
  <Step>
    In the navigation menu, select **Connections**. Click **Add Connection**.
  </Step>

  <Step>
    On the **Select Connectors** page, select the **Destinations** tab, and enter *SQL Server* in the search field.

    <Note>
      Click the download icon to download the destination connector if it is not already installed.
    </Note>
  </Step>

  <Step>
    Click **SQL Server** to configure the connection. A **New Connection** page appears.
  </Step>

  <Step>
    Enter the following settings for your connection for your destination data.

    <Note>
      For other destination connection configurations, see the [CData Sync documentation](https://cdn.cdata.com/help/ASM/jp/sync/index.html).
    </Note>

    * **Connection name**—enter the name of your connection for display purposes.
    * **Server**—enter the host name or IP address of the server that hosts the SQL Server database. The default server is localhost.
    * **Port**—enter the port number for SQL Server. The default port value is 1433.
    * **Database**— enter the default database to which you want to connect when you connect to SQL Server.
    * **User**—enter the username that you use to authenticate to SQL Server.
    * **Password**—enter the password that you use to authenticate to SQL Server.

    <Frame>
      <img src="https://mintcdn.com/cdata/TfqVmUuBCnNRmW2K/ja/images/cdatasync_dest_connection.png?fit=max&auto=format&n=TfqVmUuBCnNRmW2K&q=85&s=c95e011976479cc12caba38a7049c22d" alt="" width="1253" height="620" data-path="ja/images/cdatasync_dest_connection.png" />
    </Frame>
  </Step>

  <Step>
    Click **Create & Test**. If the connection is successful, the connection appears on the **Connections** page.
  </Step>
</Steps>

To add a job to CData Sync and run the job, follow these steps.

<Steps>
  <Step>
    In the navigation menu, select **Jobs**. Click **Add Job** > **Add New Job**.
  </Step>

  <Step>
    In the **Add Job** dialog, enter the following information.

    * **Name**—enter the name of the job for display purposes.
    * **Source**—select the Connect AI connection you created.
    * **Destination**—select the destination connection you created.
    * **Type**—select either **Standard** or **Sync All**.
  </Step>

  <Step>
    Click **Add Job**.
  </Step>

  <Step>
    In **Jobs**, click the new job you just created. In the **Task** tab, click **Add Tasks**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TfqVmUuBCnNRmW2K/ja/images/cdatasync_addtasks.png?fit=max&auto=format&n=TfqVmUuBCnNRmW2K&q=85&s=0847af9307fb3656a7b7fc11341cf5ee" alt="" width="1249" height="625" data-path="ja/images/cdatasync_addtasks.png" />
    </Frame>
  </Step>

  <Step>
    In the **Select Schema** dialog, select the schema and table you want to replicate.

    <Frame>
      <img src="https://mintcdn.com/cdata/TfqVmUuBCnNRmW2K/ja/images/cdatasync_selectschema.png?fit=max&auto=format&n=TfqVmUuBCnNRmW2K&q=85&s=a738bd2def647bf6197beb704809dfc0" alt="" width="1249" height="625" data-path="ja/images/cdatasync_selectschema.png" />
    </Frame>
  </Step>

  <Step>
    The table is added as a task. Click **Run** to run the task.

    <Frame>
      <img src="https://mintcdn.com/cdata/TfqVmUuBCnNRmW2K/ja/images/cdatasync_runtask.png?fit=max&auto=format&n=TfqVmUuBCnNRmW2K&q=85&s=2c1e4b6e4f32d979b9d1ce345a665948" alt="" width="1245" height="615" data-path="ja/images/cdatasync_runtask.png" />
    </Frame>
  </Step>

  <Step>
    The table is replicated to your destination.

    <Frame>
      <img src="https://mintcdn.com/cdata/TfqVmUuBCnNRmW2K/ja/images/cdatasync_replicated.png?fit=max&auto=format&n=TfqVmUuBCnNRmW2K&q=85&s=92c1ee6b8902cfdcc2b9d44a0519a11b" alt="" width="1246" height="531" data-path="ja/images/cdatasync_replicated.png" />
    </Frame>
  </Step>
</Steps>