Kamil Nešetřil

Environmental data management and analytics

User Tools

Site Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
en:tools [2023-10-04] Kamil Nešetřilen:tools [2024-03-21] (current) Kamil Nešetřil
Line 1: Line 1:
 ====== Tools ======= ====== Tools =======
-|[[https://help.hitachivantara.com/Documentation/Pentaho|{{:pentaho-logo.svg?nolink&150|Pentaho Platform – BI}}]]   [[cheatsheet|{{:spoon.png?nolink|Pentaho Data Integration (Kettle)}}]]   [[https://www.postgresql.org|{{:logo_postgres.svg?nolink&36|PostgreSQL – database}}]] [[https://dbeaver.io|{{:logo_dbeaver.svg?nolink&40|DBeaver – database manager}}]] + ([[https://www.r-project.org|{{:r_logo.svg?nolink&45|R – programming language}}]]  [[https://www.qgis.org|{{:qgis-icon32.svg?nolink&36|QGIS – geographical information system}}]] [[https://nextcloud.com/|{{:nextcloud.svg?nolink&60|Nextcloud – alternative to Dropbox, Google Drive or OneDrive}}]])|+|[[https://docs.hitachivantara.com/p/pentaho-dia|{{:pentaho-logo.svg?nolink&150|Pentaho Platform – BI}}]]   [[cheatsheet|{{:spoon.png?nolink|Pentaho Data Integration (Kettle)}}]]   [[https://www.postgresql.org|{{:logo_postgres.svg?nolink&36|PostgreSQL – database}}]] [[https://dbeaver.io|{{:logo_dbeaver.svg?nolink&40|DBeaver – database manager}}]] + ([[https://www.r-project.org|{{:r_logo.svg?nolink&45|R – programming language}}]]  [[https://www.qgis.org|{{:qgis-icon32.svg?nolink&36|QGIS – geographical information system}}]] [[https://nextcloud.com/|{{:nextcloud.svg?nolink&60|Nextcloud – alternative to Dropbox, Google Drive or OneDrive}}]])|
  
-HgIS applies BI tools ([[https://help.hitachivantara.com/Documentation/Pentaho|Pentaho platform]]) and GIS for the groundwater domain. Technologies and tools used in HgIS are listed here.+HgIS applies BI tools ([[https://docs.hitachivantara.com/p/pentaho-dia|Pentaho platform]]) and GIS for the groundwater domain. Technologies and tools used in HgIS are listed here.
  
 > [[https://hop.apache.org/|{{ :hop_logo.svg?nolink&40|Apache Hop}}]] :!: Since Hitachi acquired Pentaho, the development of the Pentaho platform has stagnated, and the platform's website is confusing. The original author of PDI (Matt Casters) created [[https://hop.apache.org/|Apache Hop]], a fork of PDI that finally has elegant architecture and is being intensively developed. PDI transformations can be imported into it. > [[https://hop.apache.org/|{{ :hop_logo.svg?nolink&40|Apache Hop}}]] :!: Since Hitachi acquired Pentaho, the development of the Pentaho platform has stagnated, and the platform's website is confusing. The original author of PDI (Matt Casters) created [[https://hop.apache.org/|Apache Hop]], a fork of PDI that finally has elegant architecture and is being intensively developed. PDI transformations can be imported into it.
  
-[[https://help.hitachivantara.com/Documentation/Pentaho|{{  :pentaho-logo.svg?nolink&150|Pentaho platform}}]]+[[https://docs.hitachivantara.com/p/pentaho-dia|{{  :pentaho-logo.svg?nolink&150|Pentaho platform}}]]
 ===== Pentaho platform ===== ===== Pentaho platform =====
-[[pentaho>https://help.hitachivantara.com/Documentation/Pentaho|Pentaho platform]] is a set of business intelligence tools.\\+[[pentaho>https://docs.hitachivantara.com/p/pentaho-dia|Pentaho platform]] is a set of business intelligence tools.\\
  
 {{:pba-architecture.jpg?nolink |Pentaho Platform components and typical deployment}} {{:pba-architecture.jpg?nolink |Pentaho Platform components and typical deployment}}
  
-It contains the following components ([[download>https://www.hitachivantara.com/en-us/products/dataops-software/data-integration-analytics/pentaho-community-edition.html|download]]):+It contains the following components ([[download>https://www.hitachivantara.com/pentaho/pentaho-plus-platform/data-integration-analytics/pentaho-community-edition.html|download]]):
  
   * [[cheatsheet|{{ :spoon.png?nolink|PDI cheat sheet}}]][[https://www.hitachivantara.com/en-us/products/dataops-software/data-integration-analytics/pentaho-community-edition.html|Pentaho Data Integration]] (<nowiki>PDI</nowiki>, also known as Kettle)((Acronym means: //Kettle Extraction, Transformation, Transportation and Loading Environment//.)) It is an [[wp>Extract,_transform,_load|ETL]] tool. It can read data from diverse databases, resources (e-mail, local computer, FTP, HTTP), and files (MS Excel, MS Access, [[wp>Comma-separated values|CSV]], TXT, [[wp>Shapefile|ESRI SHP]], [[wp>XML]], [[wp>JSON]], [[wp>YAML]], [[wp>RSS]], [[wp>XBase]], or ZIP).  Official resource lists all steps of [[https://help.hitachivantara.com/Documentation/Pentaho/9.4/Products/Transformation_step_reference|transformations]] and [[https://help.hitachivantara.com/Documentation/Pentaho/9.4/Products/Job_entry_reference|jobs]]. Geospatial data can be handled with [[git>atolcd/pentaho-gis-plugins|PDI GIS Plugins]]. See more info in [[cheatsheet|]].   * [[cheatsheet|{{ :spoon.png?nolink|PDI cheat sheet}}]][[https://www.hitachivantara.com/en-us/products/dataops-software/data-integration-analytics/pentaho-community-edition.html|Pentaho Data Integration]] (<nowiki>PDI</nowiki>, also known as Kettle)((Acronym means: //Kettle Extraction, Transformation, Transportation and Loading Environment//.)) It is an [[wp>Extract,_transform,_load|ETL]] tool. It can read data from diverse databases, resources (e-mail, local computer, FTP, HTTP), and files (MS Excel, MS Access, [[wp>Comma-separated values|CSV]], TXT, [[wp>Shapefile|ESRI SHP]], [[wp>XML]], [[wp>JSON]], [[wp>YAML]], [[wp>RSS]], [[wp>XBase]], or ZIP).  Official resource lists all steps of [[https://help.hitachivantara.com/Documentation/Pentaho/9.4/Products/Transformation_step_reference|transformations]] and [[https://help.hitachivantara.com/Documentation/Pentaho/9.4/Products/Job_entry_reference|jobs]]. Geospatial data can be handled with [[git>atolcd/pentaho-gis-plugins|PDI GIS Plugins]]. See more info in [[cheatsheet|]].
Last modified: 2024-03-21