|
|
 |
 |
|
| |
|
Home > Our Solutions > Data and metadata access, exchange and integration |
| |
Data and metadata access, exchange and integration | |
| |
|
|
|
“Revamping the IT environment, be it heterogeneous and complex ” |
|
|
In the very heterogeneous environments highly diverse as for their material platforms, their databases and their applications, an underlying challenge : consolidating this data and converting it in a right, logical and relevant information.In the face of the spectacular increase of the volume for the data required to feed the analytical applications with the most features, another challenge : increasing the storage capabilities of the business datawarehouses, all this being tantamount |
|
to significantly increasing the size during the loading processes of databases and multiplying the associated constraints. | |
| DKB Solutions offers a high-end technology for data and metadata access, exchange and integration: |
|
|
Performing all the data exchange operations : whatever the form of the data, the source and the target |
|
Loading for the relational structures, the complex files or the multidimensional structures, following the most sophisticated rules for transformation |
|
|
Centralized repository for metadata : some sixty tables for relational databases and all the information describing the data loading and exchange processes for the business. |
|
|
No proprietary storage format : the repository is completely integrated to an existing database (Oracle, Microsoft SQL Server, Sybase, Sybase SQLAnywhere, Informix, UDB/DB2). |
|
Classic ETL mode : data extraction from the source database, simple or complex transformations in the performing engine and loading this data within the target database. |
|
|
Importing all the structures for the tables with the different keys, primaries as foreign, according to the access rights defined by the data administrators. The user visualizes the content of the tables |
|
|
Retrieving the structure for the tables, the physical relations between these tables (to reconstitute data models) ; also retrieving the rules managed by the DBMS or the conception tools (authorized values, minimum and maximum values, etc.) |
|
|
Loading a maximum of target structures from a same set of data originating from heterogeneous databases : tables for relational databases, tables for the main office automation standards, SAP tables, multidimensional structures, flat files, XML files . |
|
|
|
Creation by the user of his/her own transformation rules (Macro Functions) with the use in each of his/her loading processes. | |
|
|
For a better traceability for the loading processes : chart for the data flow, chart for the database dependencies . | |
|
|
SAP certification for the Business Information Warehouse loading, and ALE converter, in compliance with the SAP rules | | |
| |
| |
|
|
| |
Hummingbird illustration
| |
|
| |
|
|
|
| |
|
