MyReport Data
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-added transformations
- Create consolidation models
Manage and automate the loading processes
- Test and control model execution
- Program the frequency at which ETL processes are executed
- ETL update based on Table insert, Row insert or running total
- Manage the access rights for your decisional data warehouse
Main features
Connection
- Connection to data on different operating systems
- Simultaneous connection on multiple databases (tested with extraction out of 172 databases with a global consolidation)
- Native connection to Oracle, SQL Server, Interbase, Informix, MySQL, AS400 (DB2) and MS Access.
- Connection via ODBC drivers for all the other database
- Importation of flat files: delimited ASCII (.csv, .txt) , 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
- Scheduling of imports
- Audit trace and import logs
- User rights management with filters on the models, fields and data for each profile
- Connexion on Active Directory to extract users list
- Automatic loading in compliance with priorities
