Sharepoint Connector

Sharepoint Connector

Additional Documentation

This Connector is based on the Sharepoint ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RSG/ado/


If connecting to Sharepoint using Single Sign-on (SSO)

You might see this error if not connected appropriately - "[500] Could not execute the specified command: unrecognized response when getting SharePoint online security cookies, please check your credentials."

Add "UseSSO=true" to the Starfish Sharepoint Connector configuration.

SSO configuration options:

Use SSO=true Auth Cookie=”” SSO Domain=”” - SSODomain may be required to be set if the domain configured on the SSO domain is different than the domain of the User.

Check SharePoint user configuration as well too:

User name needs to match the format of username@domain.onmicrosoft.com. After logging in to http://yourdomain.sharepoint.com/TeamSite, the "keep me signed in" setting must be checked in order for the connection to be established


Parameter
Description
Url

Edition


SharePoint Connection Edit Screen


    • Related Articles

    • Excel Connector

      Additional Documentation This Connector is based on the Excel ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RXG/ado/ Establishing a Connection Connecting to Excel Data ...

    • Hubspot Connector

      Additional Documentation This Connector is based on the Hubspot ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/DHG/ado/ Hubspot Connector Note: As of September 8, 2020 ...

    • Act! Connector

      ACT! Premium Cloud: StarfishETL supports two-way integration. ACT! On-Prem: StarfishETL does not have a native Act! connector for versions less than Act v18 so we read directly from the database. Configuration Options Connect Act Premium (v18+) using ...

    • Pardot Connector

      Additional Documentation This Connector is based on the Salesforce Pardot ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/GPG/ado/ Overview The Starfish Pardot Connector ...

    • CSV Connector

      Additional Documentation This Connector is based on the CSV ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RVG/ado/ CSV Via Upload (in Cloud Cartographer) When you upload ...