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.

The SSIS Integration Toolkit for Microsoft SharePoint

  • 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 with ease.
  • Support reading and writing flat files (CSV files) in your SharePoint document libraries using the 3 bonus SSIS components included.
  • Support both SOAP and REST APIs
  • Support SharePoint modern authentication via OAuth connections.
  • Support for multi-threaded writing in the SharePoint destination component to facilitate high throughput 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 multi-threaded writing using one single configuration.
  • Query Designer allows you to design CAML Query directly within the SharePoint Source Component.
  • Support in-place lookup in the SharePoint destination component using the text lookup feature that comes with many advanced features.
  • Write to taxonomy fields by providing the taxonomy label values with easy in SharePoint destination component.
  • Manage SharePoint flat files with SSIS Productivity Pack's Premium Flat File Source, Destination and File Transfer Task, File Properties 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 Connection Manager

SharePoint Connection Manager

  • The SharePoint Connection Manager facilitates connection to Microsoft SharePoint web services.
  • Provides various authentication modes, including Windows Authentication and Username/Password, offering flexibility in connecting to SharePoint.
  • Supports connections to SharePoint on-premises and SharePoint Online (Office 365), enabling seamless integration with different SharePoint deployments.
  •  See this component's documentation.

SharePoint Source Component

  • Allows you to read data from Microsoft SharePoint lists and document libraries in SSIS packages via web services.
  • Supports custom queries and filters, allowing users to extract specific SharePoint data based on their requirements.
  • Offers support for diverse SharePoint data types, including documents, list items, attachments, and metadata.
  •  See this component's documentation.

Microsoft SharePoint SSIS Source Component

Microsoft SharePoint SSIS Destination Component

SharePoint Destination Component

  • Facilitates writing data to Microsoft SharePoint via web services using Create, Update, Delete or CreateFolder.
  • Supports bulk data insertion with comprehensive mapping capabilities, optimizing the upload process for large datasets to SharePoint and reducing processing time.
  • Enables incremental data loading, tracking changes since the last extraction for efficient data synchronization.
  •  See this component's documentation.

Premium Flat File
Source Component

  • The Premium Flat File Source Component allows you to read data from a flat file in SharePoint.
  • Offers comprehensive support for various flat file formats, including CSV, TXT, and other delimited or fixed-width formats, enabling versatile data extraction capabilities.
  • Ensures optimized data retrieval performance, resulting in faster data loading and improved overall efficiency of SSIS packages.
  •   See this component's documentation.

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

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

Premium Flat File
Destination Component

  • The Premium Flat File Destination Component allows you to choose a file in SharePoint where the data will be written.
  • Supports custom data parsing and handling options for accurate flat file data processing, including specific column delimiters and data types.
  • Offers flexible column mapping options, allowing users to align SSIS data with specific columns in the flat file for accurate data insertion.
  •   See this component's documentation.

Premium File Transfer
Task Component

  • Transfer and perform basic file system tasks: Send Files Delete Files, Create Directory, or Remove Directory.
  • Offers various secure file transfer protocols, such as FTP, SFTP, FTPS, and HTTP, ensuring data privacy during file transfers.
  • Enables scheduling and automation of file transfer tasks, allowing users to set up recurring transfers or execute them based on specific triggers and intervals.
  •   See this component's documentation.

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

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.