Transforming a Software Licensing Advisory Solution

Approaching the problem, an entity relationship diagram and the as-is processes were documented to inform development of the solution that also focussed on ensuring that all database tasks are performed inside a single SQL Server Express instance, rather than both the staging application and a SQL Server database. This makes the system easier to deploy, maintain and develop.

The open-source Talend Open Data Studio ETL was selected as it has a non-cloud option (meeting the on-premise requirements) and a low-code development environment (allowing a larger range of Synyega employees to contribute to running, maintaining and expanding ETL processes).