IDL.IMPORTER for multidimensional data management

  • Scalable ETL processes
  • OLAP modelling
  • Visual mapping and scripting
  • Certified SAP interface

IDL.IMPORTER

DL.IMPORTER offers a user-friendly tool for ETL and BI modelling. You can manage your data between relational and analytic formats and automatically build multidimensional models and staging areas.

IDL.IMPORTER uses standardized interfaces to access relational databases including ERP systems such as Microsoft Dynamics NAV and AX, various SAP solutions, CRM systems and text files as well the multidimensional databases Microsoft Analysis Services and IBM Cognos TM1.

You can model the import workflow using drag-and-drop functions in an intuitive mapping interface. IDL.IMPORTER requires no special programming skills but supports comprehensive scripting capabilities for skilled power users.

Functionality

  • ETL and OLAP modelling
  • Integrated mapping and scripting
  • Visual mapping
  • Drag and drop
  • TCL scripting
  • Scripting debugger
  • Mapping debugger
  • Integration of various data sources (e.g. relational databases, multidimensional databases, text files)
  • Parallel access to various source systems
  • Table filter
  • Job automation
  • Write functions via ODBC or OLEDB
  • UNICODE support
  • Certified SAP interface

"ETL for business professionals"

With IDL.IMPORTER, business users can easily define their data flow using the intuitive drag-and-drop functions while tech-savvy users can use its rich programming and scripting capabilities. The tool also provides certified connectivity to SAP systems so you can pull SAP data with amazing speed. Our clients truly benefit from the tool’s simple handling. They can define, for example, the level of automation for running the data load or flexibly define how to deal with errors.

Inside look

  • IDL.IMPORTER: Mapping

    Mapping interface SQL

    Mapping interface of IDL.IMPORTER – Mapping with SQL Server data as the source

  • IDL.IMPORTER: Jobs

    Jobs

    Jobs in IDL.IMPORTER

  • IDL.IMPORTER: Würfel

    Cubes

    IDL.IMPORTER cubes

  • IDL.IMPORTER: Mapping Konsis

    Mapping interface KONSIS

    Mapping interface of IDL.IMPORTER – Mapping with IDL.KONSIS as the source

  • IDL.IMPORTER: Importe aus Konsis

    Imports KONSIS

    Imports from IDL.KONSIS

Extensions

IDL.COCKPIT

Planning and analysis

IDL.COCKPIT

Use the flexible front-end tool IDL.COCKPIT to support specific analysis requirements and build operational planning solutions for specific departments.

IDL.KONSIS

Financial consolidation

IDL.KONSIS

Create group financial statements based on various accounting standards with IDL.KONSIS.

IDL.FORECAST

Financial planning

IDL.FORECAST

Support the financial planning process and test different scenarios across the different companies in your group with IDL.FORECAST.

IDL.DESIGNER

Reporting platform

IDL.DESIGNER

Create reports, forms and dashboards using drag-and-drop functions with IDL.DESIGNER, the central design component of the IDL reporting platform.

Please send me more information

* Mandatory fields
Datenschutz *
Zustimmung-E-Mail *
Zustimmung-Telefon