CData DBAmp vs. Panoply

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
Panoply
Score 8.6 out of 10
N/A
Panoply, from Sqream since the late 2021 acquisition, is an ETL-less, smart end-to-end data management system built for the cloud. Panoply specializes as a unified ELT and Data Warehouse platform with integrated visualization capabilities and storage optimization algorithms.N/A
Pricing
CData DBAmpPanoply
Editions & Modules
Single Server License One-year Subscription
$2,495
per user
No answers on this topic
Offerings
Pricing Offerings
CData DBAmpPanoply
Free Trial
YesYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsPanoply offers simple, transparent pricing. All plans have a 21-day free trial—no credit card required. You'll get an account executive and data architect to help you get the most out of your smart data warehouse. Pricing starts at $325/month.
More Pricing Information
Community Pulse
CData DBAmpPanoply
Best Alternatives
CData DBAmpPanoply
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Astera Data Pipeline Builder (Centerprise)
Astera Data Pipeline Builder (Centerprise)
Score 8.8 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Control-M
Control-M
Score 9.3 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
CData DBAmpPanoply
Likelihood to Recommend
9.0
(1 ratings)
10.0
(4 ratings)
Usability
-
(0 ratings)
10.0
(1 ratings)
User Testimonials
CData DBAmpPanoply
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
Sqream Technologies
Panoply is well suited for companies with large amounts of data that do not want all users of the company to see or view. It is appropriate for companies that have to store data for several years in case clients need the data. It is not made to constantly be downloading or looking at the documents.
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
Sqream Technologies
  • Ease of data integrations. Importing data into the data warehouse is a point-and-click effort.
  • Automated data modeling. The data is modeled in a way that facilitates analysis without having to look into it myself.
  • Query speed. Automated query optimization has really sped up our dashboards.
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
Sqream Technologies
  • The user interface could use some improvement for analytical tools. Apart from that, it’s great.
Read full review
Usability
CData Software
No answers on this topic
Sqream Technologies
It’s a good choice for building a quick, multipurpose data stack for a variety of businesses needs.
Read full review
Alternatives Considered
CData Software
No answers on this topic
Sqream Technologies
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.
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
Sqream Technologies
  • Saved time on Redshift setup
  • Saved support costs (monetary and temporal) by not having to set up on-premise
  • Widens the BI tool use in organization; lowers the barrier to entry and makes organization more productive in analytical terms
Read full review
ScreenShots

CData DBAmp Screenshots

Screenshot of Screenshot of

Panoply Screenshots

Screenshot of Simply click to connect 100 data sources.