The DB-to-XML Data Source Editor

You 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.

Figure 369. DB-to-XML Data Source Editor



Once you connect to a server, Stylus Studio displays the databases, tables, views, and columns on the right side of the editor. When composing your SQL statements, you can drag and drop tables, views, and columns from the database schema tree into the SQL/XML editor.

SQL/XML Editor Pane

The SQL/XML editor pane 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 Pane

The database schema pane 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 pane.

Figure 370. Database Tree Displayed in Database Schema Pane

The database schema tree is displayed by default. You can hide it by clicking the Show/Hide Database Schema button ( ), or by selecting DB-to-XML > Database Schema from the menu.



Once the connection with the server has been established and the database is located, Stylus Studio drops the connection to the server. You can reconnect to the database to refresh the database schema tree by selecting DB-to-XML > Load Database Schema from the menu bar.

Information in the schema tree is displayed in a hierarchical fashion, starting with the server you specified in the connection settings. Tables, views, and columns are displayed in database order; column data types are displayed in the Type column.

Working with Relational Data

All SQL/XML statements are defined on the SELECT and UPDATE tabs. Stylus Studio can automatically create valid SELECT, INSERT, and UPDATE SQL/XML statements based on the objects you select from the database schema tree, or you can type your own SQL/XML. 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 associated with the username you use to log in to the database. See Composing SQL/XML in Stylus Studio for more information on this topic.

Free Stylus Studio XML Training:
W3C Member