ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes

1. ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes Ale Gicqueau August 6, 2003 Business Development ManagerHiT Software gicqueau@hitsw.com / (408) 345 4009

2. Agenda ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Why integrate XML with Sybase ASE? • Sybase ASE XML native support • The XML-RDB Integration Problem • The solution: Sybase ASE with jAllora • Demo • Exchanging XML data with Sybase ASE sample database: pubs2

3. Why integrate XML with Sybase ASE? ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • XML: the standard for data exchange • License-free and open standard • Text-based, platform independent • Self-describing nature to represent information and its structure • Consolidate and make data available for use with all tools and applications • A2A: exchange data between applications • B2B: automate business processes with partners • XML at the core of Sybase Information Liquidity • move data fluidly throughout the corporate infrastructure, regardless of the data type, the platform, the database, the application, or the vendor • Sybase is the enterprise software company that bridges all technology platforms

4. The XML-RDB Integration Challenges ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Sybase was the first relational database vendor to provide a full-featured XML native database to its customers • Support for Native XML storage • Support for Native XML Indexes • Support XML Search and Querying • XML data type • XPath • XQuery • However, in many instances, the XML document data needs to be decomposed into relational database table columns in order to leverage SQL, business intelligence, and reporting tools. Sybase recommends HiT Software jAllora for such XML-to-RDB transformation

5. The XML-RDB Integration Challenges ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Challenge 1: Hierarchical XML vs. Relational Structure • XML • Tree structure: nodes, elements & attributes • DTD/XML schema defines XML document structure: from loose to rigid hierarchical format • RDBMS • Table structure linked together by key fields relationships • Catalog defined rigid distributed data relationships • Normalization: primary & foreign keys • How does one dynamically transform data between these two structures? • Custom mapping, XML & SQL programming or use jAllora

6. The XML-RDB Integration Challenges ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Challenge 2: Maintaining referential integrity • Challenge 3: Dealing with evolving XML schemas and DTDs, and RDB changes • Challenge 4: Multiple version databases • Challenge 5: Portability • Challenge 6: Maintenance • Challenge 7: Learning curve of low-level programming interfaces: XML parsing, XSLT • Challenge 8: Reliability, scalability, high-performance

7. The solution: Sybase ASE with jAllora ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Cut Development Time • Graphical mapper/nested XML support (challenge 1) • Automatic metadata retrieval (challenge 2) • Easier maintenance: XSD or RDB changes (challenge 3) • ANSI SQL/database connectivity standards: ODBC, OLEDB, JDBC (challenge 4) • Java & Windows COM run-time (challenge 5) • No application XML parsing or XSLT programming (challenge 6) • Wizards /product integration(challenge 7) • Industrial quality middleware(Challenge 8) • First released in 2000, current release v3.1 • Focused on common XML-RDB transformation requirements • Flexible APIs • Reliability • Scalability • High-performance • Leverage existing security infrastructure • Optimized for Sybase ASE • jAllora fine-tuned to deliver high-performance processing with Sybase ASE • Support Sybase database expressions and data types

8. Lower your total cost of ownership with jAllora ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes Total cost of ownership of XML-to-ASE interfaces ($) Manual coding Impossible! Single table mapping Multiple tables Multiple XML schemas jAllora More complex XML schemas Multiple XML message types More complex relation database

9. jAllora based solution architecture ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes jAllora automates ASE XML processes Design-time jAllora Mapper XML mapping file Trading Partner or App ASE XML or jAllora XML transformation engine Sybase ASE e.g pubs2 Table1 Field 1 Field 2 … Table 2 Field 1 … jAllora transformation engine (in yellow) is a middleware component that makes ASE speak XML. No knowledge of SQL, XML parsing or XSLT is necessary. Read-only or Read-Write SQL Database Request JDBC

10. Sybase ASE/jAllora demo ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Creating XML orders from pubs2 (marshal) • Defining table relations and predicates • XML structure • Scripting • Importing XML orders into pubs2 (unmarshal) • Unmarshal properties • Defining the field values update selection • XML predicates • Setting the isolation level • Exposing your ASE data as a web service • Query data from anywhere on the Internet with maximum security and flexibility

11. An example with Sybase pubs2 sample database ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Pubs2 • eight tables: publishers, authors, titles, titleauthor, roysched, sales, stores, and discounts • The publishers table contains the identification numbers, names, cities, and states of three publishing companies. • The authors table contains the identification number, first and last name, address information, and contract status for each author. • The titles table contains its identification number, name, type, identification number of the publisher, price, advance, royalty, year-to-date sales, comments, and publication date. • The titleauthor table links the titles and authors table together. For each book, it contains the title ID, the author ID, the author order, and the royalty split among the authors of a book. • The roysched table lists the unit sales ranges and the royalty connected with each range. The royalty is some percentage of the net receipts from sales. • The sales table records sales of the titles in the titles table. • The stores table lists bookstores by store id. • The discounts table lists three types of discounts for bookstores.

12. jAllora Mapper ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes

13. Problem: creating XML data from pubs2 ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Use or build the XML schema corresponding to your business logic • Use a standard (XML.org) • Build it from your database with jAllora (according to existing defined table relations) • Use jAllora mapper to define the XML-to-ASE relations • Drag-and-drop mapper • Table relations, predicates • Advanced features: XML structure, scripting • jAllora XML mapping file • Automate XML-to-ASE transformation with jAllora APIs • High-performance • Support for Web Services • Support for XQuery (XPath implementation)

14. Conclusion ASE102 Integrating Adaptive Server Enterprise with XML-Based Processes • Sybase ASE leads the RDBMS race with XML • XML native features (XML data type, XML database, XQuery) • XML-to-RDB with jAllora • Web Services support • Compare all RDBMS XML support (White paper on sybase.com) • Self-Management • Control & flexibility with jAllora mapper • Full automation control with jAllora APIs • Lower total cost of ownership • Sybase ASE adopts XML so that information can flow seamlessly between platforms, databases and applications: information liquidity • Open standards means lower TCO • jAllora can be downloaded on Sybase website • (full-text search on jAllora)