CData DBAmp vs. Progress DataDirect

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

Hybrid Data Pipeline lets users consume or share data in can timely and compliant manner regardless of the application they use or the location of the data. It has defined a stringent set of policies and practices around product development and distribution. Enables customers to consume their data in your application using their BI tool of choice.

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

• Providing JDBC connectivity to CRM applications
• Raw data integration
• Customer support

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

• Seamless data access for BI and Analytics.
• Helps you comply with industry standards.
• Cloud and On-premises Data Access with Hybrid Data Pipelines.

Incentivized

Easy to use with JDBC interface, detailed debug logs for troubleshooting, and easier audit with detailed log. Cost of ingestion is relatively cheaper

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

• Create custom data access and security policies at a user level.
• Integrate HDP into your app seamlessly with management and administration API's.
• Hybrid Data Pipeline service can be deployed on multiple modes behind a load balancer.

Incentivized