xml web services: xml asset management using xml spy 4.2 and

1

XML Web Services: XML Asset Management Using

XML Spy 4.2 and TIBCO Canon/Developer Portal

Brand Niemann“XML Web Services Evangelist”

Data Standards BranchOctober 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.

2

Overview

• 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

Database• Appendix: MS SQL Server Installation for

Canon/Developer/Portal

3

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 Systems.

• .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 restrictions.

4

2. XML SPY 4.0 Suite

• Product Family• Training• Installations• License Manager• Help Files and Tutorials• Integrated Development Environment• Examples with EPA DTDs

5

Product Family• 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

6

Training• 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.

7

Installations

8

License Manager

9

On-Line Manual

10

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

tutorial.

11

Acrobat Tutorial

12

Document Editor Help Files

13

XSLT Designer Help Files

14

Integrated Development Environment

15

Examples with EPA DTDs

• Chemical Data Exchange Schema• Hazardous Waste Manifest Schema• IDEF (Logical Groups) Schema• Unregulated Contaminant Monitoring Rule

(UCMR)• State Drinking Water System (SDWIS Legal)• Superfund Electronic Data Deliverable (SEDD)• Electronic Discharge Monitoring Results (e-DMR)

16

3. TIBCO Canon/Developer/Portal

• Company Products and Services• Installations• Help Files• Sample Files• Turbo XML• Canon/Developer/Portal• Some EPA Uses

17

Company Products and Services• Extensibility.Com acquired by TIBCO Software,

Inc.:– Developer Tools:

• Turbo XML – suite that includes XML Authority, XML Instance, and XML Console.

– Server:• 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 assets.

– XML Directive:• Customizable training program of on-site, hands-on training in

XML best practices.

18

TIBCO Extensibility Framework

19

Installations

20

Installations

21

Installations

See Appendix for details of SQL server installation.

22

Help Files

23

Help Files

24

Sample Files

25

Turbo XML

26

Canon/Developer/Portal

27

Canon/Developer/Tomcat

28

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 button.

– 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.

29

Database Schema Example

30

Appendix: MS SQL Server Installation for Canon/Developer/Portal

• SQL Server Components and Database Server (2 screens).

• Installation Wizard Choices (9 screens).• Check that MSSQLSERVER is started (3

screens).• Command Line: Run Install (if necessary) (1

screen).• Configure Database (7 screens).

31

Select: SQL Server 2000 Components

32

Select: Install Database Server

33

Start: SQL Server Installation Wizard

34

Select: Local Computer

35

Select: Create a new instance of SQL Server, or install Client Tools

36

Enter: Name and Company

37

Select: Server and Client Tools

38

Select: Default Installation

39

Select: Typical or Minimum

40

Select: Auto Start SQL Server Service and Local System Account

41

Select: Mixed Mode and Check: Blank Password

42

Control Panel and Administrative Tools

43

Services

44

Start: MSSQLSERVER

45

Command Line: Run Install (if necessary)

46

Configure Database

47

Database Users

48

DB connection test successful

49

Configure XML Canon

50

Register XML Canon

Note: 50B4-34E0-3E83-2C8A is good forEPA evaluation until November 15, 2001.

51

Select: Yes

52

Configuration Progress