Transcript Upgrade SpagoBI - Talend Open Integration Solution

TDQ 5.1.0M2 – Upgrade SpagoBI
Talend, Global Leader in Open Source
Integration Solutions
Agenda
 Overview of Talend Data Quality Portal
 Upgrade SpagoBI TDQ-4614 Issue Works
 New Functions After Upgrade
 Demonstration
© Talend 2011
2
Overview of Talend Data Quality Portal

Overview
Talend Data Quality Portal uses the SpagoBI business-intelligenc e software in conjunction with
TDQ studio in order to monitor data quality metrics.
Talend Data Quality Portal presents data quality metrics in gr aphical forms based on the results
on analyses stored in the dedicated DQ data mart.

Main Functions







Reporting
Dashboard
Analytical Processing (OLAP)
Query By Example (QBE)
Key Performance Indicators (KPI)
Roles Control
Languages Support
© Talend 2011
3
Upgrade SpagoBI TDQ-4614 Issue Works

Update SpagoBI version from 2.6.0 to 3.3.0








SpagoBI-bin-2.6.0
SpagoBICommonJEngine-bin-2.6.0
SpagoBIConsoleEngine-bin-2.6.0
SpagoBIJasperReportEngine-bin-2.6.0
SpagoBIJPivotEngine-bin-2.6.0
SpagoBIQbeEngine-bin-2.6.0
to
to
to
to
to
to
SpagoBI-bin-3.3.0 (SpagoBI Server)
SpagoBICommonJEngine-bin-3.3.0
SpagoBIConsoleEngine-bin-3.3.0
SpagoBIJasperReportEngine-bin-3.3.0
SpagoBIJPivotEngine-bin-3.3.0
SpagoBIQbeEngine-bin-3.3.0
Update DB Scripts

mysql-dbscript-2.6.0
to
mysql-dbscript-3.3.0

oracle-dbscript-2.6.0
to
oracle-dbscript-3.3.0
Roles Configuration
© Talend 2011
4
New Functions After Upgrade

Compare Matrix
Major Functions
5.1.0M2
Earlier
Jasper 3
Jasper 4
Thresholds KPI
√
√
Audit indicators
√
√
JPivot Engine (OLAP)
√
√
QBE Engine
√
※
KPI Model Definition
√
※
WorkSheet Desginer
√
×
Online
Offline
√
×
Reporting
Domain & Configuration Management Tools
Metadata Creation in Spago Studio
© Talend 2011
5
Demonstration

Fast Review Basic Functions

The News Introduction

Samples
© Talend 2011
6
Thank you!
© Talend 2011
7