EP109 Leveraging ODBC, JDBC, and ADO to Integrate Sybase Data with XML

1. EP109Leveraging ODBC, JDBC, and ADO to Integrate Sybase Data with XML • John Goodson • MERANT - Vice President, R&D • Enterprise Data Connectivity • John.Goodson@merant.com

2. Overview/Goals Review ODBC, JDBC, ADO/OLE DB XML Introduction/Review Sybase/XML Usage Scenarios and Demos Persistence of Sybase data using XML Leveraging XML data off the Web Sharing Sybase data via B2B framework Agenda

3. Will XML replace ADO/OLE DB? Do I use XML in conjunction with or instead of JDBC? Aren’t there already standards-based technologies for accessing data, such as ODBC? What the heck is XML? XML Questions

4. A clear understanding of how XML fits with the existing data access standards Examine components and scenarios used to build Sybase & XML-enabled business-to-business infrastructure What We’ll Cover

5. Application Programming Interface for accessing tabular data using SQL Initially a Microsoft standard that evolved from the X/Open and ISO/IEC Call-Level Interface standards Cross platform Mature, Robust, Flexible Supported by thousands of applications ODBC

6. Application Programming Interface for accessing tabular data using SQL Tailored for Java Platform neutral Objected oriented Internet enabled features Java security/applets Disconnected rowsets JDBC

7. Microsoft ActiveX Data Objects (ADO) High level, object oriented API Windows only Abstraction level to OLE DB does NOT require SQL access Internet enabled features Disconnected rowsets XML persistence ADO

8. XML was built on a set of guidelines that parallel the best attributes of all the aforementioned technologies XML itself is not an API it’s a standard for markup languages I.e. You must write a program to do something with an XML document because a document doesn’t do anything inherently How Does XML Fit?

9. XML is a family of technologies - including APIs Document Object Model (DOM) Simple API for XML (SAX) These APIs access and manipulate XML documents - not backend databases like Sybase ASE XML

10. Corporate data will originate from the DBMS and packaged applications Use XML to interface/expose corporate data from Sybase ASE on the Web (intranet/extranet/internet) Be careful - avoid proprietary “XML” based products More XML

11. Corporate data is inside the firewall in a Sybase ASE database Want to allow partners/customers to see relevant data with their own applications outside the firewall Use Standards Common ScenarioExposing Your Data

12. From the web/application server, use any standards based data access API to read the data Persist the data as an XML document using persistence features of the relevant API How To Expose Your Data

13. ADO Code Fragment for posting to an Active Server Pages request object Set RS= server.CreateObject (“ADODB.Recordset”) sql = “SELECT ITEM_NO, PRICE, DESC, NUM_IN_STOCK, PHOTO FROM ALL_STOCK ORDER BY 3” RS.Open sql, “dsn=Office supplies;uid=johng;pwd=06TC14” RS.Save response, adPersistXML Example - Exposing Your Data

14. Demo

15. We’ve exposed internal data to our customers/partners using XML over the web! So what? Leveraging XML Data On the Web

16. Customers/Partners can now use intelligent tools/applications to use your data Examples Excel Websphere IIS/ASP PowerBuilder applications Leveraging XML Data

17. Demos

18. We can … expose our corporate data to the outside world using XML read other’s pertinent data then act upon it Provides infrastructure for Web-enabled, business applications Putting It All Together

19. Goal: Let’s build a full B2B application What do we need? Sybase ASE Web Server/App Server Standards-based data access component for Sybase ASE Standards-based data access component for XML Browser B2B Example - No Black Magic

20. Demo

21. XML extends the typical data access API - it doesn’t replace it We can build some pretty nice applications! This is only the beginning Conclusions