Access your data MyReport Data guarantees access to: - The company's different data sources
- To ERP, CAPM, CRM, sales management and accounting software
MyReport Data allows users to quickly identify the useful, relevant and mission-critical business data Build your decision-making environment - Visually create simple or complex links between the tables
- Select and rename the relevant information according to your business standards
- Aggregate, define and enrich the data through high value-addedtransformations
- Create consolidation models
Manage and automate the loading processes - Test and control model execution
- Program the frequency at which ETL processes are executed
- Manage the access rights for your decisional data warehouse
Connection- Connection to data on different operating systems
- Native connection to Oracle, SQL Server, Interbase, Informix, MySQL and AS400
- Connection via ODBC drivers
- Importation of delimited ASCII, Excel© and OpenOffice.org files
Transformation - Model designer in graphic mode
- Creation of models using tables from different data sources
- Use of data dictionaries for each connection
- Customization of table and field names
- Unlimited creation of transformed fields with a syntax checker
- Importation and creation/modification of translation tables
- Creation of filters for each model
- Aggregation of fields and consolidation of tables
- Grouping into analysis dimensions
- Functions for multiple transformations: calculation, concatenation, correspondence, condition and aggregation
- Data and text transformation shortcuts
- Use of transformation results in strings
Loading - Population of a relational database in client/server mode
- Concurrent launch of one or more models
- Modes for importation, insertion, accumulation, deletion-reinsertion
- Audit trace and import logs
- User rights management with filters on the models, fields and data for each profile
- Automatic loading in compliance with priorities
Execution with My Report DataRun - Scheduled loading of the data warehouse
- Definition of the MyReport system path
- Model and user management
- Access to the log and error log
Minimum system requirements Workstation: PC running Microsoft Windows© (98 onwards)
Required memory: 512 MB
|
