Enthuse
Data Integration
via SSIS Integration Toolkit
Integrate and migrate data to and from Enthuse with any other application or data source including Microsoft Dynamics 365, NetSuite, Magento, and Salesforce, to name just a few.
What other applications can you sync with Enthuse?
Click here for more solutions.
When it comes to fundraising, donor management, events, and supporter engagement, having the most up-to-date information in your systems is imperative. Keep your Enthuse data synchronized with your CRM, finance, or reporting solutions to better manage donations, fundraising campaigns, and supporter relationships.
Synchronize Data
Easily sync Enthuse with your CRM, marketing automation, finance, or any other application so donor, fundraising, event, and payment data is always up-to-date.
Automate Business Processes
As a fundraising and donations platform, Enthuse data can be integrated with other applications to streamline processes such as donor nurturing campaigns, supporter engagement workflows, event management, and CRM automation.
Replicate Data
Data Archival
Easily replicate data from Enthuse for data archival and warehousing requirements.
Data Analytics
Easily retrieve donor, fundraising, event, and payment data from Enthuse so it is available for your preferred BI and analytics platform.
Enthuse Data Integration is available
in the SSIS Integration Toolkit
Unique Features
- A simplified and secure connection manager with OAuth authentication using a JSON key file.
- Supports configurable OAuth scopes, including organization, fundraising, partner, and personally identifiable information (PII) access permissions.
- Retrieve data from available Enthuse objects and endpoints with configurable filter parameters and batch sizes where supported.
- Write data to Enthuse through supported API actions, including parent-child object support using the built-in _LinkId mechanism.
Enthuse Data Integration Made Easy
Our solution is easy to use, offering code-less integration between Enthuse and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.
Our Enthuse integration solution is available within the REST Components and SSIS Integration Toolkit, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Enthuse with applications such as Microsoft Dynamics 365, Salesforce, NetSuite, and many more.
See our full product offerings for more information.
More SSIS CRM Components
Our CRM components make it easy to integrate with different services within the ETL process. Each service available has specific components that have been developed to work with all the intricacies of that particular CRM solution. In addition to Enthuse, we support the following CRM services:
Blackbaud
Copper
Emarsys
Insightly
Freshsales
Dynamics 365 CE/CRM
Oracle CRM On Demand
Pipedrive
Salesforce
SugarCRM
SuiteCRM
Zoho Bigin
Zoho CRM
FAQ
The Enthuse REST integration solution for SSIS uses the REST Connection Manager together with the Enthuse REST Source and Enthuse REST Destination components to facilitate data integration, migration, and synchronization between Enthuse and other applications, databases, and cloud services through SQL Server Integration Services (SSIS).
Connection to Enthuse is established through the REST Connection Manager. Users can select the Production or Development environment, configure the Organization ID, Client ID, required scopes, JSON key file, API throttling settings, and verify connectivity using the built-in Test Connection feature.
The Enthuse REST Source component can retrieve data from available Enthuse objects and endpoints. It supports configurable batch sizes where available, field selection, UTC or Local datetime handling, filter parameters, metadata refresh capabilities, and additional field extraction from returned JSON structures.
Yes. The Enthuse REST Destination component allows SSIS packages to write data to Enthuse objects through supported API actions. Users can configure destination objects, select available actions, map incoming columns to Enthuse fields, and dynamically update settings through SSIS expressions.
The Enthuse REST Source component supports filter parameters for targeted data retrieval and configurable batch sizes where supported by the selected endpoint. For optimal performance, it is recommended to select only the fields required by downstream SSIS components.
Yes. The destination component supports multi-input processing for parent-child data structures. Child records can be linked to parent records using the built-in _LinkId mechanism, allowing related objects to be created and processed together within a single SSIS data flow.
The Enthuse REST Destination component provides three error handling options: Fail on error, Redirect rows to error output, and Ignore error. When rows are redirected, detailed diagnostic information such as error codes, error messages, and column-level details can be captured for troubleshooting and auditing purposes.
Yes. The component provides HTTP diagnostic output columns that expose request URLs, HTTP methods, headers, request bodies, response codes, response headers, and response bodies. This information can be used in downstream SSIS components for monitoring, logging, and troubleshooting integration processes.
The REST Connection Manager supports proxy configuration, connection timeouts, custom HTTP headers, API throttling, retry logic for intermittent errors, SSL certificate validation controls, and configurable OAuth scopes using a JSON key file for authentication. For production environments, SSL certificate validation should generally remain enabled unless there is a specific trusted internal-network requirement.
Get In Touch
If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!
Contact Us