Devart ODBC Driver vs. IBM Planning Analytics

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Devart ODBC Driver
Score 5.2 out of 10
N/A
Devart ODBC Driver for Oracle provides a high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, both 32-bit and 64-bit. Its full support for standard ODBC API functions and data types implemented in their driver makes the interaction of database applications with Oracle faster, easier and handy.
$349.95
IBM Planning Analytics
Score 8.2 out of 10
N/A
IBM Planning Analytics, powered by IBM TM1®, is an integrated planning solution designed to promote collaboration across the organization and help keep pace with the speed of modern business. With its calculation engine, this enterprise performance management solution is designed to help users move beyond the limits of spreadsheets, automating the planning process to drive faster, more accurate results. Use it to unify data sources into one single repository, enabling users to build…
$825
per month 5 users
Pricing
Devart ODBC DriverIBM Planning Analytics
Editions & Modules
Desktop Perpetual
$349.95
Essentials
$825
per month 5 users
Standard
$1,650
per month 10 users
Offerings
Pricing Offerings
Devart ODBC DriverIBM Planning Analytics
Free Trial
YesYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional Details
More Pricing Information
Community Pulse
Devart ODBC DriverIBM Planning Analytics
Features
Devart ODBC DriverIBM Planning Analytics
Database Development
Comparison of Database Development features of Product A and Product B
Devart ODBC Driver
10.0
3 Ratings
16% above category average
IBM Planning Analytics
-
Ratings
Version control tools10.02 Ratings00 Ratings
Test data generation10.03 Ratings00 Ratings
Performance optimization tools10.03 Ratings00 Ratings
Schema maintenance10.03 Ratings00 Ratings
Database change management10.02 Ratings00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
Devart ODBC Driver
10.0
3 Ratings
17% above category average
IBM Planning Analytics
-
Ratings
User management10.02 Ratings00 Ratings
Database security10.03 Ratings00 Ratings
Database status reporting10.03 Ratings00 Ratings
Change management10.02 Ratings00 Ratings
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
9.0
93 Ratings
17% above category average
Pixel Perfect reports00 Ratings8.982 Ratings
Customizable dashboards00 Ratings8.993 Ratings
Report Formatting Templates00 Ratings9.387 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
9.0
99 Ratings
12% above category average
Drill-down analysis00 Ratings8.996 Ratings
Formatting capabilities00 Ratings8.998 Ratings
Integration with R or other statistical packages00 Ratings8.974 Ratings
Report sharing and collaboration00 Ratings9.395 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
9.0
93 Ratings
11% above category average
Publish to Web00 Ratings8.988 Ratings
Publish to PDF00 Ratings8.987 Ratings
Report Versioning00 Ratings9.486 Ratings
Report Delivery Scheduling00 Ratings8.978 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
8.8
95 Ratings
15% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings9.495 Ratings
Location Analytics / Geographic Visualization00 Ratings8.989 Ratings
Predictive Analytics00 Ratings9.485 Ratings
Pattern Recognition and Data Mining00 Ratings7.619 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
9.0
99 Ratings
5% above category average
Multi-User Support (named login)00 Ratings9.497 Ratings
Role-Based Security Model00 Ratings8.998 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.999 Ratings
Report-Level Access Control00 Ratings8.324 Ratings
Single Sign-On (SSO)00 Ratings9.491 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
7.5
86 Ratings
4% below category average
Responsive Design for Web Access00 Ratings6.685 Ratings
Mobile Application00 Ratings7.549 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings7.558 Ratings
Budgeting, Planning, and Forecasting
Comparison of Budgeting, Planning, and Forecasting features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
9.0
105 Ratings
10% above category average
Long-term financial planning00 Ratings8.9101 Ratings
Financial budgeting00 Ratings8.9104 Ratings
Forecasting00 Ratings9.4105 Ratings
Scenario modeling00 Ratings8.9104 Ratings
Management reporting00 Ratings8.9104 Ratings
Consolidation and Close
Comparison of Consolidation and Close features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
9.2
98 Ratings
16% above category average
Financial data consolidation00 Ratings9.394 Ratings
Journal entries and reports00 Ratings8.986 Ratings
Multi-currency management00 Ratings9.487 Ratings
Intercompany Eliminations00 Ratings8.986 Ratings
Minority Ownership00 Ratings9.478 Ratings
Local and consolidated reporting00 Ratings8.990 Ratings
Detailed Audit Trails00 Ratings9.392 Ratings
Financial Reporting and Compliance
Comparison of Financial Reporting and Compliance features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
8.8
99 Ratings
11% above category average
Financial Statement Reporting00 Ratings8.995 Ratings
Management Reporting00 Ratings9.496 Ratings
Excel-based Reporting00 Ratings8.998 Ratings
Automated board and financial reporting00 Ratings9.388 Ratings
XBRL support for regulatory filing00 Ratings7.764 Ratings
Analytics and Reporting
Comparison of Analytics and Reporting features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
9.1
101 Ratings
12% above category average
Personalized dashboards00 Ratings9.3100 Ratings
Color-coded scorecards00 Ratings8.995 Ratings
KPIs00 Ratings9.498 Ratings
Cost and profitability analysis00 Ratings8.996 Ratings
Key Performance Indicator setting00 Ratings8.997 Ratings
Benchmarking with external data00 Ratings8.968 Ratings
Integration
Comparison of Integration features of Product A and Product B
Devart ODBC Driver
-
Ratings
IBM Planning Analytics
9.2
100 Ratings
12% above category average
Flat file integration00 Ratings9.497 Ratings
Excel data integration00 Ratings8.998 Ratings
Direct links to 3rd-party data sources00 Ratings9.389 Ratings
Best Alternatives
Devart ODBC DriverIBM Planning Analytics
Small Businesses
DBeaver
DBeaver
Score 8.8 out of 10

No answers on this topic

Medium-sized Companies
DBeaver
DBeaver
Score 8.8 out of 10
Centage
Centage
Score 9.5 out of 10
Enterprises
DBeaver
DBeaver
Score 8.8 out of 10
Prophix
Prophix
Score 8.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Devart ODBC DriverIBM Planning Analytics
Likelihood to Recommend
10.0
(3 ratings)
8.5
(111 ratings)
Likelihood to Renew
-
(0 ratings)
9.1
(5 ratings)
Usability
-
(0 ratings)
9.7
(72 ratings)
Support Rating
6.0
(1 ratings)
9.7
(96 ratings)
Product Scalability
-
(0 ratings)
9.1
(1 ratings)
User Testimonials
Devart ODBC DriverIBM Planning Analytics
Likelihood to Recommend
Devart
It is appropriate in all scenarios. It is perfect to connect with the database. Actually, nothing to dislike in functionality and performance. It is stand-alone and doesn't need any additional application to be installed.
Read full review
IBM
IBM Planning Analytics is good for small to medium-size jobs or less complex projects. It can generate reasonably comfident results if input datasets are well prepared and cleaned. IBM Planning Analytics is not quite good when it comes to large-scale datasets, or datasets from various sources (for example data dumped from different databases.
Read full review
Pros
Devart
  • Far less connection failures. We had a lot of failures with the tool that we were using before.
  • High performance and new features are really useful. Direct mode connectivity seems to make the difference that was very much needed.
  • Works very well with Oracle Database 10g.
Read full review
IBM
  • Handle very large data volumes.
  • Scale to a large number of users.
  • Not having to compromise on business complexity.
  • It can be run by business users.
  • Availability of highly qualified consultants to support businesses.
  • REST API allows for an open eco system and a variety of solutions to extend the product.
  • Vast integration possibilities.
  • AI-infused engine with IBM Watson.
Read full review
Cons
Devart
  • User Interface could be better.
  • Error Messages and error handling could be improved to be more relevant and specific.
  • Availability.
Read full review
IBM
  • IBM Planning Analytics was an upgrade from an older version of TM1 that is experiencing some growing pains, some functionality is harder to reach than it has been in the past
  • It is easy to learn as a surface user with created reports, but it does require some technical skills to make advanced calculations and reports if there is no reliable consultant available, much like Excel
Read full review
Likelihood to Renew
Devart
No answers on this topic
IBM
Since IBM Cognos Express is suitable only for medium data warehouse environment, we are not sure if this tool solves the long term need as the business keeps growing rapidly. So its a 50/50 ratio to renew Express license. But having said that, the components of IBM Cognos Express are also available in other Cognos BI suites like Cognos 10.x version. So we will probably upgrade our environment to IBM Cognos 10.x which comes with more new features.
Read full review
Usability
Devart
No answers on this topic
IBM
For developers, admins and end users looking for flexibility, IBM Planning Analytics would rate very highly on usability. For example, a developer has access to a highly performant built-in ETL (Extract Translate Load) tool and scripting language called Turbo Integrator that can (among other things) bring in data via flat file or direct connection from many data sources, move data around Planning Analytics, perform batch calculations, export to files or other data stores. In the rare situation where limitations are encountered there is a well documented REST API. Admins and end users benefit from the intuitive PAW (Workspace) interface as well as the rich Excel integration through Planning Analytics for Excel (PAfE). Since flexibility inherently comes with a little more complexity, so an organization with simple and "cookie-cutter" requirements may rate Planning Analytics a little lower.
Read full review
Support Rating
Devart
Support has been great so far but still, it could be better.
Read full review
IBM
Although I find the IBM Planning analytics documentation quite time consuming, their support with email and call is something i can term as very considerate and patient, I have had few calls about the features and how i would want to implement them within my projects, and the teams have been super helpful to resolve my issues
Read full review
Alternatives Considered
Devart
Devart Driver ODBC for MySQL is best with no known issues. It is stand-alone. It supports SSH/SSL communication. supports HTTP / HTTPS tunneling. It is available for a variety of operating systems like Windows, Mac, and Linux. It is available for 32-bit and 64-bit environments. It supports all renowned programming languages. it supports multiple languages. It allows various data types.
Read full review
IBM
Anaplan does not handle sparsity; this is very problematic for large volume data sets (many 0's). There also are limitations to the number of dimensions that can be used in a module. If more dimensions are required, then separate modules need to be built and intertwined. IBM PA does not have these limitations.
Read full review
Return on Investment
Devart
  • Our organization has been largely moving into agile development life cycle and continuous integration is a key towards agile success. Automation is the first step towards continuous integration. We are really happy using Devart as a part of our automation engineering. It definitely contributes towards overall success.
  • We are trying to extend the usage. The development team has also shown interest towards the usage.
  • This is a cost effective tool. It is worth the price.
Read full review
IBM
  • One of the advantage is on its ability to ease budget and planning
  • Secondly,the fact that it allows for forecasting means based on such insights means that organisations are able to prepare for future eventualities
  • Thirdly, since it can accommodate data from multiple sources means that one is able to carry out best business practices like planning.
Read full review
ScreenShots

Devart ODBC Driver Screenshots

Screenshot of

IBM Planning Analytics Screenshots

Screenshot of Workflow managementScreenshot of Income statementScreenshot of Margin analysisScreenshot of Metrics managementScreenshot of Income statementScreenshot of Expense analysis