D&I Data Dictionary Administrator (Metadata Administrator)
It’s the Platform “core”. It’s the Module to manage the Data Dictionary.
It’s the Module to define all the meta-information that describe the data models to be observed and the logical and the physical view of every information (measures, dimensions, domains, grouping functions, etc.).
It is the system to manage the repository of the information (metabase) in which, in a simple and intuitive, and as far as possible automatically, it is possible to govern the information: from the description of the sources of access to his typing through graphic formats and descriptive, from the description hierarchical relationships to those of interconnection and interdependence, from the interpretation of its format to the definition of the rules of quality control, etcetera, etcetera.
Unlike many other business intelligence platforms the information in D&I is centralized and is primarily managed at a single point (the D&I Data Dictionary Adminstrator) and made available to each module of the platform.
No redundancy, a single view of the truth
Using this module, the entire system is immediately usable and accessible by all users not requiring any technical knowledge on their composition or nature of information to be treated. The system is also responsible for the design of the Data Model as well as the User Management and the authorization level for each User Group (user profiling).
JW_PLG_SIG_PRINT_MESSAGE:
https://www.oxero.com/en/products/main-modules.html#sigFreeIda6be501cbd |
D&I ETL (D&I Extraction & Transformation and D&I Loader)
System of Extraction, Transformation and Loading Data of the D&I Platform (D&I Extraction Transformation & Loader System) aims to describe, identify and perform all the steps necessary to acquire, transform and process data from multiple heterogeneous sources in order to historicize in one or more target information databases.
The system, fully java based, covers all the functional requirements for an ETL system:
-
Data Extraction
It is the task of extracting data from information sources within an ETL process.
D & I ETL supports access to all major data sources, databases, files, csv, xml, webservices.
Your use of the system does not require any programming because all of the features extraction are set through the graphical features provided by the system itself. The mapping (logical and physical description of any information found in data sources), the setting of the type of the source (type of data source to access, dbms, etc..), the frequency of access / retrieval of data (daily, monthly, etc..) defining the various steps of the process (work flow process), all information is set through the appropriate functions and stored in the Data Dictionary in order to ensure constant and automatic documentation of each activity for the benefit of any subsequent maintenance or evolution activities of the processes themselves -
Data Transformation
The data processing component is provides of all the possible functions / routines for processing of data in the different steps of the information processing. To ensure maximum flexibility and adaptability and to allow full independence of the Users and the evolution of the system, in addition to the already available library of functions provided natively in the system is given the opportunity to implement new library by adding new functions for processing data by simply adding new classes java. -
Data Loading
It is the stage in a process of ETL that is responsible for generating the physical database that will host the final information assets. The D & I module provides functions to extract, transform and load data from source to target for single entity or for a collection of many entities at the same time, in a single step for example, it’s possible to move an entire database from a source to a target without need to specify the conversion necessary in cases of different DBMS. Supports all major databases or communication protocols with DBMS: MSSQL, Oracle, DB2, JDBC, ODBC, Excel and Access, MySQL, CSV-files, XML-files, etc..
All phases of the processes are usually interconnected with each other and are activated according to the exit status of each step: D & I ETL allows the drawing of a graph complex in which each step is conditioned by the state of one or more predecessors.
The graphical interface allows the logical description of the entire ETL process, the User can draw, without any programming, the whole stage with the possibility also to indicate, for each logical step, any action to be taken if not successfully complete the same step (pathway abnormality, roll back, email notification, notifications in the console, etc.)..
Follows the main features provided by D & I ETL:
-
Intuitive graphical user interface for the representation of processes
The system provides the double function of allowing the description of a process and ensuring the constant updating of the process documentation process. To ensure that this can be done in the quickest and easiest possible way has been designed and built a highly intuitive graphical interface, on the other already-proven (particularly welcome) by our customers. -
Printing capabilities and process documentation
The system gives the opportunity to provide appropriate prints that can accurately describe the processes designed with the application.
Connection by JDBC to data sources andSupport of many type of databases (MSSQL, Oracle, DB2, JDBC-ODBC, Excel e Access, MySQL, CSV-files, XML-files,...) in every phases of extraction or loading
It’s possible to interface with the most common and heterogeneous systems of data storage.
The connection via JDBC to the various data sources and support for different types of databases (MSSQL, Oracle, DB2, JDBC, ODBC, Excel and Access, MySQL, CSV-files, XML-files, WebServices, FTP, etc..) are just some of the protocols and how to interface natively guaranteed by the system. -
Advanced data processing with the possibility of using javascript functions for the manipulation of the data
The system provides a library of functions and procedures of data transformation (from simple algebraic operations or aggregation of data to copy or modification of entire database tables, the management of process variables to override the default values, etc..) implemented and already available in the system. However, to ensure maximum flexibility and adaptation over time you can put new routine and javascript functions carried out by users or any third party which, once documented, they automatically become part of the library system functions available to each user. -
Scheduling processes
The entire process is described through the use of graphics functions provided by the component integrated with the Work Flow System. Through these capabilities the process can be divided into independent elementary components, organized into sub-processes, structured so as to manage operations to roll back or recovery information automatically in case of incorrect completion of one or more activities. Any activity, process, subprocess also may be activated manually or automatically, or even subjected to the "scheduler Processes" provided as part of the solution in question. -
Console management and monitoring
A Web interface allows the management of processes, or you can start, pause, stop the processes, more detail the set of trace log for each process in order to have for every single step the exit status, time of performance data that can be useful to carry out stages of tuning. -
Additional features guaranteed by the system are:
- Copy tables with the possibility of applying transformation functions for the individual fields selected from a library that can be expanded
- copy entire database
- Executing SQL Script
- Running or calls to Web Services with reading response
- management or process variables, assignment, verification and use of the value of the variable
- activity of individual steps of a process based on the conditions of release prior
- Definition of timer activation step
- Call of external shell
- Nesting of processes
- FTP or file (GET / PUT, SSH)
- reading tables in a database and view
- reading and writing to file system
- Reading of excel file
- Run of external routines
- repositories of libraries of reusable routines
- Management of cursors on tables / views and ability to read data from the cursor to the use of the values in the process
- Multi thread of the steps
- Notification of the status of jobs or even through e-mail
- Debug Process
JW_PLG_SIG_PRINT_MESSAGE:
https://www.oxero.com/en/products/main-modules.html#sigFreeIdd2fa451cbe |
Smart Reporting System (Light D&I Analysis & Reporting)
It’s the Module used by the “first level of users” who need to define simple kind of reports or, in the most of cases, used to require information using report already defined by “high level users”
JW_PLG_SIG_PRINT_MESSAGE:
https://www.oxero.com/en/products/main-modules.html#sigFreeId2aec306e8d |
Full Reporting System (Full Optional D&I Analysis & Reporting)
It’s the complete Analysis System used by specialized users (“high level users”) to rich any data and information and to define each kind of reports for showing the data in the best of mode (dashboard, multidimensional matrix, relational matrix, free style report, graphics, etc.). The system provides access to any information handled by D & I, the analysis and monitoring of activities in order to identify and resolve potential problems and - at the same time - recognize and take advantage of new opportunities and the distribution of information and the results of its inquiries to cover all those that they need, when they need it, putting them in a position to make more informed, aware and timely decisions.
It’s the D&I Platform Module born to guarantee the simple, fast and complete retrieval and access to the Customer data and to report them in the best way.
The Analysis & Reporting System is integrated with the D&I Data Dictionary and with all the other D&I Platform Modules (ETL System, Data Entry System, Error Management System, Quality System, …) . It’s studied to be used by specialized users (“high level users”) or "first level Users" to rich any data and information stored into the DWH. Users can define each kind of reports for showing the data and, more, they can choose the way in which want to see the results (dashboard, multidimensional matrix, relational matrix, free style report, graphics, …) All the results can be exported in Microsoft Excel, pdf, Microsoft Power Point, txt, csv, Microsoft Word and so on.
Through the analysis module, Users make use of all the features necessary to carry out both basic research on the data base (according to any criteria dynamically defined by users) and for complex analyzes. With the Reporting System, Users can navigate the data from aggregated views to detail views and vice versa. Shortly it responds to all the needs of extracting data from relational database.
The embedded Profile Management feature can be easily configured by the administration features and can be integrated with the single sign-on authentication service, of the Client. The system can be characterized according to the user's profile, for example it’s possible to have a login page too, different for each user profile, or enable or disable the native functions of the system.
JW_PLG_SIG_PRINT_MESSAGE:
https://www.oxero.com/en/products/main-modules.html#sigFreeIdd8d50b710b |
Hereunder a little list of the main feature:
- Intuitive access to the data: the final user is not necessarily required to be familiar with the composition or structure of the observation Information Patrimony
- Interactive Reporting web based with the possibility to create navigation paths and access to information at any level of aggregation / detail (native data navigation)
- Management and distribution via web of reports, analysis, and dashboards
- Report Connecting to use to filter the results of a suitably data of the other
- drill-up and hierarchical or de-structured drill-downs (drill across)
- definition of new calculation variables(administrator users can define new information generated them from the original ones, using simple or complex formula)
- setting of distribution analysis at more aggregation levels (multiple grouping level)
- Customization of interfaces and reporting organization in Subject Area
- Definition of Quality Control Report
- Definition of Report to analyze the ETL Log
- Easy integration with portals and web Applications
- Availability to add / view reports generated by other systems or pdf, word, excel documents
- Profiling for application configuration and for limit data visibility to ensure maximum confidentiality of the information and its Segregation of Duty
- Log information with different levels of detail (available online) with the possibility of producing specific reports (for audit, data protection commissioner, access control, ...)
- synchronous or asynchronous execution of the observation models
- definition of the graphic features related to the display of the numeric information and association of each attribute (measure and dimension) with bitmap or images, provided the appropriate relationships are met
- definition and request of detail template
- multidimensional matrix presentation of results (unlimited number of dimensions on rows or columns, in consistency with the physical size of the monitor or of the related graphic chart), graphic presentation (histogram, pie chart, ring char, area chart, linear, Venn diagram), excel, or free style report based on the User needs
- association of a descriptive and/or hierarchical and/or historical domain
- definition of “selection” or “pre-selection” conditions
- historical analysis (results comparison)
- functions of save and export of results (and of the related analysis tracks) on the main standard data formats (pdf, formatted text, excel, word, power point, xml, rdbms, e-mail)
- simple or complex ordering functions, multilingual, multi-currency, ...)
The Reporting tool D&I supports end-user reporting, analysis, and dashboard capabilities with back-end security, integration, scheduling capabilities.
Capabilities and Benefits include:
- Broad platform support based on J2EE standards
- Broad data source support including relational, OLAP, or XML-based data sources
- Management and distribution via web of reports, analysis, and dashboards
- Easy integration with portals and web applications
- Integrated scheduling
- Integrated authentication
- Profiling for application configuration and for limit data visibility
- Integrability with enterprise single-sign-on
Comprehensive BI capabilities
OXero Module supports, integrates, and enables end user capabilities, including:
Reporting
All organizations use reporting in one form or another. As a result, reporting is considered a core Business needs. It allows organizations to easily access, format, and distribute information to network:
- Flexible deployment of interactive web-based report
- Integrated with many common open source and commercial reporting tools like Eclipse BIRT Report, Crystal Reports, JReport, Actuate
- Flexible output options including Adobe PDF, HTML, Microsoft Excel, Microsoft Power Point, Microsoft Word, Rich Text Format, or plain text
- Report design based on logical model for fast, easy report creation
Analysis
OXero tool puts rich, analytic power in the hands of your knowledge workers – helping them to operate with maximum effectiveness by gaining the insights and understanding they need to make optimal decisions.
The Reporting System Analysis helps answer of business questions by:
- Making it easy for knowledge workers to freely explore business information by drilling into or out, and cross-tabulating data, applying simply or complex filter
- Providing speed-of-thought response times to complex analytical queries
- Offering advanced capabilities - such as integrated reporting, metadata, or dashboards and through integration with other products of reporting
Dashboards
Reporting System provide immediate insight into individual, departmental, or enterprise performance. By delivering key metrics in an attractive and intuitive visual interface, Reporting System dashboards gives business users the critical information they need to understand and improve organizational performance.
Reporting System Dashboards delivers this visibility by providing:
- Rich, interactive visual displays so that business users can immediately see which business metrics are on track, and which need attention
- Integration with Reporting and Analysis so that users can drill to underlying reports and analysis to understand what factors are contributing to good or bad performance
- Portal integration to make it easy to deliver relevant business metrics to large numbers of users, seamlessly integrated into their application
- Integrated alerting to continuously monitor for exceptions and notify users to take action