SSIS Integration Toolkit

Overview

Our SSIS Integration Toolkit is a comprehensive collection of premium SSIS components designed to extend Microsoft SQL Server Integration Services (SSIS) with enterprise-grade connectivity, advanced data processing, and productivity features.

The toolkit includes over 300 high-performance SSIS connectors and productivity components that allow seamless integration of SQL Server with cloud applications, databases, data warehouses, big data platforms, messaging systems, file formats, and web services, all without the need for custom code.

Key Features

• Extensive connectivity for cloud, on-premises, and hybrid systems.
• Advanced source, destination, transformation, task, and connection manager components.
• High-performance data processing designed for enterprise workloads.
• Eliminate the need for custom scripting for many complex SSIS integration scenarios.
• Regular new features, new connectors, platform enhancements, and performance improvements.
• Comprehensive Connectivity

The SSIS Integration Toolkit includes integration solutions across a wide range of technologies and platforms, including:

• Business Applications (CRM, ERP, HR, Marketing, Finance, Commerce, Customer Service, Collaboration, Project Management, and more)
• Cloud Storage
• Data Warehouses
• Databases
• Big Data Platforms
• REST APIs
• Microsoft Graph
• Message Queues
• NoSQL Databases
• File Systems
• JSON, XML, EDI, HL7, Parquet, Avro, ORC, and other file formats
• Data Quality and Data Transformation components
• Encryption, Compression, Security, and Automation tasks

For the complete and always up-to-date list of supported connectivity solutions, visit our SSIS Integration Toolkit Product Page

Licensing

We offer three licensing levels: Free Developer's License, Trial License, and a Commercial Subscription License.

1. 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).
2. 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.
3. Commercial Subscription License: A commercial license is required when executing unattended jobs (SQL Agent Job, dtexec command line, etc.). Various subscription terms are available.

Over 300+ Components

Our SSIS Integration Toolkit includes the below components:

Learn More About These Components

• Major Enterprise Platforms: Dynamics 365 (CRM/AX/NAV/CDS) | Directory Services | HubSpot | Marketo | Microsoft Dynamics GP | Microsoft Dynamics SL | Microsoft Project Server | Microsoft SharePoint | NetSuite | Oracle CRM On Demand | Oracle Marketing Cloud | QuickBooks | Salesforce | SAP | Team Foundation Server
• Big Data: Avro | CDM | EDI Source & Destination | HL7 | Hadoop | HDFS | ORC | Parquet | Power BI | Premium Data File | Tableau Hyper
• Cloud Storage: Amazon S3 | Azure Blob Storage | Azure Data Lake | Azure Data Files | Box | Dropbox | Google Cloud Storage | Google Drive | OneDrive | OneLake
• Conversion: Composition | Decomposition | Value Mapping
• Data Generation & Anonymization: Data Anonymizer | Data Spawner
• Data Quality & Comparison: Address Parser | Address Verification | Data Profiler | Diff Detector | Duplicate Detector
• Data Warehousing: Databricks | PrestoDB | Amazon Redshift | Google BigQuery | PostgreSQL | Premium Slowly Changing Dimension | Snowflake
• Encryption & Compression: Compression Task | PGP Encryption Task | Premium Hash
• Google Services: Google Ads | Google AlloyDB | Google Analytics | Google BigQuery | Google Calendar | Google Classroom | Google CloudSQL | Google Cloud Storage | Google Cloud Monitoring | Google Dataplex | Google Drive | Google Forms | Google Maps | Google People | Google Search Console | Google Sheets | Google Tag Manager | YouTube Analytics
• HTTP/Web Service: AS2 | GraphQL | HTTP | Microsoft Graph | monday.com | Web Service
• JSON/XML Processing: JSON | XML | HTML Table Source
• Mail Components: Email | SMTP
• Marketing Intelligence: Bing Ads | Google Ads | Google Analytics | Marketing Advertising | YouTube Analytics
• Message Queue: ActiveMQ | AMQP | Amazon SQS | Azure Service Bus | Azure Queue Storage | IBM MQ/WebSphere MQ | Kafka | MQTT | MSMQ | Premium Message Queue Task | RabbitMQ | SMPP
• NoSQL: Amazon DynamoDB | Apache Cassandra | Azure Table | CosmosDB | Couchbase | Elasticsearch | Firestore | HBase | MongoDB | Redis
• Premium Data Flow: Premium ADO.NET | Premium Derived Column | Premium Aggregate | Premium Excel | Premium Lookup | Premium Conversion | Premium OData | Premium PDF Table Source | Premium Service Lookup | Premium SQL Server | Premium Slowly Changing Dimension
• Premium File Pack: Premium Flat File | Premium File System | FTPS Connection Manager | SFTP Connection Manager | WebDAV
• Premium Task: Premium Expression | Premium File Properties Task | Premium File Watcher Task
• REST Connections: Act-On | ActiveCampaign | Acumatica | ADP | Asana | Azure App Insights | Azure Maps | Azure Databricks Administration | Basecamp | BigCommerce | Bill.com | Calendly | Ceridian Dayforce | Chargebee | Chargify | ClickUp | Copper | Constant Contact | Crelate | Discord | DocuSign | Drift | Ebay | Elasticsearch | Enthuse | Eventbrite | Extensiv | Expensify | Facebook Business | Facebook Messenger | Freshdesk | FreshBooks | Freshdesk | GitHub | GoToWebinar | Google AppSheet | Google Cloud Trace | GetResponse | Intercom | Keap (Infusionsoft) | Klaviyo) | Insightly | Jira | LinkedIn Business | MailChimp | Mailgun | Mailjet | Microsoft Dynamics 365 Customer Insights | Microsoft Planner | Microsoft Teams | Microsoft To Do | MYOB | Odoo | Okta | OpenAI | PayPal | Pipedrive | Power BI | PrestaShop | Qualtrics | Quickbase | Replicon | Sage Business Cloud Accounting | Salesforce Pardot | SendGrid | Sendinblue | SendPulse | ServiceNow | ShipStation | Shopify | Slack | Smartsheet | SnapChat Business | Square | Stripe | SugarCRM | SuiteCRM | SurveyMonkey | Teamwork | Temu | TikTok Business | Trello | Twilio | Twitter Business | Webex | WeChat | WordPress | WooCommerce | Wrike | Xero Accounting | Yammer | YouTube Analytics | Zendesk | Zoho Bigin | Zoho CRM | Zoho Books | Zoho Campaigns | Zoho Desk | Zoom | Zuora
• Security Management: AWS Secrets Manager | Azure Key Vault
• Template Merge: HTML Merge | Text Merge
• Timing & Automation: Azure Functions | SSH Task | Timer Task | Time Zone Conversion | Windows Command Task