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
  • fill

    Codeless Integration

    You do not have to write a single line of code
    to make data integration happen; your development
    can be done in a matter of minutes, which would
    otherwise take weeks or even months

    Unparalleled Performance

    Our software offers many specifically designed
    features that help you achieve the best possible
    data integration performance, while rescuing your
    IT budget

    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 a simplified licensing model, our solution
    offers the best value for your investment

  • fill

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

    D.Ng Senior DBA, ASCO

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.

Microsoft OneDrive SSIS Components

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