OData

Version 25.3.9414


OData


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

OData コネクタを追加

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

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

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

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

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

OData への認証

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

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

  • URL - Enter the URL to your organization root or to the OData services file.

    • Auth Scheme - Select the authentication scheme that you want to use. The default setting is None.

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

None

認証なしで接続するには、Auth SchemeNone を選択します。追加のプロパティは必要ありません。

Azure Active Directory

To connect with an Azure Active Directory (AD) user account, specify the following properties:

  • Auth Scheme - Select AzureAD.

  • Azure Tenant - Enter the OData tenant that is used to access data. Enter either the name (for example, YourTenantName.com) or the identifier (for example, Conditional).

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

Basic

ユーザー資格情報で接続するには、次のプロパティを設定します。

  • Auth Scheme:Basic を選択。

  • User:OData アカウントへの認証に使用するユーザー名を入力。

  • Password:OData アカウントへの認証に使用するパスワードを入力。

Digest

ユーザー資格情報で接続するには、次のプロパティを設定します。

  • Auth Scheme - Digest を選択。

  • User - OData アカウントへの認証に使用するユーザー名を入力。

  • Password - OData アカウントへの認証に使用するパスワードを入力。

Negotiate

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

  • Auth Scheme: Select Negotiate.

  • Kerberos KDC - Enter the Kerberos Key Distribution Center (KDC) service that you use to authenticate.

  • Kerberos SPN - Enter the service principal name (SPN) for the Kerberos domain controller.

NTLM

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

  • Auth Scheme – Select NTLM.

  • User - Enter the username that you use to authenticate to your OData account.

  • Password - Enter the password that you use to authenticate to your OData account.

OAuth

To connect with OAuth custom credentials, specify the following properties:

  • Auth Scheme – Select OAuth.

  • Initiate OAuth - Select the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working.

    • OFF - By choosing this setting, automatic OAuth-flow initiation is turned off. The OAuth flow is handled entirely by the user. With this setting, the user must refresh the token manually and reconnect with an updated OAuthAccessToken property when the current token expires.

    • REFRESH - When you choose this setting, the OAuth flow is handled entirely by the Sync application. If a token exists already, it is refreshed when necessary. If no token currently exists, it is obtained by prompting the user to login.

    • GETREFRESH - With you select this setting, the user is responsible for obtaining the initial OAuth access token and for configuring the refresh sequence. The user is not prompted to log in for authentication. After the initial login, the Sync application automatically manages the OAuth access token refresh process.

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

  • OAuth Authorization URL (optional) - Enter the OAuth authorization URL that you need to authorize request tokens when you sign in.

  • OAuth Access Token URL (optional) - Enter the URL where the request for the access token is made.

  • OAuth Refresh Token URL (optional) - Enter the URL where the refresh token is exchanged for a new access token when the old one expires. Note that for your data source, this URL might be the same as the access-token URL.

OAuth Password

To connect with OAuth via a password grant type, specify the following properties:

  • Auth Scheme – Select OAuthPassword.

  • User - Enter the username that you use to authenticate to your OData account.

  • Password - Enter the password that you use to authenticate to your OData account.

  • Initiate OAuth - Select the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working.

    • OFF - By choosing this setting, automatic OAuth-flow initiation is turned off. The OAuth flow is handled entirely by the user. With this setting, the user must refresh the token manually and reconnect with an updated OAuthAccessToken property when the current token expires.

    • REFRESH - When you choose this setting, the OAuth flow is handled entirely by the Sync application. If a token exists already, it is refreshed when necessary. If no token currently exists, it is obtained by prompting the user to login.

    • GETREFRESH - With you select this setting, the user is responsible for obtaining the initial OAuth access token and for configuring the refresh sequence. The user is not prompted to log in for authentication. After the initial login, the Sync application automatically manages the OAuth access token refresh process.

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

  • OAuth Access Token URL (optional) - Enter the URL where the request for the access token is made.

  • OAuth Refresh Token URL (optional) - Enter the URL where the refresh token is exchanged for a new access token when the old one expires. Note that for your data source, this URL might be the same as the access-token URL.

OAuth Client

To connect with OAuth via a client grant type, specify the following properties:

  • Auth Scheme – Select OAuthPassword.

  • Initiate OAuth - Select the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working.

    • OFF - By choosing this setting, automatic OAuth-flow initiation is turned off. The OAuth flow is handled entirely by the user. With this setting, the user must refresh the token manually and reconnect with an updated OAuthAccessToken property when the current token expires.

    • REFRESH - When you choose this setting, the OAuth flow is handled entirely by the Sync application. If a token exists already, it is refreshed when necessary. If no token currently exists, it is obtained by prompting the user to login.

    • GETREFRESH - With you select this setting, the user is responsible for obtaining the initial OAuth access token and for configuring the refresh sequence. The user is not prompted to log in for authentication. After the initial login, the Sync application automatically manages the OAuth access token refresh process.

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

  • OAuth Access Token URL (optional) - Enter the URL where the request for the access token is made.

  • OAuth Refresh Token URL (optional) - Enter the URL where the refresh token is exchanged for a new access token when the old one expires. Note that for your data source, this URL might be the same as the access-token URL.

SharePoint Online

To connect with SharePoint Online credentials, specify the following properties:

  • User - Enter the username that you use to authenticate to your OData account.

  • Password - Enter the password that you use to authenticate to your OData account.

Complete Your Connection

To complete your connection:

  1. 高度な設定タブで接続の高度な設定を定義します。(ただし、ほとんどの場合これらの設定は必要ありません。)

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

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

詳細情報

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