migrations

In cooperation with UBS AG, we are creating a standard application for entering signatures in the signature register and publishing them on the Internet. The aim is to be able to offer the signature solution created for UBS AG to other companies in the form of a standard solution. For this purpose, the system was standardised on the basis of Oracle, JBOSS, DROOLS and JBPM. Drools makes it easy to define the rules and JBPM ensures the correct execution of the workflow.

Migration of the prototype database compiler created in 2003-2006 from Microsoft SQL Server to Oracle, Jboss, Drools and JBPM. The database compiler is still the core of the application. With the help of the compiler, the workflows for sheet data processing are created and stored in the database in the form of stored functions or procedures (PL-SQL). However, standard products such as Drools are now also used for the application's set of rules and JBPM for the timed execution of the workflows. The user interface is migrated from Microsoft VB to Java. A data migration from Microsoft SQL Server to Oracle is also taking place. The various tools for process monitoring and fully automated signature clean-up are left in C#, only the logic is adapted to the new infrastructure.

The aim of the project is to migrate a Cognos data warehouse to Microsoft SQL Server. The ETL routes were implemented using stored procedures in T-SQL or SSIS packages were created.