| |
Data Modeler DataBridge
|
Data Modeler DataBridge provides high fidelity externalization of Notes data with no additional steps required. It uniquely mirrors Notes data to relational data structures to facilitate analysis and reporting.
In many cases it is preferable to stage Notes data externally for reporting and analysis.
- If Notes databases are very large, query performance can be slow
- Complex queries can bog down Domino servers
- When data is not highly volatile, it lends itself to aggregation in a separate data store
- Administrators may want to off-load query processing from the Domino servers
DataBridge automatically creates data structures in a selection of leading databases and automates the data transfer process.
- Supports writing Notes data to DB2, Oracle, SQL Server, Sybase
- As simple as clicking a check box and entering a few database parameters. No additional database administration, knowledge or processing is required
- Only the clean business user data model is transferred and data type fidelity is preserved
- Staged data can be updated periodically in the background
- Metadata definitions created by the Data Modeler for Cognos Framework manager automatically link to the staged data
Notes Multi-value fields can be externalized as dimensional tables, providing true relational views of Notes content
Mixing staged data and real-time Notes queries in the same reports and dashboards provides maximum power and flexibility
|