XML Web Services: XML Asset Management Using
XML Spy 4.2 and TIBCO Canon/Developer Portal
“XML Web Services Evangelist”
Data Standards Branch
October 1, 2001
Disclaimer: Any reference to or depiction of the commercial product of any
vendor is for illustrative purposes only and does not constitute an endorsement
by EPA or the trainer. 1
• 1. Internet Explorer 6.0 Support for XML
• 2. XML SPY 4.0 Suite
• 3. TIBCO Canon/Developer/Portal
• 4. Creation of An XML Schema from a
• Appendix: MS SQL Server Installation for
1. Internet Explorer 6.0 Support for XML
• XML: Includes support for Microsoft XML (MSXML) 3.0, providing better
performance and up-to-date XML standards support.
• Enhanced SMIL 2.0 Multimedia Support: Provides continued support for
the developing synchronized multimedia integration language (SMIL) 2.0 in
progress at the World-Wide Web Consortium (W3C), most notably in the area
of transitions, allowing the application of filters and effects, such as fading an
image, transitioning between text or media elements by using wipes, and
applying a graduated color background to an element, all at designated times,
without the need for script. Also supports the SVG Viewer from Adobe
• .NET Integration: As part of the WebService behavior, makes integration of
server and client side code easier, and enables applications to call functions on
the server asynchronously. You can use this behavior to avoid page
navigations and to retrieve data from the server using XML and SOAP.
• Full DOM Level 1 Support: Provides enhanced support for standards-based
applications and development of informative content for users. Fully
compliant with the W3C Document Object Model (DOM) Level 1, an
interface that allows programs and scripts to dynamically access and update
document content, structure, and style without platform or language
2. XML SPY 4.0 Suite
• Product Family
• License Manager
• Help Files and Tutorials
• Integrated Development Environment
• Examples with EPA DTDs
• Integrated Development Environment
– Powerful XML Editor
– XSLT Edit and Transform
– Graphical Schema Design
– Database Connectivity
• XSLT Designer
– Powerful Visual Design
– Schema-driven Process
– Create e-Forms
– Requires no prior XPath or XSLT Experience
• Document Editor & Browser Plug-In
– Freeflow WYSIWYG Editing
– Word-processor Like
– e-Forms Data Entry
– Real-time Validation
• XML Spy BootCamp
– Developed by the Richard Hale Shaw Group
(RichardHaleShawGroup.com -- creators of the XMLBootCamp,
UMLBootCamp and other BootCamp-style, training courses for software
developers on COM, ASP, UML and .NET), XMLSpyBootCamp is a 5-
day, hands-on intense immersion in learning XML using XML Spy 4.0.
Starting with XML fundamentals and mark-up, and moving quickly to
style-sheets (XSL and XSLT using the XSLT Designer in XML Spy) and
validation (DTDs and Schemas, plus the XML Spy Schema Editor and IE
plug-in), the course covers both the DOM and the SAX parser, as well as
server-side XML and SOAP. Taught in a rigorous, hands-on fashion by
professionals such as Josh Holmes (who wrote the XML Spy BootCamp
course and who teaches the XMLBootCamp), you'll complete this class
knowing exactly how to utilize the latest features of XML Spy 4.0 for
building a variety of applications using XML. This course will be taught
publicly, starting in late October, 2001, and is available as on-site training
as well. For details see XMLSPYBOOTCAMP.com.
Online Manual Tutorial
• Overview of the interface.
• Create a Schema from scratch.
• Making Schema components reusable.
• Generating Schema documentation.
• Creating an XML document.
• XSL transformation.
• Importing and exporting database data.
• Creating a database schema.
• Creating a project.
Note: The 2-day GPO Class does hands-on with this
Document Editor Help Files
XSLT Designer Help Files
Integrated Development Environment
Examples with EPA DTDs
• Chemical Data Exchange Schema
• Hazardous Waste Manifest Schema
• IDEF (Logical Groups) Schema
• Unregulated Contaminant Monitoring Rule
• State Drinking Water System (SDWIS Legal)
• Superfund Electronic Data Deliverable (SEDD)
• Electronic Discharge Monitoring Results (e-DMR)
3. TIBCO Canon/Developer/Portal
• Company Products and Services
• Help Files
• Sample Files
• Turbo XML
• Some EPA Uses
Company Products and Services
• Extensibility.Com acquired by TIBCO Software,
– Developer Tools:
• Turbo XML – suite that includes XML Authority, XML
Instance, and XML Console.
• Canon/Developer – registry for collaborative
development/deployment of XML assets and vocabularies
within the enterprise and its trading partners.
• Canon/Portal – Web-based publishing and dissemination of
– XML Directive:
• Customizable training program of on-site, hands-on training in
XML best practices.
TIBCO Extensibility Framework
See Appendix for details of SQL server installation.
4. Creation of An XML Schema from a Database
• XML Spy 4.0 Tutorial:
– Menu option: Convert, Create Database Schema, select
Microsoft Access database, click Choose file button,
Select DB2schema.mdb, click Open button, click Okay
– Explore the Schema design view
– Menu option: File, Save as, DB2schema.xsd
• Note: Currently only MS Access databases are
able to automatically provide the “key” and
“keyref” information used to create the databases
hierarchy. All other databases currently create a
flat structured schema.
Database Schema Example
Appendix: MS SQL Server Installation
• SQL Server Components and Database Server (2
• Installation Wizard Choices (9 screens).
• Check that MSSQLSERVER is started (3
• Command Line: Run Install (if necessary) (1
• Configure Database (7 screens).
Select: SQL Server 2000 Components
Select: Install Database Server
Start: SQL Server Installation Wizard
Select: Local Computer
Select: Create a new instance of SQL
Server, or install Client Tools
Enter: Name and Company
Select: Server and Client Tools
Select: Default Installation
Select: Typical or Minimum
Select: Auto Start SQL Server
Service and Local System Account
Select: Mixed Mode and Check:
Control Panel and Administrative Tools
Command Line: Run Install
DB connection test successful
Configure XML Canon
Register XML Canon
Note: 50B4-34E0-3E83-2C8A is good for
EPA evaluation until November 15, 2001.