HgIS

Správa a analýza dat o životním prostředí
Environmental data management and analysis

User Tools

Site Tools


en:tools

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:tools [2020-06-24]
Kamil Nešetřil [Pentaho platform]
en:tools [2020-06-24] (current)
Line 14: Line 14:
   * [[cs:​cheatsheet|{{ :​spoon.png?​nolink|PDI cheat sheet}}]][[http://​community.pentaho.com/​projects/​data-integration|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://​wiki.pentaho.com/​display/​EAI/​Pentaho+Data+Integration+Steps|transformations]] and [[https://​wiki.pentaho.com/​display/​EAI/​Pentaho+Data+Integration+Job+Entries|jobs]]. Geospatial data can be handled with [[https://​github.com/​atolcd/​pentaho-gis-plugins|PDI GIS Plugins]]. See more info in [[en:​cheatsheet|]].   * [[cs:​cheatsheet|{{ :​spoon.png?​nolink|PDI cheat sheet}}]][[http://​community.pentaho.com/​projects/​data-integration|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://​wiki.pentaho.com/​display/​EAI/​Pentaho+Data+Integration+Steps|transformations]] and [[https://​wiki.pentaho.com/​display/​EAI/​Pentaho+Data+Integration+Job+Entries|jobs]]. Geospatial data can be handled with [[https://​github.com/​atolcd/​pentaho-gis-plugins|PDI GIS Plugins]]. See more info in [[en:​cheatsheet|]].
  
-  * [[https://​community.hitachivantara.com/​s/​article/​pentaho-reporting|Pentaho Report Designer]] ({{:​profil_prd.png?​linkonly|screenshot}}). \\ [[https://​www.metabase.com/​|{{ :​metabase.png?​nolink&​50|}}]] Development of Pentaho Reporting does not move forward so it makes sense to use some alternatvie ​as [[https://​www.metabase.com/​|Metabase]] – easy to use data analytics. FOSS alternatives in Python are [[https://​github.com/​apache/​incubator-superset/​blob/​master/​README.md|Superset]] or even [[https://​redash.io/​|Redash]]. \\ \\+  * [[https://​community.hitachivantara.com/​s/​article/​pentaho-reporting|Pentaho Report Designer]] ({{:​profil_prd.png?​linkonly|screenshot}}). \\ [[https://​www.metabase.com/​|{{ :​metabase.png?​nolink&​50|}}]] Development of Pentaho Reporting does not move forward so it makes sense to use an alternative ​as [[https://​www.metabase.com/​|Metabase]] – easy to use data analytics. FOSS alternatives in Python are [[https://​github.com/​apache/​incubator-superset/​blob/​master/​README.md|Superset]] or even [[https://​redash.io/​|Redash]]. \\ \\
   * [[http://​community.pentaho.com|Pentaho Server]] (<​nowiki>​PBA</​nowiki>,​ formerly BI Server, {{:​prubeh_server.png?​linkonly| screenshot}}) is a key component of the platform. Dashboards can be executed here. Dashboard can be designed by CDE – more: [[https://​help.pentaho.com/​Documentation/​9.0/​Products/​CTools|Community Tools (CTools)]].\\ \\    * [[http://​community.pentaho.com|Pentaho Server]] (<​nowiki>​PBA</​nowiki>,​ formerly BI Server, {{:​prubeh_server.png?​linkonly| screenshot}}) is a key component of the platform. Dashboards can be executed here. Dashboard can be designed by CDE – more: [[https://​help.pentaho.com/​Documentation/​9.0/​Products/​CTools|Community Tools (CTools)]].\\ \\ 
   * [[https://​help.pentaho.com/​Documentation/​9.0/​Products/​Pentaho_Metadata_Editor|Pentaho Metadata Editor]] – creates an abstract data layer. See a figure: \\ {{https://​help.pentaho.com/​@api/​deki/​files/​8143/​01_metadata_domain.png}} \\ \\    * [[https://​help.pentaho.com/​Documentation/​9.0/​Products/​Pentaho_Metadata_Editor|Pentaho Metadata Editor]] – creates an abstract data layer. See a figure: \\ {{https://​help.pentaho.com/​@api/​deki/​files/​8143/​01_metadata_domain.png}} \\ \\ 
en/tools.txt · Last modified: 2020-06-24