Informatica Cloud Data Integration vs. SAP Replication Server

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

I asked questions about a warm standby and multicast replication. We ended up using bi-directional replication and a warm standby db. Having 3 or more live OLTP DB's where each was read-write was going to be difficult to manage for contention if the same table was being updated. We stuck with an easier solution to have only two OLTP's, and then used additional DB's as read-only DW's.

Incentivized

• Data synchronisation
• Data replication
• Data integration

• guaranteed delivery
• high availability
• scalable
• low latency
• data transformation

Incentivized

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

Incentivized

• Data Reconciliation Functionality.

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

SAP support has been outstanding. They have quick response times and always meet their SLAs. Any time we have an issue that needs to be researched they are able to get back to us quickly with resolution.

Incentivized

It is really easy to comply and understand its features.

Hands down Sybase has the best replication

Incentivized

• Really greatest than any other conventional application.

• A positive is that it allow quick business decision making on the basis of real time data. Huge time saving for business.

Incentivized