Metamerge logo
Search

Advanced Search
*
*
*
* HOME DOCUMENTS & RESOURCES DOWNLOADS EARLY TECH ACCESS SUPPORT FAQ KNOWN ISSUES OLD VERSIONS
*

 

JDBC Browser

The Metamerge Integrator supplies you with a simple JDBC browser, it is available under Tools|JDBC Browser.  The browser supplies you with a superset of the functionality you get when you configure a Connector itself with the Attribute tab (Configure | Attributes).

In order to use it you need to have a configured JDBC Connector in your Connector Library:  It should have all the information needed to connect to the data-source you are interested in.

The Browser will let you open the Connector: A dialogue box letting you select your Connector will show up.

The follow buttons to allow you a rudimentary browsing:

Open

Let's you select your JDBC data-source by choosing a correctly configured Connector from the Connector Library.

Tables

Queries the JDBC source for the available tables.  Will usually be done for you when you select the Connector (See Open)

Columns

Select one of the Tables/Views and press Columns to query the Table Definition. It will show you the available columns as well as their type.

Clear

Clears the output window

Execute

Executes an SQL statement. The statement is typed in  the SQL Statement sub window.  The results of the execution is not shown directly:  You will have use the Next button for that.

Execute can be used to actually change the data, so I guess this isn't really a browser :-)

Next

Returns next entry that has previously been Executed.  This typically lets you browse through a returned dataset, one record at the time.

 

 

*
  Metamerge Integrator version 4.6 ©Copyright Metamerge AS 2000-2002 Last edited 2002-06-10 contact us