OneDrive ODBC & JDBC Driver

Easily report on account-wide OneDrive user and usage information through your business intelligence tool of choice with direct, real-time access to your OneDrive data.

Current Versions Gateway (ODBC & JDBC) 1.0.0

OEM & Distribution
  • DB Visualizer
  • Excel
  • Looker
  • Microstrategy
  • Other
  • Other JDBC
  • Other ODBC
  • PowerBI
  • SAP
  • Sisense
  • Tableau

Imagine having access to your OneDrive user and usage data from Power BI or any other BI/Analytics tool you rely on?

With our Magnitude Simba OneDrive Connector on Simba Gateway, you’re only steps away from Direct BI connectivity to OneDrive data – users, usage, Notebooks, Sections, Pages and more - without extraction.

The Simba OneDrive Connector enables streamlined analytics and reporting on OneDrive data. Complying with both the most current ODBC and JDBC data standards, the connector simplifies the process of connecting to data sources by enabling you to use the same connection across both types of applications. On Windows and macOS, the connector is supported by two additional applications:

  • The Simba Gateway Settings application provides an intuitive user interface designed to simplify the process of configuring connectors and defining connections.
  • The Connection Assistant application further simplifies the connection process by conveniently providing ODBC connection strings and JDBC connection URLs for all connections that were configured through Simba Gateway Settings.

OneDrive stores data in structures which do not follow the rules of data typing and structure that apply to traditional relational tables and columns. Because traditional ODBC and JDBC toolsets might not support these data structures, the data needs to be mapped to a relational form. To achieve this, the Magnitude Simba OneDrive Connector uses schema tables to map the OneDrive data to formats that are compatible with ODBC and JDBC.

Either specify the standards version for both ODBC and JDBC or don't specify it for either. Probably the latter as it gets specified under features below.

Features and Specifications

  • Supports 32- and 64-bit applications
  • Supports OAuth2 authentication
  • Supports TLS 1.1/1.2
  • Uses OpenSSL 1.1.1.
  • Supports Unicode
  • Supports multiple platforms, including Windows, Linux and Mac OS X
  • Supports ANSI SQL-92
  • Support for ODBC 3.8
  • Support for JDBC 4.2

Documentation

User Guides, Release Notes, and FAQs.

Ready to buy? We're here to help!

If you are evaluating our drivers or our Simba SDK, our Sales Engineers would be happy to assist you.