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 If you’re bringing anything into Salesforce you should just invest now into Mule, you will get your money’s worth and find a myriad of uses to build APIs between many other systems. Once you build a component you can easily reuse it as a building block to attach to another source/destination. This makes it easy to ramp up quickly and spread usage of Mule throughout your enterprise. A good value for medium to large companies, but probably cheaper to outsource your job to a consulting firm if you are smaller.
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 It is best suited for Rest API development. Mule ESB uses RAML as an API descriptor which is less complex and easy to understand. RAML is an open standard majorly supported by Mulesoft. Once RAML is developed, it is very easy (a few clicks)to create flows corresponding to the resources defined in the RAML. One can also include JSON schema validation in RAML, and with the use of APIkit router, Mule ESB makes the request validation very easy (it's automatic basically.) Mule ESB comes with a large spectrum of community and enterprise connectors. We have connectors for all the major platforms like Facebook, Twitter, Salesforce, SAP, etc. This enables Mule ESB to integrate with the other systems in a faster and more robust way. Mule ESB has many components to fulfill the requirements of each integration (for example batch processing, parallel processing, choice, etc.) Mule API gateway is one of the best tools (modules) of Mulesoft's offering. It supports API governance and management very well. One can easily enforce policies on their APIs with API gateway. It enables some of the must-have features in an API solution (i.e. throttling, oAuth, access levels, etc.) Implementing a CI/CD (DevOps) environment for Mule ESB is a very easy task. Mule majorly uses MAVEN as its build tool, which in turn makes it best suitable for CI/CD approach. Mule also provides MAVEN plugins for auto deployments to the servers. Mule also has a best Unit testing module which is MUnit. MUnit can be used for both Unit and Functional testing, and it is easy to write and generates coverage reports in various formats. 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 Make sure to not over-engineer shared components. It can complicate development Create a roadmap for where you are going - if not, you may miss components I suggest getting support, otherwise it could be a difficult learning curve 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 It doesn't have API . We have to go for another API manager. But in Mule, it has both API manager and ESB
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 Overall a great tool for complex integrations Read full review ScreenShots HCL DataConnect Screenshots