Specifying Connection Settings

Stylus Studio uses connection settings to connect to the database from which you want to create your DB-to-XML data source. Specific properties vary from database to database, but you generally need to specify

  • The type of database to which you want to connect. You can connect to one of the default relational databases supported by Stylus Studio (Oracle, Microsoft SQL Server, Informix, and so on), or you can use DataDirect SequeLink to connect to any ODBC database you specify.
  • The server URL and other connection parameters. In addition to the server's location, connection parameters can include the server name, the port through which the connection is established, and other information, such as a server ID (SID).
  • The username and password required to log in to the database.

This section describes these connection setting properties in greater detail, and tells you how to create a default connection setting you can reuse with any DB-to-XML data source you create.

In this section

This section covers the following topics:

Berkeley DB XML and Stylus Studio

Develop XML applications for Berkeley DBXML with Stylus Studio integrated tools support for SleepyCat Software's DBXML. Open, Query and Save XML to and from Berkeley DB XML directly from within the Stylus Studio XML IDE.

OASIS Catalog Support

Stylus Studio's features for working with OASIS catalogs allow you to incorporate any vendor's catalog - or one of your own - in your XML, making writing correct and robust XML easier than ever.

Stylus Studio's Advanced XQuery Mapper Features

Learn how to create an advanced XQuery expression in the XQuery mapper, specifying operations, constants, and ports, for use in conditional blocks and FLWR expressions. Free online video demonstration!

XML Grid View

The XML Grid View is a visual interface for editing tablular data structures using an intuitive spreadsheet-like interface.

Stylus Most Wanted

 
Free Stylus Studio XML Training:
W3C Member