> ## 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.

# Airbyte

> このページではAirbyte をConnect AI の仮想SQL Server API に接続する手順の概要を示します。

## 前提条件

接続する前にまず以下を実行します：

* データソースをConnect AI アカウントに接続します。詳しくは、[Sources](/ja/Sources) を参照してください。
* [Settings](/ja/Settings/Personal-Access-Tokens) ページでPersonal Access Token (PAT) を生成します。PAT をコピーし、認証時にパスワードとして使用します。

## Connect AI に接続する

Airbyte からConnect AI の仮想SQL Server API へのコネクションを確立するには以下の手順に従います。

<Steps>
  <Step>
    Log in to your Airbyte account.

    <Frame>
      <img src="https://mintcdn.com/cdata/T-Lu1oefp5G_-4JC/ja/images/airbyte_client_01.png?fit=max&auto=format&n=T-Lu1oefp5G_-4JC&q=85&s=09ae7f805b721dd39152d788ef831ecc" alt="Airbyte login" width="1216" height="713" data-path="ja/images/airbyte_client_01.png" />
    </Frame>
  </Step>

  <Step>
    On the left pane, click **Sources**, then **Add New Source**.
  </Step>

  <Step>
    Select MSSQL Server from **Source Type** to connect the TDS endpoint.
  </Step>

  <Step>
    Enter your **Source Name**.
  </Step>

  <Step>
    Enter your **Host** URL. In this case the host is *tds.cdata.com*.
  </Step>

  <Step>
    Add the **Port** to connect to. In the example, the port is *14333*.
  </Step>

  <Step>
    Enter the **Database** to connect to. In the example, the Database is *GoogleSheets1*.
  </Step>

  <Step>
    Enter the **Username** you use to connect to the source.
  </Step>

  <Step>
    For the **SSL Method**, use **Encrypted (trust server certificate)**, leave the **Replication Method** as standard, and the **SSH Tunnel Method** as **No Tunnel**.
  </Step>

  <Step>
    Add any **Schema** you want to apply to the source.
  </Step>

  <Step>
    Enter your **Password** for the source.

    <Frame>
      <img src="https://mintcdn.com/cdata/T-Lu1oefp5G_-4JC/ja/images/airbyte_client_02.png?fit=max&auto=format&n=T-Lu1oefp5G_-4JC&q=85&s=48c1cf3bf79fd01ee58116478798f1b8" alt="Airbyte source" width="422" height="1072" data-path="ja/images/airbyte_client_02.png" />
    </Frame>
  </Step>

  <Step>
    (Optional) Enter any needed **JDBC URL Params**.

    <Note>
      When connecting with Airbyte On-Premises, enter `workstationID=Airbyte` in this field.
      Do not include `;` at the end of the property.
    </Note>

    <Frame>
      <img src="https://mintcdn.com/cdata/T-Lu1oefp5G_-4JC/ja/images/airbyte_client_03.png?fit=max&auto=format&n=T-Lu1oefp5G_-4JC&q=85&s=125cdff426a927dd5267e4a5d5f8b73d" alt="Airbyte on-prem" width="1440" height="1582" data-path="ja/images/airbyte_client_03.png" />
    </Frame>
  </Step>

  <Step>
    Click **Test and Save** to create the data source. You can now connect your source with a destination, which you will need to create separately.
  </Step>

  <Step>
    To connect your new source with your destination, click **Connections** and then **Set Up Connection**.
  </Step>

  <Step>
    Select the source created above and your desired destination, then allow Airbyte to process. When it is done, your connection is ready for use.
  </Step>
</Steps>