Managing External Breeze Reports
Trademarks
1 Step RoboPDF, ActiveEdit, ActiveTest, Authorware, Blue Sky Software, Blue Sky, Breeze, Breezo, Captivate, Central,
ColdFusion, Contribute, Database Explorer, Director, Dreamweaver, Fireworks, Flash, FlashCast, FlashHelp, Flash Lite,
FlashPaper, Flash Video Encoder, Flex, Flex Builder, Fontographer, FreeHand, Generator, HomeSite, JRun, MacRecorder,
Macromedia, MXML, RoboEngine, RoboHelp, RoboInfo, RoboPDF, Roundtrip, Roundtrip HTML, Shockwave, SoundEdit,
Studio MX, UltraDev, and WebHelp are either registered trademarks or trademarks of Adobe Systems Incorporated and may be
registered in the United States or in other jurisdictions including internationally. Other product names, logos, designs, titles,
words, or phrases mentioned within this publication may be trademarks, service marks, or trade names of Adobe Systems
Incorporated or other entities and may be registered in certain jurisdictions including internationally.
Third-Party Information
This guide contains links to third-party websites that are not under the control of Adobe Systems Incorporated, and Adobe
Systems Incorporated is not responsible for the content on any linked site. If you access a third-party website mentioned in this
guide, then you do so at your own risk. Adobe Systems Incorporated provides these links only as a convenience, and the inclusion
of the link does not imply that Adobe Systems Incorporated endorses or accepts any responsibility for the content on those thirdparty sites.
© 2006 Adobe Systems Incorporated. All rights reserved. This manual may not be copied, photocopied, reproduced,
translated, or converted to any electronic or machine-readable form in whole or in part without written approval from
Adobe Systems Incorporated. Notwithstanding the foregoing, the owner or authorized user of a valid copy of the software
with which this manual was provided may print out one copy of this manual from an electronic version of this manual for
the sole purpose of such owner or authorized user learning to use such software, provided that no part of this manual may
be printed out, reproduced, distributed, resold, or transmitted for any other purposes, including, without limitation,
commercial purposes, such as selling copies of this documentation or providing paid-for support services.
Acknowledgments
Editorial Manager: Stephanie Gowin
Writing: Jody Bleyle
Editing: Mary Ferguson
Production Management: Adam Barnett
Media Design and Production: Adam Barnett and John Francis
Second Edition: January 2006
Adobe Systems Incorporated
601 Townsend St.
San Francisco, CA 94103
Contents
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Intended audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
What’s new in external Breeze reports . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Guide to documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Additional resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6
Contact us . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6
Chapter 1: Understanding Breeze Reports. . . . . . . . . . . . . . . . . . . . 7
The Breeze database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
About stored data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
About reports. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Chapter 2: Using Breeze Reporting Views . . . . . . . . . . . . . . . . . . . 9
Database schema views used in reporting . . . . . . . . . . . . . . . . . . . . . . . . .9
Database views and data relationships . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Unique identifiers and data relationships . . . . . . . . . . . . . . . . . . . . . . . .11
EXT_TRANSACTIONS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11
EXT_TRANSACTION_DETAILS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
EXT_TRANSACTIONS_VIEWS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
EXT_USERS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
EXT_USER_FIELDS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
EXT_USER_GROUPS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
EXT_OBJECTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
3
4Contents
Introduction
Macromedia Breeze supports external reporting through a collection of read-only database
views. These database views allow you to develop a wide variety of customized reports for use
throughout your enterprise.
Intended audience
This document is for licensed Breeze customers who want to develop customized reports
based on Breeze data.
What’s new in external Breeze reports
In Macromedia Breeze 5.1, the reporting views have been created in the database.
(In Breeze 4.1, you had to create the reporting views and install them on Breeze
Communication Server.)
Guide to documentation
In addition to this manual, the following electronic manuals and online help systems are
available from the Breeze Documentation Center to help you learn about Breeze:
■ Breeze Manager User Guide describes how to use the administration, presentation, and
meeting applications of Breeze. You can access this guide from the Breeze Manager home
page, and from the Help link in Breeze Manager.
■ Breeze Presenter User Guide describes how to create Breeze presentations using PowerPoint
and publish them to Breeze. You can access this document from the Breeze Manager home
page, or from the Breeze menu in PowerPoint by selecting Breeze > Help.
5
■ Breeze Meeting User Guide for Hosts and Presenters includes information about using the
Breeze web application to host online real-time meetings. The documentation includes
procedures that demonstrate the simplicity of adding slides, Flash SWF files, images, and
live audio and video to your presentation. You can access this guide from the Breeze
Manager home page, or from the Help menu within a Breeze meeting room (when you
enter as a Presenter) by selecting Meeting > Help.
■ Breeze Meeting User Guide for Participants includes information relevant to users
participating in an online real-time meeting. Breeze Meeting offers meeting participants a
variety of options to make their experience truly participatory, including the ability to
send messages and questions to Presenters and to each other, and the ability to participate
through live video and audio. You can access this guide from the Breeze Manager home
page, or from the Help menu within a Breeze meeting room (when you enter as a
Participant) by selecting Meeting > Help.
■ Breeze Integration Guide includes information necessary to make application programming
interface (API) calls on the Breeze server from your external system, such as a web
application. It also explains how to interpret the XML results that Breeze returns. In
addition, the documentation contains reference material about each API and its
parameters.
Additional resources
Additional documentation, white papers, and articles are available at the following websites:
Breeze Resource Center This site, at www.macromedia.com/resources/breeze, is updated
regularly with tutorials, simulations, best-practices information, and links to procedures.
Breeze Support Center This site, at www.macromedia.com/support/breeze, contains
current support information, including TechNotes, helpful Breeze presentations, and support
program details.
Contact us
For additional assistance, please contact Technical Support.
6Introduction