Introducing the COZYROC SSIS+ library with support for integration and migration of Microsoft SharePoint data. The SharePoint SSIS components are third-party plug-ins for Microsoft SSIS. Available on the market since 2010, COZYROC makes it easy to integrate or migrate data to and from SharePoint lists using SharePoint 2007, 2010, 2013 and Office 365. Uploading and downloading attachments that are associated with list items is also supported.
We will preserve the integrity of your data by always using the recommended Microsoft web services API. You can use any application, service or database supported by SQL Server Integration Services (SSIS) or Cozyroc’s toolkit as the source or destination for SharePoint data.
The toolkit is easy to use and follows the same guidelines and principles used by the standard out-of-the-box SSIS components. In addition, COZYROC also provides short and informative demonstration videos, providing step-by-step instructions on how to get started.
The SharePoint integration package consists of three main parts:
SharePoint Connection Manager - Stores the credentials and functionality for connecting to an on-premise SharePoint server or online SharePoint service (Office 365).
SharePoint Source component - Retrieves data from a SharePoint list.
SharePoint Destination component - Inserts or updates data in a SharePoint list.
**Folders and lists on the SharePoint server/service may be managed using the COZYROC File Transfer Task: **
The COZYROC SSIS+ library also includes the powerful and elegant Data Flow Task Plus, not found in any other competitive product on the market. Data Flow Task Plus allows creation of dynamic data flows at runtime and can be used with COZYROC's SharePoint adapters.
You can create processes where the addition or deletion of SharePoint fields doesn't necessitate modification of existing SSIS packages. This powerful feature requires no programming skills to use and greatly simplifies your maintenance efforts.
Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017
Get in touch with us: