The Data Source Explorer view displays your database connections. You can connect to a database simply by expanding the connection node. The database structure can be expanded to the column level. supports multiple simultaneous database connections and the connection tree provides an easy method for browsing them.
Figure: Data Source Explorer View
The following objects are displayed in the Data Source Explorer view:
Connection
Collection
(Catalog)
XML Schema
Repository
XML Schema
Component
Schema
Table
System
Table
Table
Column
A
Collection (called
catalog in some databases) is a hierarchical container for resources and
sub-collections. There are two types of resources:
XML
resource - An XML document or document fragment, selected by a previously
executed XPath query.
non-XML
resource -Any resource that is not recognized as XML.
Note: For some connections you can add or move resources into a
container by dragging them from:
- The Project view.
- The default file system application (for example, Windows Explorer in Windows or Finder in Mac OS X).
- Another database container.
The following actions are available in the toolbar of this view:
Filters- Opens the Data Sources / Table Filters Preferences page, allowing you to decide which table types are displayed in the Data Source Explorer view.
Configure
Database Sources- Opens the Data Sources preferences page where you can configure both data sources and connections.