Using Data Warehouse
TeamConnect provides a flexible platform for building highly customized matter management systems for managing your legal, compliance, and other business processes. TeamConnect stores and associates all relevant data with each instance of the business process, such as tasks, appointments, assignees, contact information, documents, and billing information. As with most transactional systems, the database schema is normalized to best meet the online usage and performance requirements.
Because TeamConnect provides a dynamic development environment which allows the creation of custom rules and fields, the resulting database schema is very complex, consisting of well over 200 tables. Due to the complexity of the TeamConnect operational database schema, it is not easy to extract information without a deep understanding of the interrelationships of the tables. This understanding typically requires a database administrator or an experienced business intelligence expert to extract meaningful information. Data Warehouse makes that information available to a wider range of users.