Try our new research platform with insights from 80,000+ expert users

Oracle Essbase vs Redgate SQL Toolbelt Essentials comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 23, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Oracle Essbase
Ranking in Database Development and Management
10th
Average Rating
8.4
Reviews Sentiment
5.5
Number of Reviews
14
Ranking in other categories
No ranking in other categories
Redgate SQL Toolbelt Essent...
Ranking in Database Development and Management
8th
Average Rating
8.0
Reviews Sentiment
7.2
Number of Reviews
2
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2025, in the Database Development and Management category, the mindshare of Oracle Essbase is 1.2%, up from 0.7% compared to the previous year. The mindshare of Redgate SQL Toolbelt Essentials is 5.4%, down from 5.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management
 

Featured Reviews

RANOJOY PAUL - PeerSpot reviewer
Stores multidimensional data, good customer support and interface is very easy
It is very fast compared to other normal databases, like SQL and MySQL. It doesn't store data in tables in the back end. To load data into Essbase, we need to prepare it in a table format. When we find the data in the table, we need to verify it. This way, you can rate the data. But Essbase stores multidimensional data. We have dimensions, which means the data belongs to some company or some time period. For example, if you work for three years, your salary should be something. In this way, we prepare top-level members called dimensions. The dimension defines your position, the year, and the section you were working in the company. We get an intersection of all these dimensions for certain data, and fetching that data is very fast in Essbase compared to normal SQL. If you store this data in a normal SQL table, you need to prepare a row with your company name, employee name, employee ID, joining date, and everything, and then you need to push it into a SQL table. You can search it using your query, but here, that thing is different. Here, you can collect data using forms, reports, and we use a Microsoft tool, which is an add-in called Smart View. Using that, you would just take that data. Here, you need to just create an integration of all these dimensions, and then only you can find the data.
CS
SQL Search and change automation functionality help us manage our code repository and databases
The biggest problem with the Redgate SQL Toolbelt is just how heavy it is; it seems to take a lot of resources. It takes a lot of memory and a lot of processing power to run, and that tends to slow things down a bit. Making it a little more lightweight while still doing the same thing, as much as possible, is what we would like to see in the future. I've noticed that Microsoft SSMS runs much quicker without RedGate installed than it does with it installed. From bootup of the app to opening query windows and connections, SSMS is quicker without Redgate than with, by a significant margin. The other area for improvement is regarding licensing. Every month or two my SSMS loses it's redgate license key and I need to re-enter the key to continue using Red Gate, even though the license is annual.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The solution can handle a large volume of data."
"I have found the most valuable aspect is the user-friendly environment and current features."
"The solution is stable and reliable."
"It is very fast compared to other normal databases, like SQL and MySQL."
"It's a very powerful analytical engine with Essbase as the back end. We can analyze, transform, or utilize a big chunk of data for our calculations."
"Oracle Essbase is a web integration system that integrates with other data systems."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
"Unlike relational, where you're linking together multiple tables, with Essbase, you basically define what the dimensions are beforehand, and you define the hierarchy, and then load the data. This allows you to do a pretty sophisticated analysis so that you can drill into it and slice and dice the data."
"The most valuable feature is SQL Search."
"It is easy to track the reports, this is what is most valuable for me."
 

Cons

"There is room for improvement in terms of cost-effectiveness."
"The initial setup is pretty complex."
"The ability to drive external reporting out for development could be improved."
"They should improve the solution's performance."
"It's an expensive product to use."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"The reporting tool of Essbase needs improvement."
"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"The biggest problem with the Redgate SQL Toolbelt is just how heavy it is; it seems to take a lot of resources."
"I would like to see the bandwidth increase allowing me to easily analyze more data."
 

Pricing and Cost Advice

"The solution is expensive."
"It is a costly solution."
"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
"Our fees are paid on an annual basis."
"The cost is about $3,500 USD per individual to buy, and then it's about 20% per year for renewal."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
838,640 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
23%
Computer Software Company
11%
Manufacturing Company
9%
Insurance Company
6%
Financial Services Firm
15%
Computer Software Company
11%
Government
10%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for Oracle Essbase?
It's not that expensive, but also not cheap. I'm not sure because it's a private license.
What needs improvement with Oracle Essbase?
If I got the opportunity to work with Hyperion, which is the best product, I would definitely go with that. The main concern is that Oracle is ending on-premises server support, so it would be bett...
What is your primary use case for Oracle Essbase?
We provide complete ownership of this application to Walmart projects. In the UK system, we support and develop for the Asda account, known as Eltham. We provide installation and support to over 50...
Ask a question
Earn 20 points
 

Also Known As

Essbase
No data available
 

Overview

 

Sample Customers

CHU de Rennes, Bellco Credit Union, Akindo Sushiro Co. Ltd, Deutsche Telekom AG, Samarco MineraÊo S.A., PCCW Ltd., QDQ media S.A.U., Boiron Italia, Specialized Bicycle Components Inc., Akindo Sushiro Co. Ltd., Air Canada, Daelim Industrial Co. Ltd.
Thinger.fi, Churchill College Univeristy of Cambridge, Margin Business Solutions Ltd., 4Penny.net, Sportinginsider.net, Lockheed Martin, Phillip Securities Pte Ltd, Nmbrs
Find out what your peers are saying about Oracle Essbase vs. Redgate SQL Toolbelt Essentials and other solutions. Updated: January 2025.
838,640 professionals have used our research since 2012.