Connecting to Excel Services

Establishing a Connection shows how to authenticate to Excel Services and configure any necessary connection properties from the Connection Manager window.

You can also configure component capabilities through the available Connection properties, from data modeling to firewall traversal. The Advanced Settings section shows how to set up more advanced configurations and troubleshoot connection errors.

Visual Studio Version Support

The CData SSIS Components for Microsoft SharePoint Excel supports Visual Studio versions 2015 and above.

SSIS Version Support

The CData SSIS Components for Microsoft SharePoint Excel provide data flow components that allow for straightforward integration with Excel Services data from SSIS data flow tasks. SQL Server 2014, 2016, 2017, 2019, and 2022 are supported including their corresponding version of SQL Server Data Tools.

Excel Services Version Support

The component supports retrieving Excel data from SharePoint On-Premises through the REST API and through the OData API introduced in SharePoint 2013. Excel files must have the .xlsx format used in Excel 2007 and later.

Note: Microsoft has stated that they plan to sunset the Excel Services API for SharePoint Online in February 2022. Please consider migrating to the CData component for Excel Online for future access to your SharePoint data.

See Also

• Using the Source Component: Pull Excel Services data into your data flow task.
• Deploying to Azure: Deploy the CData components to Azure from Visual Studio.
• Troubleshooting: The component installation automatically adds the components to the toolbox; if you do not see the components, you can find the procedure to add them here.