XML to XHTML rendition and stylesheets via XSL•FO by RenderX - author of XML to PDF formatter. Originally used stylesheets by P.Mansfield.

Going From Disparate Data to BI

Keywords: XML, data interchange, legacy data conversion, content conversion, BI, report mining

Abstract

The proliferation of useful enterprise applications presents an unintended consequence - the generation of corporate data that can be revisited for operational insight if managed, stored, integrated, filtered and distributed intelligently. And while these applications generate data in different silos, technologies including ODBC, OLE DB, XML and RSS enable enterprises to make the leap from simple, stratified content management to corporate business intelligence.

However, getting from data generation to BI is complicated by myriad data formats, the sheer amounts of data involved, data integrity, and the poor state of application integration. Data ETL (Extraction, Transformation and Loading) is a critical first step, enabling IT staff to grab only the data required from each application, transform it into the optimal final application format, and efficiently combine and load it into favored end-user applications that range from spreadsheets to multidimensional cubes to PDF files.

Ideally, ETL processes require no programming or otherwise laborious upfront process development, are able to be reused for different departmental applications, and can leverage the benefits of the increasingly popular XML and RSS technologies. Datawatch's Monarch Data Pump is the ideal ETL server for this scenario, and can automate many of these complex and ongoing processes.

This session will provide a best practices overview, and specific customer business intelligence case studies from healthcare, financial services, and government IT.

Table of Contents

1. Product Presentation Paper    
Biography

1. Product Presentation Paper

The author did not prepare a summary of this product presentation for the proceedings.

Biography

Phil Storey
Senior Sales Engineer
Datawatch Corp. [http://www.datawatch.com]
Lowell
Massachusetts
United States of America

Datawatch Senior Sales Engineer Philip Storey began working with SGML and XML applications more than 10 years ago. He was first exposed to these technologies in his capacity as Editorial Systems Manager at Grolier Encyclopedia, Inc. and then with enterprise publishing vendor Arbortext, Empolis, an information logistics company, and several consulting firms. At Datawatch, his primary technical responsibilities span XML generation, ETL (Extraction, Transformation and Loading), reporting and data mining applications, and he has worked on the front lines with customers in healthcare, financial services, and government. Storey has also worked as a school teacher and a newspaper reporter. He graduated from Florida State University and has a Master's degree from Wesleyan University.


XML to XHTML rendition and stylesheets via XSL•FO by RenderX - author of XML to PDF formatter. Originally used stylesheets by P.Mansfield.