SSIS Integration Toolkit for Microsoft SharePoint

Robust SSIS components for managing SharePoint data and flat files

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.

Data Integration for Microsoft SharePoint made easy

Read and write to Microsoft SharePoint Lists, Document Libraries, and files without code using SQL Server Integration Services

  • 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 easy.
  • Support for various special SharePoint fields including taxonomy, and many other fields. 
  • Manage your SharePoint flat files with 3 bonus SSIS components included with the toolkit.
  • Support for SharePoint modern authentication.
  • Support for multi-threaded writing.
  • 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.
  • fill

    SSIS Integration Toolkit for
    Microsoft SharePoint

    The most comprehensive and robust data integration
    solution for SharePoint

  • 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
  • fill
    Support for
    Downloading

    and
    Uploading



    Attachments

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 of 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.

SharePoint SSIS Components

Microsoft SharePoint Connection Manager

Microsoft SharePoint SSIS Connection Manager

The SharePoint Connection Manager facilitates connection to Microsoft SharePoint web services.

Microsoft SharePoint Source Component

Microsoft SharePoint SSIS Source Component

Allows you to read data from Microsoft SharePoint lists and document libraries via web services.

Microsoft SharePoint Destination Component

Microsoft SharePoint SSIS Destination Component

Facilitates writing data to Microsoft SharePoint via web services using Create, Update, Delete or CreateFolder.

Premium Flat File Source Component

SSIS Integration Toolkit. Premium File Pack for SharePoint - Premium Flat File Source Component

The Premium Flat File Source Component allows you to read data from a flat file in SharePoint.

Premium Flat File Destination Component

SSIS Integration Toolkit. Premium File Pack for SharePoint - Premium Flat File Destination Component

The Premium Flat File Destination Component allows you to select a file to be written into in SharePoint.

Premium File Transfer Task Component

SSIS Integration Toolkit. Premium File Pack for SharePoint - Premium File Transfer Task Component

Transfer and perform basic file system tasks: Send Files Delete Files, Create Directory, or Remove Directory.

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 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.