Before installing the Denodo Platform, verify the following requirements.
The Denodo Platform runs on the following platforms:
- Windows: Windows Server 2016, Windows Server 2012, Windows Server 2008, Windows 10, Windows 8.1 and Windows 7.
- Linux: Ubuntu 12.04 LTS or later, CentOS 6.x and 7.x, Red Hat Enterprise Linux (RHEL) 6.x and 7.x, Oracle Linux 6.x and 7.x and SUSE Linux Enterprise 12.x.
For an updated list of the supported platforms, contact the Denodo Support Team.
Supported Java Runtime Environments (JRE)¶
The Java Runtime Environments (JRE) supported are:
- Java Runtime Environment version 8 of Oracle.
- AdoptOpenJDK version OpenJDK 8 HotSpot. AdoptOpenJDK provides reliable OpenJDK binaries for all platforms.
Denodo provides installers of the Denodo Platform for Windows and Linux that include the Oracle Java Runtime Environment.
If you are installing the Denodo Platform on an environment other than Windows or Linux, install a Java Runtime Environment version 1.8.
The Diagnostic & Monitoring Tool and the web administration tools are tested with Chrome 62.x, Internet Explorer 11, Microsoft Edge 41.x and Mozilla Firefox 57.x.
The Data Catalog is tested with Chrome 62.x, Microsoft Edge 41.x and Mozilla Firefox 57.x.
Besides these requirements, each module of the Denodo Platform has additional requirements that must be met in order to use some of their components:
Software Requirements for Virtual DataPort¶
This section lists the additional requirements of Virtual DataPort.
Microsoft Access Sources¶
To extract data from Microsoft Access files, install the Access ODBC drivers. To obtain them, do one of the following:
- Install Microsoft Office in the same machine as the Virtual DataPort Server
- Or, install the Microsoft Access Database Engine 2010 Redistributable
Virtual DataPort incorporates a cache module that stores local copies of the data retrieved from the data sources, in a JDBC database. This may reduce the impact of repeated queries hitting the data source and speed up data retrieval, especially with certain type of sources.
To be able to cache data, you need to do the following:
- Obtain access to a Database Management Systems (DBMSs).
- Create a schema on this database. Denodo will use it to store the cached data. Although Denodo can use a schema used by other applications, we recommend creating a new one so the objects created by Denodo do not conflict with the ones created by other applications.
- Grant the following privileges to the user account that Denodo will use
to connect to this database:
- Privileges to create and drop tables on this schema.
- Privileges to execute
DELETEstatements on these tables.
Virtual DataPort embeds an Apache Derby database that can be used to store the cache data. However, we strongly advise against using it on a production environment. This database is provided just for demoing and development purposes.
The section Cache Module of the Administration Guide explains how the cache module works and lists the DBMSs that Virtual DataPort can use to store the cached data.
Software Requirements for ITPilot¶
This section lists the additional requirements of ITPilot:
- To use the Browser Pool, install Microsoft Internet Explorer 10.x or 11.x.
- To extract data from PDF files using the Adobe PDF engine, ITPilot has to run on Windows and requires Adobe Acrobat Professional 9 or 10.
- To extract data from Microsoft Word files, install Apache OpenOffice 4.0.x or 4.1.x.
- The Verification Server uses a relational database to store information about wrappers execution to allow verifying its correct operation. ITPilot provides an embedded Apache Derby database that can be used for this purpose. An external JDBC database management system can also be used. This feature has been tested with the MySQL Database and the Oracle Database. ITPilot provides a script to create tables for these DB Management Systems (consult the post-installation tasks for more details about these scripts).