Compare ODBC Driver for Oracle vs CData Excel Add-Ins vs InterSystems IRIS

View Listing View Listing View Listing

Crozscore

85%
what is this?
interest rising

Crozscore

87%
what is this?

Crozscore

89%
what is this?
interest falling
ODBC Driver for Oracle screenshot CData Excel Add-Ins screenshot view 1 more InterSystems IRIS screenshot view 2 more

About ODBC Driver for Oracle

Devart ODBC Driver for Oracle is a high-performance connectivity solution with enterprise-level features for accessing Oracle databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows, macOS, and Linux. Our ODBC driver fully supports standard ODBC API functions and data types and enables easy and secure access to live Oracle data from anywhere.

About CData Excel Add-Ins

CData Excel Add-Ins install right into Excel and empower anyone to instantly connect to live data from 200+ data sources — inside Excel.

Quickly and conveniently get access to data from your accounting, CRM, ERP, sales, marketing, social media, SaaS, cloud, and database tools in Excel; even push changes from Excel right to your data — wherever it resides.

Connect to live data from:

  • Quickbooks
  • Sage
  • Salesforce
  • HubSpot
  • Microsoft Dynamics 365
  • MySQL
  • SQL Server
  • eTrade
  • And hundreds more

The CData Excel Add-Ins simplify the way you read, write, and update live data from web and desktop applications. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!

The Add-Ins are powerful tools that provide:

  • Bi-directional access to live data
  • Easy-to-use, straightforward configuration
  • Quick data imports, exports, backups, and integrations

Use the built-in connection wizard to create a connection and immediately begin working with live tables of data from 200+ sources. The Excel Add-Ins are completely self-contained; no additional software installation required. They integrate with the Excel toolbar and ribbon, providing direct access to live data in one click.

Easy-To-Use, Straightforward Configuration:

  1. Install the Add-In
  2. Configure the Connection
  3. Select Tables

Installing any of the Excel Add-Ins creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.

Download a 30-day free trial or learn more at https://www.cdata.com/excel/

About InterSystems IRIS

At the core of InterSystems IRIS Data Platform is a proven, enterprise-grade, distributed hybrid transactional/analytic processing (HTAP) database. It can ingest and store transactional data at very high rates while simultaneously processing high volumes of analytic workloads on real-time data (including ACID-compliant transactional data)
and non-real-time data.

InterSystems IRIS includes a native multi-model persistence engine, which helps to operate the data via key-value, document, SQL, or object API. The set of InterSystems IRIS API includes ODBC/JDBC, java, .NET, nodejs, python, call-in/call-out interfaces, REST and web-sockets capabilities and more.

InterSystems IRIS provides horizontal scalability for high data volumes and demanding application workloads through a flexible scalable architecture. For large data volumes, InterSystems' IRIS sharding capability allows horizontal partitioning of database tables, spreading their data and associated workload across a tier of data nodes. For high user counts or competing workloads, a tier of compute nodes can be added to the cluster to serve data at ultra-low latencies.

All nodes are based on the same technology, providing a 100% homogeneous architecture and correspondingly lower TCO than composite architectures with separate caching layer technologies as proposed by other vendors.

InterSystems IRIS Interoperability

InterSystems IRIS provides a complete set of native integration and interoperability features. It provides out-of-the-box connectivity and data transformations for a wide range of packaged applications, databases, industry standards, protocols, and technologies. Flexible data transformation capabilities enable InterSystems IRIS to resolve differences in semantics and data schemas that exist between applications or services.
Application developers can create seamless business processes that connect with internal and external data sources, applications, and services.

InterSystems IRIS provides graphical tooling to visually diagram processes, rules, and workflows, allowing developers to focus on the logical interactions between systems, minimizing concerns about application interfaces, adapters, or middleware mechanisms.

The embedded role-based workflow engine supports manual interactions in business processes, automating the distribution of tasks among users and incorporating their decisions and actions.

InterSystems IRIS Analytics capabilities
InterSystems IRIS also provides an Open Analytics Platform, built around its universal, high-performance data store and offering data analysts, data scientists and data engineers an opportunity to run their analytic workflows in a straightforward, coordinated and efficient fashion.
An Open Analytics Platform is one that allows partners and end-users to build solutions and services that leverage best-of-breed analytics technologies, both embedded in the platform and complementary to it. It is not a point-and-click solution, but a polyglot platform offering data services and interoperability with multiple, proven analytics technologies.

An Open Analytics Platform implies Data Integration, Data Preparation and Data Science capabilities, each of them maximizing resource utilization vertically as well as horizontally.
InterSystems IRIS' embedded analytics capabilities include a high-performance multidimensional query engine for BI-style analytics and a unique NLP technology for identifying concepts and their context in natural language text.

Next to fast SQL and xDBC drivers for access by third-party tools, it supports relevant standards and technologies including PMML, UIMA and Apache Spark InterSystems IntegratedML is an all-SQL machine learning (ML) module for InterSystems IRIS or IRIS for Health that:
- Gives users the ability to create, train and deploy powerful models from simple SQL syntax without requiring data scientists.
- Wraps "best of breed" open source and proprietary "AutoML" frameworks including DataRobot.
- Focuses on easy deployment to IRIS, so you can easily add machine learning to your applications.

Features

  • API
  • Batch Permissions & Access
  • Data Export
  • Data Import
  • External Integrations
  • File Sharing
  • File Transfer
  • Multi-User
  • Notifications
  • Third-Party Plugins/Add-Ons

Features

  • API
  • Batch Permissions & Access
  • Data Export
  • Data Import
  • External Integrations
  • File Sharing
  • File Transfer
  • Multi-User
  • Notifications
  • Third-Party Plugins/Add-Ons

Features

  • API
  • Batch Permissions & Access
  • Data Export
  • Data Import
  • External Integrations
  • File Sharing
  • File Transfer
  • Multi-User
  • Notifications
  • Third-Party Plugins/Add-Ons

Summary

  • ODBC 3.52 compliant driver

  • Direct connection to data source without client software

  • Full compliance with ODBC API and data types

  • Compatibility with the latest server versions

  • Verified compatibility with multiple BI and ETL tools

Summary

    No key features associated with this application.

Summary

    No key features associated with this application.

Pricing

Desktop Perpetual

$349.95
1 user(s) / year
Included in plan:
  • Secure and risk-free purchase

FAQs

    No FAQs associated with this application.

FAQs

    What is this service generally used for?
  • The CData Excel Add-Ins simplify the way you read, write, and update live data from web and desktop applications. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!

  • Who are the main user groups of this service?
  • Organizations, Enterprises

FAQs

    Does this service offer multi-user capability (e.g. teams)?
  • Yes

  • Does this service offer guides, tutorials and or customer support?
  • Yes

  • Does this service integrate with any other apps?
  • Yes, Docker

Vendor Information

Founded:
-
Based in:
-
Employees:
-
Likes:
Followers:

Vendor Information

Founded:
-
Based in:
-
Employees:
-
Likes:
Followers:
1.83k

Vendor Information

Founded:
-
Based in:
-
Employees:
-
Likes:
Followers:
69.3k

Other

Who uses ODBC Driver for Oracle
  • Personal
  • Freelance
  • Startups
  • SMEs
  • Agencies
  • Enterprises
Desktop Platforms:
  • Windows
Languages:
English
Regional Restrictions:
No restrictions.

Other

Who uses CData Excel Add-Ins
  • Startups
  • SMEs
  • Agencies
  • Enterprises
Desktop Platforms:
  • Windows
  • Macintosh
Languages:
English
Regional Restrictions:
No restrictions.

Other

Who uses InterSystems IRIS
  • Startups
  • Enterprises
Desktop Platforms:
  • Web App
  • Windows
  • Macintosh
Languages:
Czech, German, English, French, Italian, Japanese, Russian, Spanish, Ukrainian
Regional Restrictions:
No restrictions.
Back to top