Fivetran vs. Panoply

[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

Panoply is great for smaller organizations where analytics is critical, but it is unrealistic to hire a data engineer or build a data infrastructure. Panoply comes as a full data stack out of the box.

• 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

• Redshift setup -- so much easier with Panoply, rather than messing around with AWS mishegoss
• Automated data ingestion and formatting -- I love not having to write out SQL table schema
• Easy scaling and data warehouse maintenance -- I don't like to have to mess with this in previous redshift implementations

• 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

• Needs more user control

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’s a good choice for building a quick, multipurpose data stack for a variety of businesses needs.

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

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

Panoply has much more storage and better organization tools for searching. There are better folders and tools for keeping documents secure and stored for a long period of time. It is better to offload data in mass than singular or Zip drive documents like you would do in Google Drive.

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

• The user interface could use some improvement for analytical tools. Apart from that, it’s great.