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

# Azure SQL Database

export const CommonDatasourceAddConnector = ({datasource = "the data source", title = "the connector", destination = false, siteNameShort = "Sync"}) => {
  return <>
      <p>
        {siteNameShort} で{datasource} のデータを使用できるようにするには、まず以下の手順でコネクタを追加する必要があります：
      </p>
      <ol>
        <li>{siteNameShort} のダッシュボードから<strong>接続</strong>ページを開きます。</li>
        <li><strong>接続を追加</strong>をクリックして<strong>コネクタを選択</strong>ページを開きます。</li>
        <li>
          <strong>{destination ? "同期先" : "データソース"}</strong>タブをクリックして
          <strong>{title}</strong> 行に移動します。
        </li>
        <li>
          行末にある<strong>接続を設定</strong>アイコンをクリックして、<strong>新しい接続</strong>ページを開きます。この操作により、{' '}
          <strong>接続を追加</strong>ダイアログボックスが開きます。
          <br />
          <strong>Note：</strong> <strong>接続を設定</strong>アイコンが表示されない場合は、<strong>コネクタをダウンロード</strong>アイコンをクリックして {title} コネクタをインストールしてください。
        </li>
        <li><strong>接続を追加</strong>ダイアログボックスに接続名を入力します。</li>
        <li><strong>追加</strong>をクリックして、コネクタの<strong>設定</strong>タブを開きます。</li>
      </ol>
      <p>
        新しいコネクタのインストールについての詳細は、{' '}
        <a href="../connections">接続</a>を参照してください。
      </p>
    </>;
};

export const CommonDatasourceIntroDestination = ({datasource = "the data source", siteName = "CData Sync"}) => {
  return <p>
      {siteName} アプリケーションから{datasource} コネクタを使用して、サポートされている任意のデータソースから同期先の{datasource} へデータを移動できます。これを行うには、コネクタを追加し、コネクタへの認証を行い、接続を完了する必要があります。
    </p>;
};

export const driverVersion = "M";

export const siteNameShort = "Sync";

export const siteName = "CData Sync";

<CommonDatasourceIntroDestination datasource="Azure SQL Database" siteName={siteName} />

## Azure SQL Database コネクタを追加

<CommonDatasourceAddConnector datasource="Azure SQL Database" title="Azure SQL Database" destination={true} siteNameShort={siteNameShort} />

## Azure SQL Database への認証

After you add the connector, you need to set the required properties.

* **Server:** Enter the name of the data source to which you want to connect.
* **Port:** Enter the port number for the Azure SQL Database. The default port value is **1433**.
* **Database:** Enter the name of the intial catalog or database in your data source.

{siteName} supports authenticating to Azure SQL Database in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**SQL Password**](#sql-password) (default)
* [**Active Directory Service Principal**](#active-directory-service-principal)
* [**Active Directory Password**](#active-directory-password)
* [**Active Directory Managed Service Identity**](#active-directory-managed-service-identity)

### SQL Password

To connect with your SQL password, specify the following properties:

* **Auth Scheme:** Select **SqlPassword**.
* **User:** Enter the username that you use to authenticate to Azure SQL Database.
* **Password:** Enter the password that you use to authenticate to Azure SQL Database.

### Active Directory Service Principal

To connect with an Active Directory service principal, set the following properties:

* **Auth Scheme:** Select **ActiveDirectoryServicePrincipal**.
* **Principal Id:** Enter your principal identifier (Id).
* **Principal Secret:** Enter your principal secret.

### Active Directory Password

To connect with an Active Directory password, set the following properties:

* **Auth Scheme:** Select **ActiveDirectoryPassword**.
* **User:** Enter the username that you use to authenticate to Azure SQL Database.
* **Password:** Enter the password that you use to authenticate to Azure SQL Database.

### Active Directory Managed Service Identity

To leverage the Active Directory Managed Service Identity (MSI) when {siteName} is running on an Azure virtual machine, select **ActiveDirectoryMSI** for **Auth Scheme**. No additional properties are required.

## 接続を完了する

To complete your connection:

1. Specify the following properties:
   * **Trust Server Certificate:** Select whether you want to trust the server certificate. By default, the **Enable** checkbox is already selected.
   * **Encrypt:** Select whether you want to encrypt the database. By default, the **Enable** checkbox is not selected.
2. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
3. Click **Create & Test** to create your connection.

**Note:** The Java version requires the Microsoft SQL Server JDBC driver. You can download the driver from the <a href="https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server" target="_blank" rel="noopener noreferrer">Microsoft Download Center</a>.

Copy the JDBC driver into the `libs` directory and restart the server.

* **Microsoft Windows:** `C:\ProgramData\CData\sync\libs`
* **UNIX or Mac OS X:** `~/cdata/sync/libs`