ASE102 Integrating Adaptive Server Enterprise with XMLBased Processes

1
ASE102 Integrating Adaptive Server Enterprise
with XML-Based Processes
Ale Gicqueau August 6, 2003
Business Development ManagerHiT Software
gicqueau_at_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)