Cart
Home > Learn XML > XML Video Demos > Box Office > Learn SQL/XML > Accessing Databases as XML: Part II
Using Stylus Studio's Database-to-XML Editor to Query and Update Relational Databases using SQL/XML
In addition to accessing relational databases through the file explorer (as demonstrated in the last video in this series), you can also use Stylus Studio's DB-to-XML data-source editor to query relational databases and render the results as XML. The ability to retrieve relational database data and render it as XML is a powerful feature used to tap into your enterprise data resources. Watch and learn how easy it is to define relational-to-XML mappings for getting XML out of relational data and updating relational databases from XML using industry-standard SQL/XML extensions and Stylus Studio's DB-to-XML data-source editor.
The Camtasia Studio video content presented here requires JavaScript to be enabled and the latest version of the Macromedia Flash Player. If you are you using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Flash Player by downloading here.
Catch the entire Relational Database to XML Mapping series!
Using Stylus Studio's Database-to-XML Editor to Query and Update Relational Databases using SQL/XML covers the following topics:
- Creating a relational data source using the DB-to-XML Editor to connect to SQL Server, Oracle, IBM DB2, Sybase, Informix and other ODBC compliant databases.
- Specifying database connection properties including the server URL, username and password.
- Connecting to a relational database and browsing database objects including databases, tables, views and metadata.
- Understanding the
SELECTtab for using SQL/XML to query relational databases. - Understanding the
UPDATEtab to push XML data back into a relational database. - Querying a relational database as XML using Stylus Studio's drag and drop user-interface that can automatically generate SQL/XML code.
- Using the
XMLELEMENTfunction to define relational-to-XML mappings according to the SQL/XML standard. - Executing a SQL/XML query and previewing the results in Stylus Studio's XML text view and XML grid view.
- Creating the SQL/XML statement needed to insert new rows into a database table.
- Using the relational database connection as a target data source in the XSLT mapper.
Learn Convert to XML
Convert to XML lets you convert .txt, binary, and EDI files to XML documents. Convert to XML works on a single document, or to build reusable converters that let you open flat files as XML documents. Free online demonstration!
Generate XSD
Stylus Studio® can generate an industry standard W3C XSD (or DTD) by correctly inferring an XML data model from an XML instance document.
Biotechnology & Pharmaceuticals
Leading biotechnology & pharmaceuticals companies take Stylus Studio when they are feeling under the weather. Come see for yourself how Stylus Studio can be a pick me up for your biotechnology or pharmaceutical company.
XQuery Documentation Generator
Stylus Studio provides integrated support for xqDoc so you can generate XQuery documentation directly from the XQuery editor.
