The Global IDs Product Suite is used for
- Data Integration
- Metadata Integration
- Reference Data Integration
at a
- Global level
- Enterprise level
- Departmental level
DBCrawler 2.1
This product is suited for discovering and cataloging the metadata associated with information sources in a global data landscape. It is most useful for
1. Scanning for information sources in global information landscape
a. Systems
b. Networks
c. Databases
d. Applications
e. Documents
f. Web Pages
2. Cataloging metadata associated any information source in the landscape
a. Databases
b. Applications
c. Documents
d. Web Pages
3. Synchronizing the metadata with changes in the landscape
a. Changes in metadata of schemas and tables in RDBMS environments
b. Changes in data within tables in relational databases
c. Alerting and Monitoring users about changes in the environment
Enterprise
Information Scanning |
Supported |
Note |
|
|
|
Identification
of Enterprise Systems |
Y |
|
 System
Hardware |
Y |
|
System
OS |
Y |
|
System
Memory |
Y |
|
System
Disk |
Y |
|
System
Motherboard IDs |
Y |
|
Identification
of Enterprise Databases |
Y |
|
Relational
Databases |
Y |
|
Static
Databases (e.g. MS Access) |
Y |
|
Multidimensional
Databases |
Y |
|
Hierarchical
Databases |
N |
Future
Support |
XML
Databases |
N |
Future
Support |
Object
Databases |
N |
Future
Support |
Identification
of Enterprise Applications |
Y |
|
ERP
Applications |
Y |
|
CRM
Applications |
Y |
|
EAI
Applications |
Y |
|
Other
Applications |
N |
On
Request |
Identification
of Enterprise Documents |
N |
Future
Support |
Word,
Excel, PowerPoint, Visio |
Y |
|
Outlook |
Y |
|
PDF |
Y |
|
HTML |
Y |
|
XML |
N |
On
Request |
Enterprise
Metadata Cataloging |
Supported |
Note |
|
|
|
System
Metadata |
Y |
|
Database
Metadata |
Y |
|
Instance
Metadata |
Y |
|
Schema
Metadata |
Y |
|
Table
Metadata |
Y |
|
Column
Metadata |
Y |
|
Applications
Metadata |
Y |
|
Document
Metadata |
Y |
|
Metadata
Reporting |
Supported |
Note |
|
|
|
Reporting
of Physical Metadata |
Y |
|
Reporting
of Semantic Metadata |
Y |
|
Export
of Metadata (CWMI compliant) |
Y |
|
Reporting
by Multiple Hierarchies |
Y |
|
Enterprise Metadata Monitoring |
Supported |
Note |
|
|
|
Monitoring of System Metadata |
Y |
|
Monitoring of Database Metadata |
Y |
|
Monitoring
of Instance Metadata |
Y |
|
Monitoring of Schema Metadata |
Y |
|
Monitoring of Table Metadata |
Y |
|
Monitoring of Column Metadata |
Y |
|
Monitoring of Applications Metadata |
Y |
|
Monitoring of Document Metadata |
Y |
|
Enterprise Data Monitoring |
Supported |
Note |
|
|
|
Monitoring of Table Data |
Y |
|
Monitoring of Column Data |
Y |
|
Monitoring of Row Data |
Y |
|
Monitoring of Field Data |
Y |
|
Alerting |
Supported |
Note |
|
|
|
Based on changes in Table Data / Metadata |
Y |
|
Based
on changes in Column Data / Metadata |
Y |
|
Based on changes in Row Data |
Y |
|
Based on changes in Field Data |
Y |
|
Global Data Store 2.1
This product is suited for extracting data from any database in the global data landscape. It is most useful for
1. Extraction of Database Tables from global information landscape to a Central Repository
2. Profiling of the Database Columns in any table in any database any system in the landscape
3. Monitoring and Synchronization of the tabular data with changes in the data landscape
Enterprise
Data Extraction |
Supported |
Note |
|
|
|
Extraction
of Database Tables |
Y |
|
Point
and Click Extraction |
Y |
|
Immediate
or Batch |
Y |
|
One-Time
or Recurring |
Y |
|
Time
Stamping |
Y |
|
Enterprise
Data Transformation |
Supported |
Note |
|
|
|
Simple
Transformation of Data Objects |
Y |
|
Data
Type Conversion |
Y |
|
Data
Length Modification |
Y |
|
Parsing |
Y |
|
Concatenation |
Y |
|
| Formatting |
Y |
|
Standardization |
Y |
|
|
|
|
| Complex
Transformation of Data Objects |
Y |
|
| Conditional
Transformations |
Y |
|
Custom
Transformations |
Y |
Require
Code |
Enterprise
Data Profiling |
Supported |
Note |
|
|
|
Physical
Profiling of Column Objects |
|
|
Variations
in Length |
Y |
|
Variations
in Values |
Y |
|
Outlier
Detection |
Y |
|
Data
Type Detection |
Y |
|
| |
|
|
Semantic
Profiling of Column Objects |
|
|
Variance
Determination |
|
|
| Uniqueness
Determination |
Y |
|
| Ontological
Type Identification |
Y |
|
Object
Classification |
Y |
|
Lexical
Variation Detection |
Y |
|
| Semantic
Variation Detection |
Y |
|
| |
|
|
Custom Profiling of Data Objects |
|
|
Conditional Profiling |
Y |
Require
Code |
Custom Profiling |
Y |
Require
Code |
Enterprise
Data Aggregation |
Supported |
Note |
|
|
|
Aggregation
of Enterprise Data |
|
|
Drag
and Drop Aggregation |
Y |
|
Aggregation
Scheduling |
Y |
|
Aggregation
Validation |
Y |
|
Conditional
Aggregation Rules |
N |
In Dev |
Enterprise
Data Integration |
Supported |
Note |
|
|
|
Creation
of Data Repositories |
|
|
Enterprise
Data Warehouses |
Y |
|
Enterprise
Data Marts |
Y |
|
Enterprise
Operational Data Stores |
Y |
|
Enterprise
Business Activity Monitors |
Y |
|
| Support
for 3rd Party Applications |
|
|
SAP
BW |
Y |
|
PeopleSoft
EPM |
Y |
|
| Siebel
UCM |
Y |
|
ID Integrator 3.0
The application is intended primarily for reference data integration. It is most useful for
1. Profiling of the Reference Database Columns for identification and classification of reference Data
2. Extraction of Reference Data Tables from global information landscape to a Central Repository (Global ID Store)
3. Semi-automated integration of reference data using advanced record matching techniques.
Enterprise
Reference Data Templates |
Supported |
Note |
|
|
|
Support
for Multiple Reference Data Objects |
|
|
Customers |
Y |
|
Products |
Y |
|
Vendors |
Y |
|
Business
Partners |
Y |
|
Employees |
Y |
|
Shareholders |
Y |
|
Locat |
