This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4843 IT projects that we have successfully completed with our customers.How can we support you?
Developing an automatic connection to a commercial credit insurance system
Project duration: 10 months
Brief description
In the context of the company-wide introduction of new ERP software, an analysis, technical implementation and the developer test for a data interface in the area of the company's credit management are carried out. The implementation sets up an automated interface between the ERP software and the commercial credit insurance system for daily, time-controlled, bi-directional data transmission.
Supplement
Each day, customer, document, seller and network data are supplied via an SQL database from the ERP software. Changes to the data compared to the previous day are transferred to various files and then transmitted to an external system of the commercial credit insurance company's. The data are used as the basis for evaluations which enable the company to react to possible payment defaults. The interface is based on SQL Server Integration Services (SSIS). An integration service package plan is configured via the SQL Server Agent for the SSIS packages generated. The SSIS packages are implemented using SQL Server Data Tools (SQL Server Management Studio, Visual Studio).
Subject description
The aim is to hedge against payment defaults from the company's accounts receivable, as well as to reduce credit costs.
IT project data
- Industries trade
- Specialist tasks accounts receivable management, credit management, interfaces
- DP tasks IT consulting
- System environments Client/Server
- Procedure model customer standard
- Programming languages SQL
- Databases MS SQL Server
- Development and test tool MS Visual Studio, Notepad++
- System software TortoiseSVN
- Middleware and frameworks MS SQL Server Integration Services (SSIS)
Project period16.11.2016 - 30.09.2017
Customers who trust us
Have we sparked your interest ?
