Data Mapper
Data Mapper is a graphical design studio providing all of the tools required to create complete data models for client report content and data maintenance within the Layout Builder and Production Controller.
Multiple data models provide data views from multiple systems, automatically validating and pulling data when required for report generation. Data acquisition can be controlled via the Coric Business Process Manager (BPM) workflow system, as well as accessing the Coric Document Manager for data stored in Excel or other file formats. Data Mapper supports major databases such as Oracle, SQL Server, ODBC, Web services and bespoke data sources.
Data Mapper Features
- User experience
- Unlimited data block definitions
- Unlimited data block layers
- Export / Import of blocks and layers
- Design data blocks with ease
- Test data block hierarchies to trouble shoot
- Add notes to allow data documentation
- General features
- Relational modelling spanning databases
- Data warehouse compatible
- Real time data access compatible
- Anti data breach intelligence
- Built in Production Controller integrity checking
- Intelligent printing of large block structures
- Data access
- Direct SQL Server access
- ODBC access
- Excel data via file access
- Excel data via Coric Document Manager
- Web services
- Intersystems Caché access
- User API available
- Available Data Models
- Default data models for various financial systems
- Default data models for Private Banking reports
- Default data models for Private Banking data maintenance
- Default data models for Institutional reports
- Default data models for Institutional data maintenance
- Default data models for Coric Web Reporter
- Default models for user classification maintenance