Access your data

• 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

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