During the transformation of the original customer IT architecture into a new form based on Service Oriented Architecture, it was decided to create several new systems corresponding to this approach.
These systems included an Operational Data Store, an Analytic Data Store (data warehouse) and a database for a new approval system (NAS DB). Developing new banking systems is a costly exercise, and from the beginning the need to address issues emerged, in particular, labour productivity development, quality documentation solutions, standardization of generated code, using design patterns for creating program code, the automation of routine activities and quality control development. Identifying how to deal with the impact analysis of changes to the systems, an extremely challenging task, was of central importance.
Our vast experience in developing ELT generators was called upon to address these problems in the context of three new systems (NAS DB, Operational Data Store and Analytic Data Store).
We have also extended the functionality support for generating API, creating a completely new range of generators capable of generating a system interface for communications with the enterprise service bus (ESB). The best available tool for modeling relational databases, the Sybase PowerDesigner, was selected as the foundation for working with metadata and it was extended by our ELT generators to support the API functionality needed for development and quality control development. The current ELT generators have also been expanded to the customer's specific needs and, based on the capacity of the current version of the Oracle Database, gradually migrated to the systems.
Thanks to the ELT/API generators acquired from Adsatra, the customer has a highly flexible and effective tool for creating data transformations using metadata in the field of data warehousing and OLTP systems.
Using design patterns and procedures Adastra learned from a wide range of integration projects featuring API and ELT generators, a variety of interesting properties came about: a high degree of standardization, automatic documentation, integrated quality control development, and superior performance of the generated code. The time required for developing an API or ELT was reduced to hours instead of the original four days.
As there is no need to pay any licensing fees for a specialized ETL tool, the native integration of the impact analysis on change results in a favourable purchase price. When you purchase licenses for the Sybase PowerDesigner the bank can independently implement the development of our supplied API and ELT, or create them using our brand new generators.
How do you create a data warehouse and bank reporting for a newly established bank? Would you like to know? Keep reading! Equa bank is exactly such a case. Not only that, the bank requested some data from an online data warehouse. No small feat considering the data had to keep its consistency and be integrated in the data warehouse to provide an…
The bank opted for a new CRM solution. Switching to a new system, however, could not be successful if, at the onset, it lacked all the necessary data stored in the original CRM. For a successful transfer to take place, all required data must be extracted and uploaded into the correct place, on time, and in such a way that all customer requirements…
The Adastra Banking Data Model (ABDM) has enabled our customer to build a completely new system for approving loan products, an Operational Data Store and a new consolidated data warehouse (Analytic Data Store). The banking model continues to prove its flexibility and efficiency above all other solutions that use this model even after many years…