Likelihood to Recommend Message brokering across different systems, with transactionality and the ability to have fine tuned control over what happens using Java (or other languages), instead of a heavy, proprietary languages. One situation that it doesn't fit very well (as far as I have experienced) is when your workflow requires significant data mapping. While possible when using Java tooling, some other visual data mapping tools in other integration frameworks are easier to work with.
Read full review 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 Pros Camel has an easy learning curve. It is fairly well documented and there are about 5-6 books on Camel. There is a large user group and blogs devoted to all things Camel and the developers of Camel provide quick answers and have also been very quick to patch Camel, when bugs are reported. Camel integrates well with well known frameworks like Spring, and other middleware products like Apache Karaf and Servicemix. There are over 150 components for the Camel framework that help integrate with diverse software platforms. Camel is also good for creating microservices. Read full review 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 Cons didn't work well when our developers tried to transform heavy data sets Apache Camel's whole logic is based on java so team needs to have a great skill set in java if there are a handful of workflows then Apache Camel's full potential can't be realized Read full review 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 Alternatives Considered If you are looking for a Java-based open source low cost equivalent to webMethods or
Azure Logic Apps , Apache Camel is an excellent choice as it is mature and widely deployed, and included in many vendored Java application servers too such as Redhat JBoss EAP. Apache Camel is lacking on the GUI tooling side compared to commercial products such as webMethods or
Azure Logic Apps .
Read full review 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 Return on Investment Very fast time to market in that so many components are available to use immediately. Error handling mechanisms and patterns of practice are robust and easy to use which in turn has made our application more robust from the start, so fewer bugs. However, testing and debugging routes is more challenging than working is standard Java so that takes more time (less time than writing the components from scratch). Most people don't know Camel coming in and many junior developers find it overwhelming and are not enthusiastic to learn it. So finding people that want to develop/maintain it is a challenge. Read full review 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 ScreenShots HCL DataConnect Screenshots