.

Case studies ŠKODA AUTO


ŠKODA AUTO makes data-driven decisions using an analytics platform on which data transfers are comprehensively managed and monitored by Adastra’s Adoki

In 2018-19, Adastra built an on-premise Data Analytics Platform (DAP) at ŠKODA AUTO. Its purpose? To visualize data and use advanced analytics and artificial intelligence to perform sophisticated tasks with large volumes of data.

16 servers

use the solution implemented by Adastra

149 TB

is the total data storage capacity

1,8 TB

is the average monthly data increment

404 users

utilize the platform, including 322 analysts and 82 data scientists

A detailed look at the Data Analytics Platform at ŠKODA AUTO

At ŠKODA AUTO, the platform is used for Production and Logistics, Quality Control, Marketing and Technical Development, as well as in the Warranty department, which takes advantage of smart scoring for warranty claims to be invoiced.

The platform also makes it possible, for example, to gauge customer loyalty, predict customer behavior, evaluate needs and tailor product and service offers accordingly.

Jiří Boček, the DAP’s product owner, says its potential lies primarily in combining data from different departments and finding connections between individual indicators.

Interest in using the DAP is growing steadily alongside the need to process data, both at ŠKODA AUTO and within the Volkswagen Group as a whole. Today, it is already a hybrid platform based in the ŠKODA Data Center in Mladá Boleslav and in the cloud.

None
None

Connect an unlimited number of data sources

None

Combine on-prem and multi-cloud solutions – without any restrictions

None

Enjoy support for batch and stream data processing

None

Take advantage of a license that isn’t tied to data or user volume (ideal for complex and hybrid data environments)

Adoki is process and cost efficient, and we appreciate that it’s fully automated. It’s also easily scalable, so we’re gradually using it to manage more and more data transfers and increasing volumes of data. It gives us a single location from which to replicate data from multiple systems, the data warehouse, primary applications and more. It can be run by a single data specialist, and the tool alerts them to any changes in the data in the source systems, preventing poor data quality.

Jiří Boček, Data Analytics Platform product owner, ŠKODA AUTO

None

3 months

were all it took for Adastra to complete the initial phase of the project, i.e., connecting Adoki to the required data sources

Adoki has consolidated most other ETL tools and technologies

The platform is part of the Data Governance solution 

All transfers are checked and recorded in an auditable history 
1 specialist

All the data transfers are managed by a single IT specialist 

On-premise and cloud environments are brought together 

Adoki met all our expectations, so we’ve started using it not only for data transfers and integrations related to production but also for other departments’ systems.

Jiří Boček, Data Analytics Platform product owner, ŠKODA AUTO


Adoki provides a complete metadata service for all transfers, takes system performance into account, and offers ŠKODA AUTO’s data specialists an intuitive front end

None

In the initial phase of the project, we synchronized 40 data transfers from 8 of the car manufacturer’s key databases. After 6 months, there were almost twice as many transfers; one year on, the number has increased fivefold and is still going up.

In terms of volume, Adoki consistently transfers hundreds of GB of data and ensures complete data governance.


All the data transfers can be managed by a single IT specialist using Adoki.

We combine on-premise and cloud environments

The benefits of the on-premise component include: 

  • its large capacity (149 TB, which is roughly 300 typical laptop disks),
  • fast data processing,
  • the wide variety of formats used,
  • an extensive set of tools for reporting, analytics and artificial intelligence.


At the same time, users from ŠKODA AUTO appreciate that the cloud:

  • offers unlimited capacity for storing data,
  • is easily scalable,
  • provides analytical tools that are always up to date,
  • ensures GPUs are available for compute-intensive operations, and more. 

With the growing interest in uploading and storing data on this platform, ŠKODA AUTO faced the dilemma of how to manage data transfers to and from the company’s various systems and the DAP, as well as between the DAP’s on-premise and cloud components. Before Adoki was deployed, the situation required the involvement of an entire team of specialists and, even then, did not provide a full user service.

For example, setting up transfers could only be done manually; each transfer had to be newly configured and parametrized, and no one received any notifications when a transfer finished. Programming new functionalities would have been possible but costly. This is precisely why ŠKODA AUTO decided to implement Adoki, a central tool that manages and monitors all data transfers. Adoki will also be used for transfers between the on-prem and cloud parts of the DAP.

None

5 times the number of databases

 During the pilot phase, Adoki ran a single operation to transfer and integrate data from 8 key manufacturing databases. Today, the tool transfers data from 40 different databases.

Ad-hoc

Initially, data transfers were carried out 3 times a day, after each production shift ended. Now, they are also done ad-hoc at regular intervals, in line with business requirements. 

Data transfers are performed several times a day

None

Adoki’s first major task was to integrate data from 8 of the car manufacturer’s production databases to the DAP. Today, it integrates data from many other relational systems, including MS-SQL, Oracle, PostgreSQL and SAP HANA, as well as non-relational systems like Jira.

  • On average, hundreds of GB of data are replicated every month.
  • Each transfer is completed within 3 minutes.  


At the beginning, data transfers were carried out 3 times a day, after each production shift ended. Now, they are performed several times a day, ad-hoc, according to business needs and requirements.

  • Transfers are batched: smaller tables are uploaded in their entirety; large transactional tables are done incrementally. 
  • The DAP and Adoki also serve to archive production data.


During the initialization process, when historical data was uploaded to the DAP (from as far back as 2016 for some tables), Adoki had to deal with significantly higher volumes of data. However, individual transfers still completed in under 5 minutes. After transferring the data from the primary systems and checking that the entire process had completely finished, the data specialists could safely delete the data from the source systems to free up capacity.

 

Implementing Adoki was more cost effective than supporting and developing the previous solution

At ŠKODA AUTO, the tool is managed by a single specialist and carries out data transfers to hundreds of target tables. The cost of implementing Adoki was more financially viable than supporting and further developing the solution that was previously in use.


Adoki has accelerated, standardized and streamlined data transfers from key systems to the DAP.


It is entirely automated and unconstrained – it does not limit either the number or size of tables to be transferred, nor does it force ŠKODA AUTO to transfer only select sources.

At the same time, it also ensures data and data structures remain consistent in both the source and target environments. 

None
1

A single specialist manages all the data transfers

200

Today, Adoki carries out data transfers to more than 200 target tables

250

Currently, there are 250 daily production transfers, a number that continues to grow

Audited and monitored transfers that only require a single specialist

None

All data transfers are fully auditable and monitored

If an error or interruption occurs during the course of a transfer, the tool immediately notifies the transfer administrator, who can then easily track down the marked transfer and restart it.

All data transfers, of which there are now 250 a day, are managed by a single person. This is possible because, among other things, the tool uses metadata and parametrization.


Adoki transfers data quickly and securely; the transfer process is covered from end to end. The tool also ensures that the data transfers are automatically optimized so that they maximize computational performance and do not limit the source databases’ operation.

The tool is user-friendly and intuitive thanks to its sophisticated graphical interface.

This is one of the reasons why the specialists working with the tool could be trained in one day. After their training, they can configure data transfers entirely on their own, independent of the Adoki administrator. Users can set up simple transfers within an hour, more complex ones within a day.

Do you also want to speed up, standardize and streamline data transfers? Contact us!

Thank you

We will contact you as soon as possible.

Michal Kratochvíl

Banking Division Director