CData DBAmp vs. Fivetran

Well suited as an inexpensive tool as "middleware" between your on-prem or hosted SQL Server. Not sure how well it will translate to cloud-based SQL as a platform (Azure SQL) as it relies on linked servers. This tool only applies to Salesforce CRM - not Marketing Cloud. For writing back to Salesforce we did run into Salesforce resource limitations when extensive triggers existed on the objects.

Incentivized

[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

• Connects & Links to Salesforce CRM databases - including custom objects.
• Built in procedures to create copies of the database on SQL Server.
• Built in procedures to Add, Update, and Delete data within Salesforce CRM.
• Great Technical Support.

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

• Because it uses Linked Servers, not sure how this will work in Azure SQL.
• Replicated tables are based on user security - this means you have to pay for a license to set this up.
• There is no built-in function to skip tables or fields on secured tables. This has to be done on the CRM side for fields and we built a function to skip tables in the replication logic.

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

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 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

• Enabled automated marketing segments which enabled automated email series.
• Helped us solicit donations for the right amount at the right time.
• Helped us take on new marketing and fundraising campaigns without adding staff.

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