Likelihood to Recommend The choice to use Actian DataConnect really comes down to pricing and the type of integration project you are performing, specifically with the requirements, whether you want the integration to be on-premise or in the cloud, can you install agents on your servers etc. For integration tools it runs head to head with its competitors.
David Byrd Sr Integration Engineer - Dual Certified in Dell Boomi Developer 1 & 2, and Actian DataConnect
Read full review This is a great tool for bringing data out of your locked, internal systems and getting it into the cloud. It meshes well with Salesforce and is fairly easy to use, helping the transition from other older, more complex tools into a more modern environment. It has lots of competition in this space and some are better than others, but if your data is straight forward and you know it well, Jitterbit will get the job done. If you are not as close or comfortable with your data and need to do some wildly complex migrations, there might be better packages out there for you.
Read full review Pros Map multiple source and destination tables - what would be done in many steps in SSIS can be done in one or two "maps" in Data Integrator. Platform independent, cloud based, no client software. Conversion of data types, write flat files - this helps us with integrating systems. Fairly straightforward to use if the user has ETL experience. Read full review UI is super easy to understand with a low learning curve so admins can figure it out and maintain it without breaking anything. It's FREE! There's a paid version too but I like that you can use most of the features for free and they're not pushy with buying. There's a great user community that you can google and ask any questions. Most problems I've encountered have been posted and answered already. Read full review Cons Integration Manager needs better scheduling improvements. Like dependencies, and not running a process again if the prior run is still running. New connector development does not seem a priority. David Byrd Sr Integration Engineer - Dual Certified in Dell Boomi Developer 1 & 2, and Actian DataConnect
Read full review Migrating operations from QA to Production work well for initial deployment, however, when migrating an update to an existing job to production, sometimes certain project items are duplicated. This is not the end of the world... the duplicates can be removed, but would be nice if it was not required. I have not found a way to trap under-the-covers SOAP errors (for example, when a query you are running against Salesforce takes too long). You get a warning error in the operation log that the job only pulled a "partial" file, but it does not fail. Read full review Likelihood to Renew I have been evaluating other tools as a continuous improvement practice. I would like something that would be easier to use for a non-technical user. I work for a small organization and have no back-up for Jitterbit if something happens to me. We don't have the technically savvy employees to understand it.
Read full review Support Rating They have some of the best support of any software vendor that we use. They always get our issues resolved quickly
Travis Terry Performance Testing Engineer / Front End Developer /System Analyst
Read full review Alternatives Considered Data Integrator was initially a part of a package deal for us with our new Student Information System. It was chosen prior to my arrival at the institution. Since I discovered we have SQL Server licenses, we have decided to use
SSIS instead since I have a background in the MSBI stack and
SSIS appears to be more straightforward (process flow philosophy vs "map" philosophy.)
Read full review Evaluated
Dell Boomi and Celigo as alternatives prior to purchasing Jitterbit. We went with Jitterbit at that time because we could handle all changes ourselves without any assistance from Jitterbit, and we liked their size and nimbleness.
Dell Boomi was too big for us, and Celigo at that time did not have a self-service model. Every change had to go through them (although that has since changed). We were not in a position to be able to wait for someone to make changes for us given the rate of change within the business.
Read full review Return on Investment Our customer likes the consistent reliable integrations we have built so we [got] a definite return on investment. Problems are fairly easy to handle and rework. David Byrd Sr Integration Engineer - Dual Certified in Dell Boomi Developer 1 & 2, and Actian DataConnect
Read full review The time it takes to connect systems has reduced by orders of magnitude. Previously, we would custom-develop connectors between various systems and they would all be managed by different vendors. With Jitterbit speed-to-deploy and the efficiency gained by managing all connections in one dashboard has been the greatest piece of the ROI. Read full review ScreenShots HCL DataConnect Screenshots