CData DBAmp vs. Informatica Intelligent Cloud Integration Services

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
CData DBAmp
Score 9.0 out of 10
N/A
DBAmp is a Salesforce integration solution for any SQL DBA. With DBAmp, users can access Salesforce data in real-time using standard SQL. For many organizations, SQL Server plays a critical role in BI and operational reporting. Using DBAmp, users can extend the same SQL Server integrations they've built for BI, analytics, and reporting to Salesforce data.
$2,495
per user
Informatica Intelligent Cloud Integration Services
Score 7.0 out of 10
N/A
Informatica’s Intelligent Cloud Services (IICS) platform is a solution for synchronizing and integrating cloud and on-premise applications. It offers prebuilt connectors and actions between applications and programs, allowing for data transformation within the program, as well as case-specific services.N/A
Pricing
CData DBAmpInformatica Intelligent Cloud Integration Services
Editions & Modules
Single Server License One-year Subscription
$2,495
per user
No answers on this topic
Offerings
Pricing Offerings
CData DBAmpInformatica Intelligent Cloud Integration Services
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
CData DBAmpInformatica Intelligent Cloud Integration Services
Top Pros
Top Cons
Features
CData DBAmpInformatica Intelligent Cloud Integration Services
Cloud Data Integration
Comparison of Cloud Data Integration features of Product A and Product B
CData DBAmp
-
Ratings
Informatica Intelligent Cloud Integration Services
8.8
13 Ratings
9% above category average
Pre-built connectors00 Ratings9.013 Ratings
Connector modification00 Ratings8.712 Ratings
Support for real-time and batch integration00 Ratings9.713 Ratings
Data quality services00 Ratings8.712 Ratings
Data security features00 Ratings8.312 Ratings
Monitoring console00 Ratings8.313 Ratings
Best Alternatives
CData DBAmpInformatica Intelligent Cloud Integration Services
Small Businesses
Skyvia
Skyvia
Score 9.8 out of 10
Make
Make
Score 9.2 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Make
Make
Score 9.2 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM App Connect
IBM App Connect
Score 8.9 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
CData DBAmpInformatica Intelligent Cloud Integration Services
Likelihood to Recommend
9.0
(1 ratings)
8.3
(13 ratings)
Likelihood to Renew
-
(0 ratings)
9.0
(1 ratings)
Support Rating
-
(0 ratings)
8.0
(3 ratings)
User Testimonials
CData DBAmpInformatica Intelligent Cloud Integration Services
Likelihood to Recommend
CData Software
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.
Read full review
Informatica
Informatica Cloud is a great tool for use when data must be formatted consistently. Once configured, it is very robust and reliable. It is also well-suited for an organization without a robust IT staff to maintain a full server infrastructure. It offers a cost-effective approach to high-quality data integration for even the largest organizations. Organizations without staff experienced in data analytics may find it challenging to take advantage of the more complex results of this tool.
Read full review
Pros
CData Software
  • 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.
Read full review
Informatica
  • Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects.
  • The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed.
  • The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office.
Read full review
Cons
CData Software
  • 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.
Read full review
Informatica
  • The User Interface can be a bit difficult to get in initial stages.
  • Error messages are hard to understand which sometimes takes a lot of time for the resolution
  • Cannot Implement complex SQL queries which should be fixed in future release.
Read full review
Support Rating
CData Software
No answers on this topic
Informatica
I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.
Read full review
Alternatives Considered
CData Software
No answers on this topic
Informatica
First, the wizard is easy to use making the learning curve for simple ETL tasks nice. Second, since Informatica is mature there are a good variety of connectors available. Finally, we have driven some fairly complex ETL solutions using only the cloud.
Read full review
Return on Investment
CData Software
  • 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.
Read full review
Informatica
  • Cut costs on the number of staff we need for data import.
  • Cut costs for automation that can be done for data that no longer has to be manually imported.
  • We've saved countless dollars by eliminating duplicates in our system with this tool.
Read full review
ScreenShots

CData DBAmp Screenshots

Screenshot of Screenshot of