Data Sources
|
| Previous Top Next |
Data Sources |
In order to query a database, you have to first connect to the required database This section describes how to:
| • | Connect to a database, and |
| • | Select the required data source and root object from among multiple existing connections. |
Connecting to a database
When you click the Query Database command in the View menu for the first time in a session (and when no database connection exists), the Quick Connect dialog (screenshot below) pops up to enable you to connect to a database. To make connections subsequently, click the Quick Connect icon 
in the Database Query window. If connections already exist, you can select the required connection from among these.
How to connect to a database via the Quick Connect dialog is described in the section Connecting to a Data Source.
Supported databases and their root objects
The following databases are supported. After connecting to the database, the available root objects for each of the supported database is as follows:
Database |
Root Object |
MS SQL Server 2000 and 2005 |
database |
Oracle 9i and 10g |
schema |
MS Access 2003 and 2007 |
database |
MySQL 4.x and 5.x |
database |
IBM DB2 8.x and 9 |
schema |
Sybase 12 |
database |
IBM DB2 for iSeries v4 |
schema |
IBM zSeries for DB2 8 and greater |
schema |
Please note:
Stylevision fully supports the databases listed above. While Altova endeavors to support other ODBC/ADO databases, successful connection and data processing have only been tested with the listed databases.
Selecting the required data source
All the existing connections and the root objects of each are listed, respectively, in two combo boxes in the toolbar of the Database Query window (screenshot below). After selecting the required data source in the left-hand combo box, you can select the required root object from the right-hand combo box.
In the screenshot above, the database with the name StyleVision DB has been selected. Of the available root objects for this database, the root object ALTOVA_USER has been selected. The database and the root object are then displayed in the Browser pane.
See also:
DBs and StyleVision, for a description of how DBs work with StyleVision.
Connecting to a Database, for a detailed description of how to connect to databases.
Browser Pane: Viewing the DB Objects, for information about how to configure and use the Browser pane of the Database Query window.
Query Pane: Description and Features, for Query Pane options and editor features.
Query Pane: Working with Queries, for the details of executing a query in the Database Query window.
Results and Messages, for a description of the Results and Messages tabs of the Database Query window.
Datatype Conversions: DB to XSD, for mappings of DB datatypes to XSD datatypes when the XML Schema is generated from the DB.
|