CData DBAmp vs. Integrate.io

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

Integrate.IO or formerly XPlenty can be used for various needs:

• Multiple Sources (Excel, CSV, Text File, Blank File Type, All SQL Type)
• Multiple End Points (All SQL Type)
• Integration to Salesforce Sales Cloud
• Re-using the same package in different platforms which result to less development
• Value for the money

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

• Collecting data from different sources and making these available for BI tools or other IT systems.
• Their support department is really helpful when you are facing issues. Sometimes they refer to their documentation and sometimes they can help you right away.
• Generally I’m really happy with the ease of use. The software just does its job very well and we’re really getting a lot of value from it.

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

• It's not always easy to use.
• Debugging can be challenging when error logs lack specificity.
• Interaction between fields or packages is slow.

Incentivized

I found them super cool and helpful in any regarding to implementation.

Incentivized

Integrate.io offers more customization options than Datorama, allowing businesses to create their own custom integrations and workflows using their API and SDKs. Integrate.io's pricing model is based on the number of data transactions, which may be more cost-effective for businesses that have a high volume of data.

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

• Faster development with less skill requirements
• Part of long range planning
• Captured the data privacy requirements

Incentivized