Transcript Architecture Overview

Building a PPT from the
ActiveInterface web pages
>>
Chris Harrington
Active Interface, Inc.
Welcome
Active Interface, Inc. builds web applications and information portals for both
established companies and for Internet startups. We also provide customization
and integration services across the entire Microsoft Windows product line. Our
client list includes:
• Marconi Technical Education
• CIBC World Markets
• Cellomics
• Marshall Marketing & Communications
• AccuWeather
• Cancellation.com
• MortgageRamp
• SalesGene
Contact Info:
Phone: 412-901-1184
Fax: 412-799-0927
Email: mailto:[email protected]
PowerPoint Automation Toolkit
The PowerPoint Automation Toolkit facilitates the automated generation of
PowerPoint presentation from structured and unstructured data sources. The
different modules which comprise the Toolkit include:
• Presentation optimizer: Reduces size of presentations by optimizing graphics.
Can achieve 100 to 1 compression factor. Helps control PowerPoint bloat and
reduce download size and bandwidth usage.
• Presentation decomposer: Decomposes a presentation into component slides
and graphics. Slides are placed in a repository along with slide metadata, where
they can be used to create new presentations (see Generators below)
• Presentation generator (desktop): A desktop PowerPoint generator.
• Presentation generator (server): A web server based PowerPoint generator
The presentation generator builds presentations which can include static slides
and dynamic slides. Dynamic slides can contain charts or graphics whose features
are based upon queries to SQL Server or Analysis Services.
ExcelETL: Desktop ETL with Excel
Excel ETL is a Microsoft Excel-based desktop ETL solution. In several of our
project, we have had the need to take data received in Excel or CSV format and
send this data to a data warehouse staging database. Excel ETL is a generic
framework for accomplishing this task.
Several modules comprise Excel ETL
•An XML configuration file which captures the requirements of the data staging
process
•An Excel add-in with which the user interacts
•A staging database generator
•A web service middle tier
These modules combined allow a user to
•Manually or automatically map Excel columns to database fields
•Validate the sheet against the constraints of the database
•Cleans and conform strings and flags
•Upload the sheet to the staging database
News and Noteworthy
September 28-October 1, 2004
Attended and presented at SQLPASS 2004 Community Summit. See my
presentation
November 1, 2004
Relauch of company site and ThinOLAP blog
November 8, 2004
Launch of East Liberty Development web site - constructed with ThinCMS