Access Microsoft OneDrive through SSIS with the SSIS Integration Toolkit for Microsoft OneDrive. With this high-performance, easy-to-use, cost-effective data integration solution built on the SSIS ETL engine, developers can now utilize their cloud storage to store their application data, quickly retrieve or send data to OneDrive and manage their OneDrive flat files.

Note The SSIS Integration Toolkit for Microsoft OneDrive is now part of the SSIS Productivity Pack and is no longer available as a stand-alone product. Please continue reading for information about the OneDrive components available, or see the SSIS Productivity Pack page for information on all SSIS components included within the pack.

The SSIS Integration Toolkit for Microsoft OneDrive

  • Mircosoft OneDrive integration with the freedom, flexibility and power of the SSIS ETL engine.
  • Enables businesses to expand the capacity of their online enterprise application storage at reduced cost.
  • Simplifies integration development to access and take advantage of existing OneDrive storage space.
  • Connects to OneDrive securely using OAuth authentication.
  • Includes 3 bonus SSIS components from the Premium File Pack to work with OneDrive flat files.
  • Including Microsoft Dynamics CRM and ERP, Salesforce, Marketo, SQL Databases and Oracle Databases, you can integrate your OneDrive data or files with virtually any application or database system.
  • Available on its own or as part of a package with our other enterprise data integration solutions in the Ultimate Edition.
OneDrive SSIS Data Integration

Codeless
Integration

You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.

Flexible and
Easy-to-use

We make the most flexible integration solution on the market. Our software offers intuitive user interfaces that are flexible and easy to use.

Cost
Effective

With a streamlined development experience, and an extremely simple licensing model, our solution offers the best value for your investment.

Unparalleled
Performance

Our software offers many specifically designed features that help you achieve the best possible performance without having to hijack your budget.

Why SSIS Integration Toolkit for Microsoft OneDrive?


More application storage at a lower cost


OneDrive file & folder management within SSIS


Streamline data development and management


Unique Features

  • Download OneDrive data based on 5 different item selection modes: SelectedItem, Recursive, Recursive (Files only), Selected Level, and Selected Level (Files only).
  • Upload data to OneDrive based on 3 different write actions: Create, Update, or Delete.
  • Automatically maps fields based on a name match.
  • Refresh Component button to retrieve the latest metadata and update each field to its most recent metadata.
  • Use the OneDrive Token Manager to export tokens from the development machine and then import them in to the integration server.
  • Work with OneDrive flat files as if they are local with the Premium File Pack's Source and Destination components.
  • Manage and transfer files or directories between OneDrive and any other file storage supported by the Premium File Pack using its File Transfer Task.

Technical Requirements

  • Microsoft SQL Server
    • Microsoft SQL Server 2019
    • Microsoft SQL Server 2017
    • Microsoft SQL Server 2016
    • Microsoft SQL Server 2014
    • Microsoft SQL Server 2012
    • Microsoft SQL Server 2008 or 2008 R2

Microsoft OneDrive SSIS Components


The KingswaySoft tool’s UI is very intuitive and you cannot beat the support they provide.

D. Ng

Senior DBA

ASCO