KingswaySoft's SSIS Integration Toolkit facilitates reading/writing data to/from Microsoft SharePoint Lists and Document Libraries via web services, including any hidden lists and fields. Our Microsoft SharePoint SSIS Components allow you to quickly create simple to complex integration or migration jobs. Among many other features, below is a quick highlight of some key features offered by the toolkit:
- Support for Microsoft SharePoint 2019, 2016, 2013, 2010, 2007, Office 365.
- Support for Create/Update/Delete/CreateFolder/CheckIn/CheckOut/Moderate actions in SharePoint lists and document libraries.
- Support for downloading and uploading of attachments in SharePoint list items.
SSIS Integration Toolkit is extremely easy to use. It comes with the following major components to help facilitate your data integration development with SharePoint:
- SharePoint Connection Manager
- Facilitates connection to Microsoft SharePoint web services.
- SharePoint Source Component
- Allows you to read data from Microsoft SharePoint lists and document libraries via web services.
- SharePoint Destination Component
- Facilitates writing data to Microsoft SharePoint via web services, using different actions: Create, Update, Delete, CreateFolder, CheckIn, CheckOut and Moderate.
- Premium Flat File Source Component*
- Read/download data from a flat file stored in SharePoint or locally.
- Premium Flat File Destination Component*
- Wwrite data to a SharePoint or local flat file.
- Premium File Transfer Task*
- Transfer and perform basic file system tasks with local or SharePoint files.
By utilizing Microsoft SSIS as your data integration platform you can simplify your SharePoint integration development process. With our data integration tools, integration development is fast and easy to set up. And with a high-performing scheduling engine, your on-going integration does not have to take up valuable time.
*These components are included within our SSIS Integration Toolkit at no additional cost. Downloading the SSIS Integration Toolkit will enable greater functionality for these components by supporting additional cloud storage applications as well as FTPS and SFTP connection managers.
Licensing
We offer three licensing levels: Free Developer's License, Trial License, and a Commercial Subscription License.
- Free Developer's License: After installation, the toolkit defaults to a Free Developer License. This allows for unlimited use within a development environment (Visual Studio or SSDT) for design and testing purposes, provided you are running a development workstation operating system. Please note that a commercial license is required if the software is installed on a Server Operating System, even when used exclusively within Visual Studio. Additionally, a paid license is required to run packages outside the development environment (e.g., via command line, SQL Agent, or scheduled tasks).
- Trial License: If you want to evaluate whether the software functions properly outside of the development tools (SSDT-BI, BIDS, or Visual Studio), you can acquire a trial license using the License Manager program which is installed along with the software. To request a Trial License, please open the License Manager program (on your new server) and select “Change License Key”. You can leave the license field empty in this case. Once the other fields are completed, the “Request a Trial License” button will be enabled for your activation. After you have acquired a trial license, you will be able to run SSIS packages on a scheduled basis, or from any other Windows process such as command line. The trial software will operate fully-functional for the trial period, which is generally 14 days. When the trial period expires, the software will revert to the free developer license.
- Commercial Subscription License: A commercial license is required when executing unattended jobs (SQL Agent Job, dtexec command line, etc.). Various subscription terms are available.
| |
