Version 23.4.8843

• Amazon Redshift コネクタを追加
• Amazon Redshift への認証
  • Basic
  • ADFS
  • IAMCredentials
  • PingFederate
  • AzureAD
  • AzureADPKCE
• Complete Your Connection
• 詳細情報

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

Amazon Redshift コネクタを追加

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

1. Sync のダッシュボードから接続ページを開きます。

2. 接続を追加をクリックしてコネクタを選択ページを開きます。

3. データソースタブをクリックしてAmazon Redshift 行に移動します。

4. 行末にある接続を設定アイコンをクリックして、新しい接続ページを開きます。接続を設定アイコンが利用できない場合は、コネクタをダウンロードアイコンをクリックしてAmazon Redshift コネクタをインストールします。新規コネクタのインストールについて詳しくは、接続を参照してください。

Amazon Redshift への認証

コネクタを追加したら、必須プロパティを設定する必要があります。

• Connection Name - Enter a connection name of your choice.

• 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 (default)
• ADFS
• IAMCredentials
• PingFederate
• AzureAD
• AzureADPKCE

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;).

IAMCredentials

To connect with your IAM user credentials, 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.

• AWS Principal ARN (optional) - The Amazon Resource Name (ARN) of the Security Assertion Markup Language (SAML) identity provider in your Amazon Web Services (AWS) account.

AzureAD

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.

AzureADPKCE

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.

Complete Your Connection

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. 高度な設定タブで接続の高度な設定を定義します。（ただし、ほとんどの場合これらの設定は必要ありません。）

3. AzureAD で認証する場合は、Amazon Redshift への接続 をクリックしてAmazon Redshift アカウントに接続します。

4. 作成およびテストをクリックして接続を作成します。

詳細情報

CData Sync とAmazon Redshift の連携について、詳しくはAmazon Redshift Connector for CData Sync を参照してください。