COZYROC vs. HCL DataConnect vs. Informatica Cloud Data Integration

[COZYROC] is a powerful tool and [extends] what you are able to do when it comes to ETL. It allows you to accomplish a lot of things that are very common now, but very difficult to implement with the out of the box functionality of SSIS.

Incentivized

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.

Incentivized

We use it a lot for importing data. We transform the incoming data to match the formatting of our CRM. We also match on existing records to avoid creating duplicates. Informatica handles all of this exceptionally well. Our users are system administrators. The tool is not well-suited for users who do not have a technical background

Incentivized

• Dynamic SOQL is very advantageous with Salesforce source task.
• Connecting to SharePoint is simple and seamless.
• Script Component Plus is also a very good task that we can do a lot through, that what we can't do with Script Task.

Incentivized

• 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.

Incentivized

• Data synchronisation
• Data replication
• Data integration

• Smaller set of useful transform tasks than some competitors
• Upgrade process could be smoother (though similar to others in this space)

Incentivized

• 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.

Incentivized

• There is a moderately steep learning curve
• Has some idiosyncrasies
• Can be finicky with date formats

Incentivized

Easy to use and easy to implement into ETL solutions with Microsoft SQL Server Integration Services.

Incentivized

There is a learning curve with Informatica. It is not always intuitive to use. It is best suited for technical users such as system administrators

Incentivized

Their support is fast and responsive. Their devs work on resolving the issues quickly. We usually will have a release of a fix within a few days.

Incentivized

We tested several other SSIS add-on packages as well. Only a few had DB2 support. And from those few COZYROC's support was the most responsive and helpful. They practically added the functionality we needed if it was not already there.

Incentivized

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.)

Incentivized

It is really easy to comply and understand its features.

• It is my belie that I have thrown away $3.7k

• 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.

Incentivized

• Really greatest than any other conventional application.