Menu
This is one of 4544 IT projects that we have successfully completed with our customers.How can we support you?
Service and database synchronisation
Project duration: 2 months
Brief description
The aim of the project is to develop alternative solutions for the regular import of data from various web services into a target database of the customer. The solutions should be easily extendable so that new web services can be connected at any time with little effort. On the one hand, the PTA is developing a prototype based on Spring-Boot. Secondly, the data imports are implemented with an ETL/ELT tool (Apache Nifi). While the Spring Boot application maps individual aspects of a web service, e.g. the transformation of data into a uniform format in individual Java classes, these are configured in individual steps (processors) in an ELT/ELT tool on a graphical interface.
Supplement
The customer's wish to connect additional web services at any time requires a high degree of configurability of the solution. Both of the approaches proposed by PTA fulfil other aspects in addition to expandability and configurability, such as robustness in case of error and security. The Spring framework offers support for this through dedicated libraries such as Spring-Data, Spring-Web, Spring-Security or also Spring-Integration and Spring-Batch. The advantages of Apache Nifi are, in addition to the graphical interface, the intuitive configurability and the wide range of existing processors. Both solution variants are based on open source and thus minimise the costs for implementation.
Subject description
Spring is the world's leading Java framework and enables fast, easy and productive programming. It is particularly used in the area of individual micro services, which can also run in the cloud. This enables resource-efficient processing of data. Due to the large number of libraries that Spring offers, flexibility for future developments is guaranteed. The developed program for synchronization is therefore future-oriented and can be individually extended by the customer. Apache-Nifi is a scalable application in the sense of an ETL/ELT tool. In comparison to an individual software development via e.g. Spring Boot, a large part of the programming is not necessary. In contrast to Spring, the implementation takes place via configuration, which ensures intuitive handling. Security is guaranteed by configuration of e.g. HTTPS and multi-user authentication.
Overview
- Branchen trade
- Fachaufgaben ETL, software development, Unit-Tests, Webservice
- DV-Aufgaben Prototyping
- Systemumgebungen Client/Server, technical data processing
- Vorgehensmodell iterative procedure
- Datenbanken Apache Nifi
- Entwicklungs- und Testtool IntelliJ
Project period28.08.2020 - 14.10.2020
Have we sparked your interest?
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
