KingswaySoft's SSIS Integration Toolkit takes advantage of the flexibility and power of the Microsoft SQL Server Integration Services (SSIS) platform, which makes it possible to integrate with Salesforce and virtually any application or data source that you may need to work with.
SSIS Integration Toolkit for Salesforce is extremely easy to use. It comes with the following three major components to help facilitate integration development.
Salesforce Connection Manager
- Manages the connection for your Salesforce.com organization.
Salesforce Source Component
- Allows you to read data from your Salesforce.com organization.
- Option to use either Salesforce object or SOQL query when retrieving Salesforce records.
- Support for retrieving deleted and archived records.
Salesforce Destination Component
- Allows you to write data to your Salesforce.com organization.
- Support for Create/Update/Delete/Upsert/Merge/HardDelete/Undelete actions in Salesforce Destination component.
- Support for Text Lookup feature to perform a lookup based on a provided text or integer value for any specified text field in the lookup object.
Salesforce Command Task Component
- The Salesforce Command Task is an SSIS control flow component that executes Apex code directly against your Salesforce environment as part of your integration workflows.
Salesforce Marketing Cloud Connection Manager
- The Salesforce Marketing Cloud Connection Manager enables you to configure and manage secure connections to your Salesforce Marketing Cloud environment.
Salesforce Marketing Cloud Source Component
- The Salesforce Marketing Cloud Source Component is an SSIS data flow component that retrieves data from your Salesforce Marketing Cloud instance for use in ETL and integration workflows.
Salesforce Marketing Cloud Destination Component
- The Salesforce Marketing Cloud Destination Component is an SSIS data flow component that writes data to your Salesforce Marketing Cloud instance. It supports creating, updating, deleting, and upserting Salesforce Marketing Cloud records.
Salesforce Einstein (Wave/Tableau CRM) Analytics Destination Component
- Write to Salesforce Wave Analytics using Append, Delete, Overwrite and Upsert operations.
The ultimate goal of our toolkit is to simplify your integration development work, a data migration/integration development project can be done as quickly as a few minutes, instead of weeks or months when you use our Salesforce integration tool.
For more information, visit our Salesforce SSIS Components page
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.
| |
