Tools/SharePoint

SharePoint ODBC Driver

ZappySys

Connect to SharePoint Online from SQL Server, Power BI, Excel, SSIS, or any ODBC-compatible tool. Read and write sites, lists, files, and document libraries using familiar SQL with OAuth or Application Credentials — no custom API code to maintain. Part of ZappySys ODBC PowerPack.

SSIS SharePoint Connector

ZappySys

Read and write SharePoint Online sites, lists, files, and document libraries in SSIS using the API Source and Destination components. Query items with SQL-like syntax, upload or download files, and create, update, or delete records via OAuth auth. Part of ZappySys SSIS PowerPack.