HgIS combines BI tools (Pentaho platform) and GIS. Technologies and tools used in HgIS are listed here.

Pentaho platform is a set of business intelligence tools.
It contains following components:

• Pentaho Data Integration (PDI, also known as Kettle)¹⁾ It is an ETL tool. It can read data from diverse databases, resources (e-mail, local computer, FTP, HTTP) and files (MS Excel, MS Access, CSV, TXT, ESRI SHP, XML, JSON, YAML, RSS, XBase or ZIP). Official resource lists all steps of transformations and jobs.

• Pentaho Report Designer (screenshot). Designed reports can be run (displayed) on Pentaho Business Analytics Platform.
  
  
• Pentaho Business Analytics Platform (PBA, formerly BI Server, screenshot) is a key component of the platform.
  
  
• Pentaho Metadata Editor – creates an abstract data layer. See a figure:
  
  
  

Machine Intelligence (blog post) utilizes engines: R, Python, Weka or Deeplearning4j (Java with GPU Nvidia).

Adaptive Execution Layer (AEL) runs transformations not only locally or on the Pentaho Server, but also on Spark. Dále Pentaho supports also cloud platforms like Amazon Web Services, Google Cloud Platform or Microsoft Azure (Cloud agnostic analytic pipeline). Alternative to AEL is Apache Beam.

• Java – programming language
• Apache Tomcat – web server
• JDBC – API for access to relational databases
• JNDI
• Jackrabbit: implementation of the Content repository API for Java
• Common Warehouse Metamodel – used in Pentaho Metadata – specification

• PostgreSQL is a database server we use. (PostgreSQL).
• We use DBeaver and pgAdmin for the database administration.
• PostGIS is a spatial extension to PostgreSQL database (PostGIS).

• QGIS – desktop GIS
• QGIS Server – map server
• EnviroInsite – advanced hydrogeological visualization. The company developing EI was acquired by the corporation developing EQuIS (EarthSoft). It does not plan to develop the standalone EI.²⁾ Therefore we plan to replace EI probably by QGIS with the Midvatten or FREEWAT plugin.

For detailed information go to the Czech version of this site.