1 / 21

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

EP109 Leveraging ODBC, JDBC, and ADO to Integrate Sybase Data with XML. John Goodson MERANT - Vice President, R&D Enterprise Data Connectivity John.Goodson@merant.com. Overview/Goals Review ODBC, JDBC, ADO/OLE DB XML Introduction/Review Sybase/XML Usage Scenarios and Demos

abra-hyde
Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related