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

# Amazon Redshift

CData Sync アプリケーションからAmazon Redshift コネクタを使用して、サポートされている任意のデータソースから同期先のAmazon Redshift へデータを移動できます。これを行うには、コネクタを追加し、コネクタへの認証を行い、接続を完了する必要があります。

## Amazon Redshift コネクタを追加

Sync でAmazon Redshift のデータを使用できるようにするには、まず以下の手順でコネクタを追加する必要があります：

<ol>
  <li>Sync のダッシュボードから**接続**ページを開きます。</li>
  <li>**接続を追加**をクリックして**コネクタを選択**ページを開きます。</li>
  <li>**同期先**タブをクリックして
  **Amazon Redshift** 行に移動します。</li>

  <li>
    行末にある**接続を設定**アイコンをクリックして、**新しい接続**ページを開きます。この操作により、
    **接続を追加**ダイアログボックスが開きます。

    **Note：** **接続を設定**アイコンが表示されない場合は、**コネクタをダウンロード**アイコンをクリックして Amazon Redshift コネクタをインストールしてください。
  </li>

  <li>**接続を追加**ダイアログボックスに接続名を入力します。</li>
  <li>**追加**をクリックして、コネクタの**設定**タブを開きます。</li>
</ol>

新しいコネクタのインストールについての詳細は、
[接続](https://docs.sync.cdata.com/26.4/ja/connections/connections.md)を参照してください。

## Amazon Redshift への認証

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

* **Server:** Enter the host name or IP of the server that hosts the Amazon Redshift database (for example, example.us-west-2.redshift.amazonaws.com).
* **Database:** Enter the name of the database that you create for your Amazon Redshift cluster.

CData Sync supports authenticating to Amazon Redshift in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**Basic**](#basic) (default)
* [**ADFS**](#adfs)
* [**IAM Credentials**](#iam-credentials)
* [**PingFederate**](#pingfederate)
* [**Azure Active Directory**](#azure-active-directory)
* [**Azure Active Directory PKCE**](#azure-active-directory-pkce)

### Basic

To connect with your user credentials, specify the following properties:

* **Auth Scheme:** Select **Basic**.
* **User:** Enter the username that you use to authenticate to Amazon Redshift.
* **Password:** Enter the password that you use to authenticate to Amazon Redshift.

### ADFS

To connect with single sign-on (SSO) via ADFS, specify the following properties:

* **Auth Scheme:** Select **ADFS**.
* **User:** Enter the username that you use to authenticate to ADFS.
* **Password:** Enter the password that you use to authenticate to ADFS.
* **SSO Login URL:** Enter the login URL that is used by your SSO provider.
* **SSO Properties:** Enter the SSO properties that you want to use. Separate the property values in a semicolon-separated list (for example, *SSOProperty1*=*Value1*;*SSOProperty2*=*Value2*;*SSOProperty3*=*Value3*;).

### IAM Credentials

To connect with IAMCredentials, specify the following properties:

* **Auth Scheme:** Select **IAMCredentials**.
* **User:** Enter the username that you use to authenticate to Amazon Redshift.
* **AWS Access Key:** Enter the access key that is associated with your Amazon Web Services (AWS) account. This value is accessible from your AWS security credentials page.
* **AWS Secret Key:** Enter the secret key that is associated with your AWS account. This value is accessible from your AWS security credentials page.

### PingFederate

To connect with single sign-on via PingFederate, specify the following properties:

* **Auth Scheme:** Select **PingFederate**.
* **User:** Enter the username that you use to authenticate to PingFederate.
* **Password:** Enter the password that you use to authenticate to PingFederate.
* **SSO Login URL:** Enter the login URL that is used by your SSO provider.
* **SSO Properties:** Enter the SSO properties that you want to use. Separate the property values in a semicolon-separated list (for example, *SSOProperty1*=*Value1*;*SSOProperty2*=*Value2*;*SSOProperty3*=*Value3*;).
* **SSO Exchange Url:** Enter the Partner Service Identifier URI that is configured in your PingFederate server instance. The URI is available under **SP Connections > SP Connection > WS-Trust > Protocol Settings**.
* (Optional) **AWS Principal ARN:** The Amazon Resource Name (ARN) of the Security Assertion Markup Language (SAML) identity provider in your Amazon Web Services (AWS) account.

### Azure Active Directory

To connect with Azure Active Directory, specify the following properties:

* **Auth Scheme:** Select **AzureAD**.
* **User:** Enter the username that you use to authenticate to Amazon Redshift.
* **Azure Tenant:** Enter the Microsoft Online tenant that is used to access data. If you do not specify a tenant, Sync uses the default tenant.
* **SSO Login URL:** Enter the login URL that is used by your SSO provider.
* **OAuth Client Id:** Enter the client Id that you were assigned when you registered your application with an OAuth authorization server.
* **OAuth Client Secret:** Enter the client secret that you were assigned when you registered your application with an OAuth authorization server.
* **Scope:** Enter the scope value that is necessary for obtaining initial access and for refreshing the token. The scope is based on your OAuth token version, as follows:
  * For v1.0 OAuth tokens, set this property to the **Scopes** field that is available on the **Expose an API** page of your OAuth application.
  * For v2.0 OAuth tokens, enter the client Id for your OAuth application.

### Azure Active Directory PKCE

To connect with Azure Active Directory PKCE, specify the following properties:

* **Auth Scheme:** Select **AzureADPKCE**.
* **OAuth Client Id:** Enter the client Id that you were assigned when you registered your application with an OAuth authorization server.
* **Scope:** Enter the scope value based on your OAuth token version, as follows:
  * For v1.0 OAuth tokens, set this property to the **Scopes** field that is available on the **Expose an API** page of your OAuth application.
  * For v2.0 OAuth tokens, enter the client Id for your OAuth application.

## 接続を完了する

To complete your connection:

1. In the **Port** (optional) text box, enter the port number of the server that hosts the Amazon Redshift database. The default port value is **5439**.
2. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
3. If you authenticate with AzureAD, click **Connect to Amazon Redshift** to connect to your Amazon Redshift account.
4. Click **Create & Test** to create your connection.

## 詳細について


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.