The SharePoint ODBC Driver is a powerful tool that allows you to connect with live data from SharePoint, directly from any applications that support ODBC connectivity. Access SharePoint data like you would a database - read, write, and update SharePoint Lists, Contacts, Calendar, Links, Tasks, etc. through a standard ODBC Driver interface.
See what you can do with SharePoint ODBC Driver
Server
Connect to SharePoint from SQL Server as Linked-Server. You can query SharePoint from familiar Transact-SQL without need of setting up another application.
Integrate SharePoint to your system through popular ETL / EAI tools such as Informatica PowerCenter. Standard SQL and Stored Procedures enable fast delivery of your integration projects.
Connect SharePoint from any ODBC compatible tools:
Desktop
Your familiar tools can connect to SharePoint using CData ODBC.
- Microsoft Access
- Power Query
- DBeaver
- and more
SharePoint ODBC Connectivity Features
- Compatible with Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007 and above, and SharePoint Online
- Support for Hidden and LookUp columns
- Recursively scan Folders to create an in-depth relational model of your SharePoint data
- Supports uploading and downloading documents and attachments
- Powerful metadata querying enables SQL-like access to non-database sources
- Push down query optimization pushes SQL operations down to the server whenever possible, increasing performance
- Client-side query execution engine, supports SQL-92 operations that are not available server-side
- Connect to live Microsoft SharePoint data, for real-time data access with the Microsoft SharePoint JDBC Driver
- Full support for data aggregation and complex JOINs in SQL queries
- Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
- Seamless integration with leading BI, reporting, and ETL tools and with custom applications via the SharePoint Connector.
Target Service, API
The driver supports all versions of Microsoft SharePoint that support the SOAP API. This includes: Windows SharePoint Services 3.0, SharePoint Server 2007+ (2010, 2013, etc.), and SharePoint Online.
Schema, Data Model
REST/SOAP. You can view the list of files and folders as modeled tables. The driver also models your SharePoint Lists (custom lists) as bidirectional tables; when you connect, the driver retrieves the metadata for these tables by calling SharePoint Web services. If you want to access the data with files in SharePoint, you will need to use CData Drivers for CSV, Excel, JSON or XML.
Key Objects
Basic managerial objects like Group, Roles, Users in addition to dynamically retrieved SharePoint List tables.
Operations
CRUD operations for SharePoint Lists. Stored Procedures to Up/Download Documents, Attachments, and manage Lists and Folders.
Authentication
AzureAD, AzureServicePrincipalCert, AzurePassword, AzureMSI, PingFederate, ADFS, OneLogin, Okta, SharePointOAuth, NTLM, Basic, OAuth, OAuthJWT, Negotiate, None
Specific feature or properties
To connect with the data in files such as CSV, Excel, JSON, XML or Access, you can use respective file drivers CData provides.
Start a 30-day free trial today
Robust ODBC access to Microsoft SharePoint
Full-featured and consistent SQL access to any supported data source through ODBC
Connect to SharePoint—empower every team
AI-assisted development with CData CLI
Build SharePoint integrations faster with AI that understands your schema
Schema-aware AI
CData CLI gives AI coding tools access to your SharePoint schema. No more guessing table names or column types—AI sees the same metadata in your ODBC Drivers.
Your AI Knows SQL
How to find table names, column names, and how to generate SQL syntax are things that AI knows well from millions of training data. No need for customization, no hallucinations. Your AI acts like a domain specialist to SharePoint.
More Accurate, More Token-Efficient
With CData CLI's queryable schema detection and highly efficient queries with filters, aggregation, joins with correct pushdown, your AI will achieve more accuracy with less token usage.
FAQs
Frequently asked SharePoint ODBC driver questions
Learn more about SharePoint ODBC drivers for data and analytics integration
- Does SharePoint support ODBC?
- Is there an ODBC driver for SharePoint?
- How do I connect to SharePoint via ODBC?
- Where can I download an ODBC driver for SharePoint?
- How do I install an ODBC driver for SharePoint?
- Is the SharePoint ODBC driver 32-bit or 64-bit?
- Does pyODBC work with SharePoint?
- Does the ODBC connector support ARM64 devices?
Download the SharePoint ODBC Driver today!
Get the latest SharePoint ODBC Drivers for Windows, Linux, and macOS. Install in minutes and connect your SharePoint data to Power BI, Tableau, and more.