Cart|
|
Home > Online Product Documentation > Table of Contents > The DB-to-XML Data Source Editor The DB-to-XML Data Source EditorYou use the DB-to-XML data source editor to specify database connectivity settings, and to compose the SQL/XML (queries and other actions) that you want to execute on the server.
SQL/XML EditorThe SQL/XML editor is on the left side of the DB-to-XML data source editor. It consists of two tabs, SELECT and UPDATE, which you use to compose SQL/XML SELECT and, optionally, UPDATE and INSERT statements. You can type directly in the editor, or you can use drag-and-drop to automatically compose SQL/XML statements. See Composing SQL/XML in Stylus Studio to learn more about using the SQL/XML editor. Database Schema TreeThe database schema tree is on the right side of the DB-to-XML data source editor. Once you have established a connection to the database specified in the scenario, Stylus Studio displays a tree diagram of the database schema.
The database schema tree is displayed by default. You can hide it by clicking the
Show/Hide Database Schema button (
Information in the schema tree is displayed in a hierarchical fashion, starting with the server you specified in the scenario. Tables, views, and columns are displayed in database order; column data types are displayed in the Type column. Working with Relational DataStylus Studio can automatically create valid SELECT, INSERT, and UPDATE SQL/XML statements based on the objects you select from the database schema tree. In addition, your DB-to-XML data source can contain any valid SQL/XML statement defined on the SELECT or UPDATE tabs. The actions that can be performed by the SQL/XML you define in your DB-to-XML data source are limited only by the permissions of the username you use to log in to the database. See Composing SQL/XML in Stylus Studio for more information on this topic. |
).
WYSIWYG XSLT Designer
Stylus Studio's powerful and easy-to-use WYSIWYG ("What you see is what you get") XSLT Designer lets you create XSLT stylesheets without writing any code! Go from a blank slate to solid, robust XSLT in minutes, using simple drag-and-drop operations.
Multi Channel Publishing
Multi channel publishing lets you go beyond single-source publishing of HTML and PDF to also generate simultaneously for non-document forms, such as to communicate with partners or drive spreadsheets.
Convert to XML
Convert to XML is a powerful data integration tool enabling you to convert any legacy data format (EDI, EDIFACT, x12, Binary, HTML, TSV, CSV, etc.) to XML using an intuitive, visual user interface.
Technology Companies That Use Stylus Studio
Technology companies can't always handle every technology that they come across. That's why when it comes to XML, they look to Stylus Studio to guide them. Check out which top technology companies are looking to the future with Stylus Studio.
