Fivetran vs. WSO2 Enterprise Integrator

Fivetran's business model justifies the use-case where we require data from a single source basically a lot of data but if the requirement is not on the heavier side, Fivetran comes to costly operation when compared to its peers. Otherwise, I'll recommend Fivetran for stability and update and seamless service provider.

Incentivized

The best-suited scenario is the service chain pattern or all patterns used in online mode. The less appropriate scenario is a batch service the duration time of the service is more than 10minutes because it is necessary to increase the HTTP timeout.

• Easily connects to source data using delivered connectors
• Transforms data into standard models and schemas
• Has very good documentation to help quickly setup connectors

Incentivized

• Service chain pattern
• Message transformation
• Call more than one backend service
• Call service with different protocoll as the client use
• Use file as input
• Use mail as input

• More detailed logging
• More flexible choices for time range over which records are synced
• More options for masking and excluding sensitive data

Incentivized

• View deploy artifact in date time order
• Easy way to map data
• Easy way to manage payload

Just need to input connection info.

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

We never seriously considered using anything else. Our data engineers had used Fivetran extensively in previous roles so when it came time to make a decision, there wasn't much of a process. They gladly signed the contract with Fivetran pretty quickly.

Incentivized

We can start with the community version and then when we moved into production we can buy the supported version. The supported and community version have the same code so we can do every test before deciding to buy the supported version.

• Business and product data now co-located in the warehouse
• Dashboards can be built using data from all corners of the business
• Better visibility into customer health, product usage, business financials, and more
• Enabled high-traffic operational dashboards that increase efficiency of our sales and ops teams

Incentivized

• Reduce development time to the service integration
• We can use junior developer
• Clustered in easy way