TrustRadius

Clear Analytics vs. IDERA SQL Compliance Manager

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Clear Analytics
Score 8.8 out of 10
Enterprise companies (1,001+ employees)
Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.
$29
Per Seat per Month
IDERA SQL Compliance Manager
Score 9.0 out of 10
N/A
SQL Compliance Manager helps database administrators to monitor, audit, and alert on Microsoft SQL Server user activity and data changes. The vendor states it provides quick configuration of audit settings, a broad list of regulatory guideline templates for audit settings and reports, before and after data values for both regulatory compliance and forensic data investigations, differentiation of data access and between regular and privileged users and applications, easy specification of and…
$3,036
per instance with first year maintenance included
Pricing
Clear AnalyticsIDERA SQL Compliance Manager
Editions & Modules
Personal
$29
Per Seat per Month
Team
$165
upto 10 Seat per Month
Department
$265
upto 25 Seat per month
Organization
$565
Upto 100 per seat per month
Standard via eCommerce
3,036.00
per instance with first year maintenance included
Offerings
Pricing Offerings
Clear AnalyticsIDERA SQL Compliance Manager
Free Trial
YesYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup Fee$800 Initial OnBoardingNo setup fee
Additional DetailsCertain Enterprise level features can be made available to Small Business edition at additional cost. Such services include Scheduler and OLAP connectivity. Custom adapters can also be created to connect to SaaS services.—
More Pricing Information
Community Pulse
Clear AnalyticsIDERA SQL Compliance Manager
Features
Clear AnalyticsIDERA SQL Compliance Manager
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Clear Analytics
9.0
8 Ratings
9% above category average
IDERA SQL Compliance Manager
-
Ratings
Pixel Perfect reports9.08 Ratings00 Ratings
Customizable dashboards9.18 Ratings00 Ratings
Report Formatting Templates8.78 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Clear Analytics
8.9
8 Ratings
10% above category average
IDERA SQL Compliance Manager
-
Ratings
Drill-down analysis9.28 Ratings00 Ratings
Formatting capabilities8.78 Ratings00 Ratings
Report sharing and collaboration8.98 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Clear Analytics
9.0
8 Ratings
9% above category average
IDERA SQL Compliance Manager
-
Ratings
Publish to Web9.08 Ratings00 Ratings
Publish to PDF9.17 Ratings00 Ratings
Report Versioning8.98 Ratings00 Ratings
Report Delivery Scheduling8.87 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Clear Analytics
9.0
8 Ratings
12% above category average
IDERA SQL Compliance Manager
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)8.98 Ratings00 Ratings
Location Analytics / Geographic Visualization9.18 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Clear Analytics
9.3
8 Ratings
9% above category average
IDERA SQL Compliance Manager
-
Ratings
Multi-User Support (named login)9.48 Ratings00 Ratings
Role-Based Security Model9.08 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)9.48 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Clear Analytics
8.6
6 Ratings
10% above category average
IDERA SQL Compliance Manager
-
Ratings
Mobile Application8.54 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile8.76 Ratings00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
Clear Analytics
-
Ratings
IDERA SQL Compliance Manager
7.0
1 Ratings
14% below category average
User management00 Ratings7.01 Ratings
Database security00 Ratings7.01 Ratings
Best Alternatives
Clear AnalyticsIDERA SQL Compliance Manager
Small Businesses
Yellowfin
Yellowfin
Score 8.7 out of 10
DBeaver
DBeaver
Score 8.5 out of 10
Medium-sized Companies
Reveal
Reveal
Score 10.0 out of 10
ER/Studio
ER/Studio
Score 9.9 out of 10
Enterprises
Kyvos Semantic Layer
Kyvos Semantic Layer
Score 9.5 out of 10
ER/Studio
ER/Studio
Score 9.9 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Clear AnalyticsIDERA SQL Compliance Manager
Likelihood to Recommend
9.0
(8 ratings)
10.0
(1 ratings)
Usability
9.1
(8 ratings)
-
(0 ratings)
Support Rating
9.5
(8 ratings)
-
(0 ratings)
User Testimonials
Clear AnalyticsIDERA SQL Compliance Manager
Likelihood to Recommend
Clear Analytics
Clear Analytics has almost all the features which are mostly required by the organizations for their data analytics and transformation activities. Clear Analytics is built on the support of a parallel query engine which makes it handle large volume requests and also provides optimized results. However, every solution has some limitations, Clear Analytics lacks advanced features such as Predictive Analytics which is a very demanding feature in the market as most organizations are adopting AI/ML automation for their businesses. Also, it needs to add a lot of advanced visualizations so that the user has the choice of selection. Overall a good solution to be recommended.
PA
Prateek Agarwal
Technical Program Manager
Read full review
Idera, Inc.
The payment card industry is best as it has built-in PCI DSS compliant and in a transactional DB where there are a lot of DML activities the size of the database must be increased.
MK
Muhammad Hassan Khan
Database Administrator
Read full review
Pros
Clear Analytics
  • Quick management of the data through Excel thanks to the tools Clear Analytics provides such as filtering different information for an easier view.
  • Ability to add new KPIs to measure different areas of our business.
  • Drag and drop tool which makes an easier usage of Excel.
  • Cost-effective. I find Clear Analytics to be affordable considering the number of features added and the unlimited sharing and editing it provides.
Carlos Begazo | TrustRadius Reviewer
Carlos Begazo
Sales Manager
Read full review
Idera, Inc.
  • Audit Logins
  • DML Activities
  • DDL Activities
  • Queries Reporting
MK
Muhammad Hassan Khan
Database Administrator
Read full review
Cons
Clear Analytics
  • For Charts and Graphs , getting the Power Point Deck would be helpful. As of now we use the data from Excel Reports
Salam Mohammed | TrustRadius Reviewer
Salam Mohammed
System Solution Architect
Read full review
Idera, Inc.
  • Should have a compression algorithm to compress the audited logs, as it will take a lot of space.
  • Can not audit all the DML and DDL activities as it will take a lot of space, should have a compression algo.
MK
Muhammad Hassan Khan
Database Administrator
Read full review
Usability
Clear Analytics
I have really enjoyed working with Clear Analytics. This platform has contributed to increased production and reliable data control processes. It has flexible user interface that can be operated by any organization member. Reports are shared on simple and transparent way in the dashboard for easy access. Data analytics from all departments have created manageable working environment that have increased production.
Carter Halliday | TrustRadius Reviewer
Carter Halliday
Marketing Manager
Read full review
Idera, Inc.
No answers on this topic
Support Rating
Clear Analytics
I have had multiple scenarios where I had to reach out to the support team of Clear Analytics, be it access-related, general queries, during initial implementation, etc. My overall experience has always been good. I got the needed support every time without any delay. I can definitely recommend Clear Analytics simply on the basis of its excellent support team.
Verified User
Anonymous
Read full review
Idera, Inc.
No answers on this topic
Alternatives Considered
Clear Analytics
There are other great tools that are out there but Clear Analytics is reasonable for our business and provides a lot of features that we specifically needed
JP
Johnny Pelter
Client Relations Manager
Read full review
Idera, Inc.
More easy to use, no SQL queries to extract data out of it, graphical user interface is very good and easy to use.
MK
Muhammad Hassan Khan
Database Administrator
Read full review
Return on Investment
Clear Analytics
  • Super useful to get started immediately
  • Didn't have to rely on migrating data
  • Easy to add members
  • Easy to learn and build charts
Jitesh Dugar | TrustRadius Reviewer
Jitesh Dugar
Senior Product Manager
Read full review
Idera, Inc.
  • Audit reports are a hectic job for a DBA it made them easy.
MK
Muhammad Hassan Khan
Database Administrator
Read full review
ScreenShots

Clear Analytics Screenshots

Screenshot of Clear Analytics integrated Excel panel essentially transforms standalone Excel into an enterprise strength, fully auditable, collaborative and centralized business intelligence platform.Screenshot of Users have the ability to dynamically query systems and render that data in any way they like. No more waiting on IT to create reports.Screenshot of Your firms existing knowledge of Excel enables the firm to be product from day 1. Use the skills already present in your organization and don't pay for outside reporting consultants to create reports for you.Screenshot of Leverage the integration capability of Microsoft's Power BI to extend the reach of your data to web and mobile devices.Screenshot of Leverage all of Excels capabilities, from it's slicers to miniature spark-line charts to create incredibly informative and responsive dashboards.

IDERA SQL Compliance Manager Screenshots

Screenshot of SQL Compliance Manager: Monitor, audit, and alert on user activity and data change