Processing of address data from an external provider for internal company address database
Brief description
In future, the maintenance and collection of customer address data is to be carried out by an external service provider. In order to load the data into an existing, internal address management tool, an interface is required which prepares the external data and writes it into the existing database.
Supplement
This system is a client-server architecture with a MS SQL Server 2012 database as backend and a console application of .Net 4.6.2, developed with Visual Studio 2017.
Subject description
The address management tool used in the company is an individual software developed by PTA. When transferring the data, the extensive processing logics that are otherwise carried out by the address management tool used in the company must be taken into account, since it is planned in the long term to have the data maintained by the external service provider and no more internal company processing or maintenance is to be carried out. The prepared data is required in many areas of the company (e.g. ordering processes, invoicing) and must therefore be available without changes.