The ETL engine drives your InfoSuite solution – quick and smooth
The ETL engine is the link between your data sources and InfoSuite. It is the driver ensuring that InfoSuite can provide you with analyses, reports, and visualisations with valid data from different sources.
ETL is short for extract, transform and load. ETL allows companies to collect data from different data sources, transform it into real insights, and finally, to load it to a central data warehouse from where the BI tool presents the valuable insights.
And that is an essential factor for modern companies today, which possess data from a large amount of data sources. The most important job of the ETL engine is therefore to uniform and collect your data and allow you to get a total overview and synergy across your business.
Let go of the really hard (and sometimes really expensive) preliminary work
Usually, when investing in a BI or a data-based budget solution, the development of ETL will account for a large part of the investment. It is a massive task; you or your IT consultant must identify all data sources and code the transformation of data into your data warehouse.
With InfoSuite, you beat this challenge. We have created our own ETL engine which standardises the process of transforming your data. Consequently, we are able to – immediately after installation of InfoSuite – transform data from most data sources into operational analyses and reports – completely without manual programming.
That makes your BI or budget solution less expensive and installation of InfoSuite becomes much smoother, as 80% of the implementation job has already been made.
Here you go! This preliminary work is included for free with the InfoSuite ETL engine
Extract: We extract data automatically
Based on our pre-defined data integrations, the ETL engine automatically extracts data from ERP systems, such as Dynamics Nav, C5 & AX and Aspect4 as well as Lawson M3. In addition to this, it accesses data from a number of other data sources, including CRM systems, POS systems, telephone systems, payroll systems etc.
Furthermore, the ETL engine is equipped with variable SQLs. This means that we can process data as soon as InfoSuite has been installed, without noticeable.
Transform: Standard transformation guarantees endless analysis opportunities
The InfoSuite ETL engine is packed with elements that not only automates the process of transforming data, but also guarantees a large number of functions, including:
- Standardised DSA tables with uniform naming and data categorisation
- Structural updates, allowing you to add business specific master data
- Company table, in which data from more companies can be created and added
- Amount fields, predefined in various currencies
- Exchange rate table, enabling automatic conversion of financial statements into group currency
- Management of country codes, language codes etc.
- Update of period dimensions, giving you the optimal basis for detail controlling
- Intercompany, management of intercompany transactions
- Budget models, which makes integration of budgeting in your BI solution very simple
Load: Safe and smooth upload to the InfoSuite client
The third function of the ETL engine is to load the transformed data into your BI or budget tool.
Through predefined, business-oriented fact models, such as finance, sales, stock, and purchase, the ETL engine guarantees that data are loaded correctly and with no errors to the InfoSuite client. They can now be included in predefined analyses and dashboards, which naturally are adapted to the specific company requirements.
Can I implement the ETL engine?
For now, we have operational ETL solutions for the most common ERP systems, such as Dynamics Nav, C5 & AX and Aspect4 as well as M3. You can still have InfoSuite even if you have a different ERP system. By means of our ETL engine and defined DSA tables, we can establish an integration that helps you get started using InfoSuite.
Do you have questions for ETL? Or are you uncertain how our ETL engine fits your requirements? Then please do not hesitate one of our partners.