|
|
ECS Products - Database Integrator
Removing barriers between separate information systems is becoming more and more important in enabling knowledge workers to solve problems efficiently. Database Integrator addresses this need in two ways.
First, Database Integrator bridges the gaps between disparate tabular databases. Users can view, query, and relate tables in Oracle, SQL Server, Access and other OLEDB databases. In fact, tables from different databases can be brought into a common query environment.
Second, Database Integrator links tabular information to data in a geographic information system (GIS) and in document management systems. It is a companion of GTI's IDM for ESRI GIS product suite that links document management systems with GIS systems. Together these products provide a common query environment for the three principle types of information managed by enterprises – tables, maps, and documents.
User Interface Features
- Define and store queries for each table in a project
- Combine the results of successive queries using set operations (add to selection, select from selection, unselect) consistent with GIS selection methodology
- Select fields to be displayed for each table
- Create aliases for each field
- Sort on multiple fields
- Copy selected records and paste them into other applications
- Hotlink, select, or flash GIS features and/or documents that are related
- Find records of interest by linking from the GIS or DMS
Benefits Summary
- Works with tables from any OLEDB data source
- Integrates with Maps and Documents
- Tolerant of variations in data format
- Integrates rows and columns from separate tables in a ‘Working Set'
Working Set Preview
Database Integrator provides a special view that merges rows from selected tables. This provides the user with a single virtual table containing all the rows and all user specified columns of tables of interest. Columns from different tables that have the same name are displayed as a single column in the Working Set, enabling users to organize, sort and report similar data from separate systems.
Schema Level Integration
Database Integrator uses documented key-foreign key relationships to link tables together. We call these relationships links. Links provide a very powerful and flexible mechanism for connecting information in managed in separate systems. For example, a link could be defined between an assessor master file and a permits database, one perhaps in Oracle and the other in SQL Server. Using this link, assessment records could be selected for parcels that had received certain types of permits recently. Similarly, a link could be defined between either of these tables and a parcel layer in the GIS and/or a deed or other document in the document management system. With links such as these in place, a user has full access to all forms information maintained about a parcel. A query could begin with a table then link to another table or to the map or to a document.
A variety of link types are supported that make full use of the capabilities of the information system involved. For example, an address field in a table and be used to link to the map through a geocoding service in the GIS. In addition, links can be defined that accommodate differences in data formats between systems. For example, if a parcel number contains dashes in the GIS but not in a table, a link can be defined that accommodates this difference. Or, if a link field is a compound key in one system but concatenated field in another, this, too, can be accommodated. |
|
Join us! Free Workshops & User Groups
For more information click here.
Copyright© 2008 - ECS Imaging, Inc. All rights reserved.
|
 |
|