metaEXL - Excel Integration

Excel-Files are omnipresent in modern organizations. They are used to collect, exchange and import / export data. Excel-sheets can be exchanged with the repository with a minimum of standardization or conversion. They are also very helpful to build test sets for models and use cases.

The Excel-Interface operates like any application and is therefore also controlled by the security system: It must log in to a Schema and provide a UserID and password. Therefore one can use the Exel-interface in a very selective and controlled manner.

Import Data from an Excel-Map

The Excel-Import reads all tables from an Excel-Map and stores the data in the repository. The names from the data model serve as links between the Excel-sheets and the repository. A map with 40 tables – one table for each entity and several tables for the relations – and 20.000 instances is loaded in 8 seconds. The loader performs a thorough check and produces a detailed documentation about the load process or input errors.

Query and Export

The MetaExl interface provides a facility to select and export data from the repository with a simple query (noSQL) in the header line.

Update an Excel Map

The update-facility is used to refresh the data in an Excel sheet with the content from the repository. This enables users to set up Excel-tables for specific groups or purposes and to update them with the content of the repository.

Backup

This function provides an automatic backup of content of the entire repository or of a the content of a specific view.