项目作者: it4biz

项目描述 :
PDI Operations Data Mart CE
高级语言:
项目地址: git://github.com/it4biz/pdi-odm-ce.git
创建时间: 2014-11-26T13:28:05Z
项目社区:https://github.com/it4biz/pdi-odm-ce

开源协议:

下载


PDI ODM CE

======================

PDI Operations Mart CE is a free and open source projetc.

It is available under the terms of the Apache License Version 2.

Version: 1.2

License: Apache License Version 2

How to install:

1) Open pgAdmin3 and create a database called pdi_odm_ce;

  1. CREATE DATABASE pdi_odm_ce;

2) Run the DDL Script ddls-pdi-odm-ce.sql on pgAdmin3 to create the logs schema and all the tables;

3) Edit your kettle.properties file (/Users/caiomsouza/.kettle/kettle.properties) and add the lines below:

  1. PDI_ODM_CE_HOST=localhost <BR>
  2. PDI_ODM_CE_DATABASE=pdi_odm_ce <BR>
  3. PDI_ODM_CE_PORT=5432<BR>
  4. PDI_ODM_CE_USERNAME=YOUR_USER<BR>
  5. PDI_ODM_CE_PASSWORD=YOUR_PASSWORD<BR>
  6. LOG_CONNECTION=pdi_odm_ce<BR>
  7. LOG_SCHEMA=logs<BR>
  8. LOG_T=log_transformation<BR>
  9. LOG_S=log_step<BR>
  10. LOG_P=log_performance<BR>
  11. LOG_LC=log_logging_channels<BR>
  12. LOG_M=log_metrics<BR>

Windows:

C:\Documents and Settings\.kettle\kettle.properties

Linux:

/Users//.kettle/kettle.properties

(See https://github.com/it4biz/pdi-odm-ce/blob/master/kettle.properties)

4) Put the file pdi_odm_ce.kdb (DB Connection) on your Kettle file repository and change the variables PDI_ODM_CE_USERNAME and PDI_ODM_CE_PASSWORD

5) Open the example transformation (t_it4biz_standard_transformation_with_log_enable.ktr) and run it.

6) Go to pgAdmin3 and see the results on the tables:

  1. logs.log_transformation<BR>
  2. logs.log_step<BR>
  3. logs.log_performance<BR>
  4. logs.log_logging_channels<BR>
  5. logs.log_metrics<BR>

7) Fork it and make your own contribution.

We need help to create a Data mart, an OLAP Mondrian Schema Cube and some Reports/Dashboards to help to visualize the logs data in a better way than SQL Queries.

To learn more about this subjetc:

http://infocenter.pentaho.com/help48/index.jsp?topic=%2Fpdi_admin_guide%2Fconcept_pdi_operations_mart.html

Contributions:

5 (five) PRD Reports - Fabio de Salles fabio.salles@globo.com - 11/Dec/2014