Powerful data integration for SharePoint is possible with the SSIS Integration Toolkit for Microsoft SharePoint.

With this high-performance, easy-to-use, cost-effective data integration solution built on the SSIS ETL engine, developers can use the skill set they already know to quickly build effective SSIS data integration packages for SharePoint and any other application or database system.


  • Take advantage of the freedom, flexibility, and power of the SSIS ETL engine to facilitate Microsoft SharePoint data integration.
  • Performant and easy-to-use SSIS components to quickly connect, read and write to Microsoft SharePoint Online or On-Premises.
  • Option to retrieve data from SharePoint using CAML query filters built in the Query Designer.
  • Upload and download documents with ease.
  • Support for easy writing of various special SharePoint fields including taxonomy, lookup, and many other fields. 
  • Support working with SharePoint document set.
  • Manage your SharePoint flat files with 3 bonus SSIS components included with the toolkit.
  • Support both SOAP and REST APIs
  • Support SharePoint modern authentication via OAuth connections.
  • Support for multi-threaded writing.
  • The text lookup feature makes lookup painlessly easy.
  • Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, SHA-256, etc.
  • Integrate your SharePoint data with virtually any application or database system including Microsoft Dynamics 365, Salesforce, Marketo, SQL Databases, and Oracle Databases.
  • Available on its own or as part of a package with our other enterprise data integration solutions in our Ultimate Edition.
Microsoft Dynamics 365 Data Integration
Microsoft SharePoint

SSIS Integration Toolkit for
Microsoft SharePoint

The most comprehensive and robust data integration solution for SharePoint

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

D. Ng

Senior DBA

ASCO

Unique Features

  • Write to SharePoint lists and document libraries using 7 different write actions: Create, Update, Delete, CreateFolder, CheckIn, CheckOut, and Moderate.
  • Support for downloading and uploading attachments in SharePoint list items.
  • Support for multithreaded writing using one single configuration.
  • Query Designer allows you to design CAML Query directly within the SharePoint Source Component.
  • Manage SharePoint flat files with SSIS Productivity Pack's Premium Flat File Source, Destination and File Transfer, Task components included.

Technical Requirements

  • Microsoft SharePoint, either,
    • Microsoft SharePoint Online (Office 365),
    • Microsoft SharePoint 2019,
    • Microsoft SharePoint 2016,
    • Microsoft SharePoint 2013,
    • Microsoft SharePoint 2010, or,
    • Microsoft SharePoint 2007.
  • SQL Server Integration Service, either:
    • Azure Data Factory,
    • Microsoft SQL Server 2022,
    • Microsoft SQL Server 2019,
    • Microsoft SQL Server 2017,
    • Microsoft SQL Server 2016,
    • Microsoft SQL Server 2014,
    • Microsoft SQL Server 2012,
    • Microsoft SQL Server 2008 R2, or,
    • Microsoft SQL Server 2008.

Microsoft SharePoint SSIS Components


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.