Data Extractor

Project description

BDO asked us to create a software solution to improve their current procedure for extracting data from the databases of their customers . This solution should be able to connect to each customer's database at their premises and should therefore be configurable in accordance with their situation. This data should then be sent to the BDO for processing on their Data Platform.

Context

BDO is an international accountancy and advisory organization. As a part of their services, they offer the BDO Data Platform which applies their customers’ data, including a process of convergence, enhancement, and enrichment, to provide useful information to their customers in the shape of reports, provisioned data, or perceptive communication.

Before any of these data driven services can be offered, the data needs to be extracted from the customer. At the moment, data is extracted bi-annually. This process involves running a script manually and thus requires at least some technical knowledge on the customer’s side. Furthermore, manually extracting and sending the data is time-consuming, tedious, and error prone.

Results

We have created an easily installable and configurable client-side application that can automatically extract data from customer databases (using unique scripts provided by BDO) and sends it over to BDO for processing.
In addition, we have created a web application to monitor the incoming data and data extraction processes.

About the project group

Our group consists of 5 ICT & Software students in either their sixth or seventh semester, with specializations in artificial intelligence (AI) and cyber security and previous experiences with multiple companies through group projects and internships.
We have worked on the BDO Data Extractor since the beginning of September.