Home > Products > XML Video Demonstrations > 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.

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 SELECT tab for using SQL/XML to query relational databases.
• Understanding the UPDATE tab 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 XMLELEMENT function 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.