• Setup Guide
  • AzureAD
  • AzurePassword
• Authentication Methods
  • OAuth JWT
  • PingFederate
  • ADFS
  • OneLogin
  • OKTA
• More Information

Setup Guide

Follow these steps to connect SharePoint to your CData Connect Cloud account:

1. Open the Connections page of the CData Connect Cloud dashboard.

2. Click + Add Connection in the upper-right corner.

3. Type SharePoint into the search field, then click the data source name.

4. On the Basic Settings tab of the new connection, enter a connection name or keep the default name.

5. Enter the base URL for the SharePoint site (for example, https://teams.contoso.com).

6. Select the Share Point Edition from the drop down.

7. Select the Authentication method, then proceed to the relevant section and follow those instructions.

AzureAD

1. Choose REST or SOAP from the Schema drop-down list.

2. Click Sign in to connect securely through OAuth. This action opens the SharePoint sign-in page in a new tab.

3. Log in to your SharePoint account and provide the requested permissions (if applicable).

4. At the top of the CData Connect Cloud Add SharePoint Connection page, click Save & Test.

   • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

   • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

   • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

AzurePassword

1. Enter your User Id.

2. Add the Password for that account.

3. Enter the Azure Tenant Id found on the Overview page of the OAuth app used to authenticate to Microsoft SharePoint on Azure.

4. Choose REST or SOAP from the Schema drop-down list.

5. At the top of the CData Connect Cloud Add SharePoint Connection page, click Save & Test.

   • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

   • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

   • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

Authentication Methods

OAuth JWT

1. Enter the Azure Tenant Id found on the Overview page of the OAuth app used to authenticate to Microsoft SharePoint on Azure.

2. Enter your OAuth JWT Certificate. This is multi-line and in PEM format.

3. Select the OAuth JWT Cert type.

4. Enter the OAuth JWT Issuer. This should be set to the OAuth client Id.

5. Choose REST or SOAP from the Schema drop-down list.

6. At the top of the CData Connect Cloud Add SharePoint Connection page, click Save & Test.

   • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

   • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

   • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

PingFederate

1. Enter the PingFederate User Id.

2. Add the Password for that account.

3. Enter the SSO Domain to connect to.

4. Choose REST or SOAP from the Schema drop-down list.

5. At the top of the CData Connect Cloud Add SharePoint Connection page, click Save & Test.

   • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

   • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

   • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

ADFS

1. Enter the ADFS User Id.

2. Add the Password for that account.

3. Enter the SSO Domain to connect to.

4. Choose REST or SOAP from the Schema drop-down list.

5. At the top of the CData Connect Cloud Add SharePoint Connection page, click Save & Test.

   • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

   • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

   • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

OneLogin

1. Enter the OneLogin User Id.

2. Add the Password for that account.

3. Enter the SSO Domain to connect to.

4. Choose REST or SOAP from the Schema drop-down list.

5. At the top of the CData Connect Cloud Add SharePoint Connection page, click Save & Test.

   • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

   • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

   • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

OKTA

1. Enter the OKTA User Id.

2. Add the Password for that account.

3. Enter the SSO Domain to connect to.

4. Choose REST or SOAP from the Schema drop-down list.

5. At the top of the CData Connect Cloud Add SharePoint Connection page, click Save & Test.

   • If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.

   • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.

   • Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

More Information

For more information about interactions between CData Connect Cloud and SharePoint, see this information page.