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
Synchronize Enthuse with CRM, database, warehouse, reporting, and operational systems so fundraising-related data remains current across applications. Retrieve data from available source objects and endpoints, apply filter parameters, configure batch size, and select additional returned fields where supported.
Support Enthuse Data Workflows
Write data to Enthuse using supported destination objects and actions. Map upstream SSIS fields to Enthuse REST fields, configure input timezone settings, and refresh component metadata when objects, actions, or fields change.
Replicate Data
Data Archival
Retrieve Enthuse data into SSIS for archival, reporting, and downstream processing. Use source objects, endpoints, filter parameters, batch size, and selected fields to manage extraction.
Data Analytics
Prepare Enthuse data for BI and analytics across reporting platforms. Use SSIS workflows to move retrieved fundraising and organizational data into databases, warehouses, and other reporting destinations.
Enthuse Data Integration is available
in the SSIS Integration Toolkit
Key Features
- Connect to Production or Development Enthuse environments.
- Authenticate using Organization ID, Client ID, and a JSON key file containing a private key in JWK format.
- Select OAuth scopes based on the read, write, partner, and personally identifiable information permissions required.
- Control API usage with configurable API throttling, including the option to disable throttling when needed.
- Apply filter parameters, batch size, output timezone, and selected field settings when retrieving data.
- Write to Enthuse using supported destination objects and actions.
- Use child inputs and Link ID fields when writing hierarchical REST data structures.
- Use error outputs, the _EnthuseId output field, and HTTP diagnostics output columns to review and troubleshoot write operations.
Enthuse Data Integration Made Easy
Our solution is easy to use, offering codeless integration between Enthuse and other applications, databases, and business systems. Built for Microsoft SQL Server Integration Services, KingswaySoft's Enthuse integration solution helps teams retrieve and write Enthuse data through REST Source and Destination components. With support for Production and Development environments, scope-based authentication, JSON key files, API throttling, filtering, metadata refresh, error redirection, and HTTP diagnostics, users can build Enthuse integrations with greater control and visibility.
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