Consolidation and analysis of data

All our software packages include basic tools for working with large data arrays, including sampling and data presentation tools, have a built-in mechanism that supports working with external data sources in various formats.

There are a number of basic tools:

• SrFileDataLoader is a universal module for loading structured files in different formats into a database
• SrETL is a multi-threaded robotic replicator of data from an arbitrary number of source databases according to a given schedule
• SrReporting is a comprehensive solution for reporting in a variety of formats based on a single repository of reporting forms
• SrXlsImport is an intelligent module for fast setup of formats and loading of tabular data from XLS, XLSX files
• SrSQL is a designer for automatic construction of SQL queries
• SrGrid is a designer for setting up dynamic Grids according to the master-detail scheme, with universal data sampling mechanisms at the level of simple and complex filters. It is used as a basic mechanism for fast data visualization.

All necessary tools for import, export, visualization and data processing are included directly in the technological core of SrCoreSystem, including:

• Development, automatic forming according to the regulations and visualization of aggregated analytical storefronts
• Visualization of loaded primary data and analytical storefronts with flexible configuration of display formats and user access rights

A number of banks, as well as the Deposit Guarantee Fund, have been successfully using our SrWarehouse product for many years – a universal analytical data storage based on the Oracle database, which includes all the technologies listed above.