Fivetran vs. SharePlex

[Fivetran is] very well suited when you are using popular and common data sources, such as the major ad platforms, and SaaS platforms such as Salesforce. If the majority of your data sources are custom internal applications or databases, may be less value as you aren't leveraging the delivered connectors.

Incentivized

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

• Simplified ETL from a wide range of data sources
• Stable and painless data pipeline
• Granular control over what parts of the data source are loaded

Incentivized

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

Incentivized

• Doesn't include support for a Kinesis stream as a data source so couldn't be used for some use cases under consideration
• Doesn't support the use of "BEFORE DELETE" triggers
• No support for serverless Aurora

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

Very easy and intuitive to setup and maintain as there usually are not that many options. Very well documented (e.g. how to setup each connector, how the schema looks like, any specific features of this connector etc.). Also the operation is intuitive, e.g. you have status pages, log pages, configuration pages etc. for each connector.

Incentivized

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

Incentivized

It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.

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

Fivetran came well with the connectors' availability and updates with the source changes. We had an idea on data requirements in our case which helped us to work out on cost implication and take a decision for Fivetran as a data provider for our organization. These were 2 places where Fivetran out-performed, other vendors.

Incentivized

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

• Saved a lot of manual development days (unable to quantify)
• Accelerated the time to add a new source to the data warehouse a lot

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