CUBEWARE IMPORTER – THE POWERFUL ETL TOOL IN THE CSP
DATA FORM THE BACKBONE FOR EVERY BUSINESS DECISIONS.
However, if data are to be analysed in a meaningful way, they need to be prepared, enhanced, standardised and placed into relation with each other. Cubeware Importer puts your data into the form that you need in order to gain important insights even faster and more simply.
Data Management Software in Perfection: Cubeware Importer
With the Cubeware Importer, you can model, extract, test and import your data and integrate a multitude of other applications into your BI processes - quickly, easily and reliably.
EXTRACT, VERIFY, IMPORT & MODEL YOUR DATA
Proven reduction in the time needed to implement your data processes
Increased data quality in your BI processes
More than just ETL: management, modelling, integration & monitoring of all data precesses with a SINGLE tool
Visual mapping & scripting in combination or separate from each other
Custom licensing options for cost-sensitive deployment
BENEFIT FROM GENUINE BI APPLICATIONS
More than just ETL: Cubeware Importer enables you to implement interactive BI applications across your entire information chain and to fully integrate additional applications with your BI processes.
Supply all your employees with custom-fit BI applications
Create a data-driven corporate culture
Make your success reproducible
Easily integrate other applications into your BI solution using CWScript – an open programming language in a Linux environment.
Use customisable dynamic link libraries to make additional functions available in the BI process.
The open interface allows you to connect other data sources going beyond ODBC and OLE DB support.
Process & job control
Initiate ETL processes direct from the BI front end to map logical connections, dependencies and conditions exactly in your processes.
MAPPING & SCRIPTING
Visual mappings or scripting? You decided which method you wish to use to develop, manage or extend your data models. Or you can simply combine both methods.
Visual mapping using drag & drop
You can provide an easy introduction to designing import processes and increase the speed of implementation through graphical design using drag & drop in visual mappings to transform source data into target databases without any programming.
Design, extend and customise your mappings easily through the integration of Tcl script modules.
You can also satisfy increasing requirements in your data processes at any time through the power of the scripting language.
DEBUGGING & ERROR HANDLING
Cubeware Importer gives you optimum support in the data loading process with its comprehensive feature set for testing, debugging and optimising data processes and import jobs. You maintain access to all variables at all times and improve the quality of your data, for demonstrably reduced implementation times.
Try out new approaches in scripts, mappings and entire job definitions – with the secure feeling of a successive undo button.
Use customisable error messages and log files to create better data processes and import jobs even faster.
Make use of extensive logging including variable values and data record numbers to gain a rapid overview.
Dedicated ETL tools are often limited to loading and transforming data into existing structures like tables, dimensions and cubes. Different tools are used to create the structures, resulting in fragmented processes during implementation. Errors occur, implementation becomes more complex and maintenance requires greater effort. Cubeware Importer provides both types of function.
All in one
Manage all your loading and modelling processes with ONE SINGLE tool, thanks to the integrated modelling function for all common OLAP technologies.
Take advantage of a data warehouse out of the box.
OLAP dimension modelling
Set up dynamic, data-driven modelling based on comprehensive rule definitions such as value-dependent branching, string processing, transformation through lookups etc.
The parametrisation option allows you to use Cubeware Importer to intervene at crucial points in process flows and to have a significant influence on their execution in order to shorten the time it takes for import jobs to complete – even when large data volumes are involved.
Use of variables
Discover the advantages of working with variables in your data processes.
Direct database connection
Use Importer for direct access to all your databases.
Make flexible use of SQL statements in your ETL processes.
NO TIME TO READ?
THE MOST IMPORTANT INFORMATION ON CUBEWARE IMPORTER AT A GLANCE.