|
|
JDBC BrowserThe 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: OpenLet's you select your JDBC data-source by choosing a correctly configured Connector from the Connector Library. TablesQueries the JDBC source for the available tables. Will usually be done for you when you select the Connector (See Open) ColumnsSelect 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. ClearClears the output window ExecuteExecutes 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 :-) NextReturns next entry that has previously been Executed. This typically lets you browse through a returned dataset, one record at the time.
|
|
|