RepreZen API Studio vs. SharePlex

RepreZen API Studio is well suited for running on two operating systems and the nice UIs are good. But better appearance could improve the UX.

SharePlex is best suited for replicating relatively small but steady streams of data, instead of huge amounts of data surge. Keep in mind that it relies on database logs (redo logs in Oracle) to replicate data in the form of "messages", and therefore it is mandatory to put the database in forced logging mode - that may be a prohibiting factor in some situations.

Incentivized

• Running on OS X and Windows
• Great performance
• Nice UI and UX

• Replicate data for Dev/QA
• Easy setup/upgrade
• Support is easily reachable

Incentivized

• Documentation: There are some areas where the documentation is weak or dated. In particular, running SharePlex on RAC is a more involved process than the implementation guides would have you believe. When reaching out for assistance, the answer from Dell (a few years ago) was to engage their consulting team.
• Built in scripts/agents: SharePlex comes with a handful of monitoring and management scripts that can be run as cron jobs. Unfortunately, these scripts are primitive and rigid, requiring the user to hard-code values into the script body and limiting their usefulness when you're running multiple replication streams. Some of the methods and dependencies are heavy. We ended up writing custom scripts that do what we need but it would be helpful if there were greater functionality and flexibility out of the box.
• Compared to other tools, there is not as wide (or at least as active) a user presence. If you're having difficulties you may have to engage a consultant since it's less likely that you'll find an answer in a forum or blog post.

Incentivized

We depend on it to supply data to our various OLTP and Data Warehouse environments

Incentivized

It is very usable once you get over the initial setup.

Incentivized

Support is very responsive. They take ownership of the problems and see them through to the finish. When a bug is found they work towards developing testing and making the fix available to us to solve the problem.

Incentivized

It's really easy to make APIs via RepreZen API Studio.

SharePlex was a clear winner in comparison to its competitors. It beats GoldenGate on price, providing equivalent features and performance at a fraction of the price and without the need to license costly Oracle features at the database level. DB Visit was a strong contender for us as well and it is an excellent product I would also recommend, but it did not have quite enough of a user and community presence and penetration for our management to feel comfortable with.

Incentivized

• Data migration allows the company to make solid business changes, more so on new business plans.
• Further, system flexibility supports multiple business plans, hence, efficient and reliable.
• Finally, real-time decisions are arrived at using SharePlex, a procedure that ensures there is transparency in the entire operations.

Incentivized