Version 25.3.9414

• Microsoft SharePoint Excel コネクタを追加
• Microsoft SharePoint Excel への認証
  • NTLM
  • Basic
  • Digest
  • Forms
  • None
  • Negotiate
  • Active Directory Federation Services (ADFS)
• Complete Your Connection
• 詳細情報

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

Microsoft SharePoint Excel コネクタを追加

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

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

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

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

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

Microsoft SharePoint Excel への認証

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

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

• URL - Enter the base URL for a site or site collection.

• File - Enter the name of the Microsoft Excel workbook to which you want to connect.

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

• NTLM (default)
• Basic
• Digest
• Forms
• None
• Negotiate
• Active Directory Federation Services

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 the Microsoft server.

• Password - Enter the password that you use to authenticate to the Microsoft server.

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 the Microsoft server.

• Password - Enter the password that you use to authenticate to the Microsoft server.

Digest

To connect with digest-authentication credentials, specify the following properties:

• Auth Scheme – Select Digest.

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

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

Forms

To connect with a custom authentication method, specify the following properties:

• Auth Scheme – Select Forms.

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

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

None

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

Negotiate

To connect with Kerberos credentials, specify the following properties:

• Auth Scheme – Select Negotiate.

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

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

Active Directory Federation Services (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 your ADFS account.

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

• STSURL - The URL of the security token service (STS).

• SSO Login URL - Enter the login URL that is used by your SSO provider.

• SSO Domain - Enter the domain of the user.

• SSO Properties - Enter additional properties that are required to connect to your identity provider. You must use a semicolon-separated list of properties (for example, SSOProperty1=Value1;SSOProperty2=Value2;…).

Complete Your Connection

To complete your connection:

1. Specify the following properties:

   • SharePoint Version - Select your version of Microsoft SharePoint from the list. The default version is SharePoint 2013.

   • Folder - Enter the path to the folder that contains the workbook that you specified earlier for File.

   • Library - Specify the document library to which you want to connect.

   • Use RESTAPI - Set this property to True if you want to connect to spreadsheets or ranges as tables. The default value is True.”

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

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

詳細情報

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