Tezauri Data Integration
Looking for ETL Tool fully aligned with IFW BDW models? Use Tezauri Data Integration Tool for developing State of The Art ETL system on IFW BDW implementation projects.
The Business Challenge
The Extract, Transformation, and Load (ETL) system is the most time - consuming and expensive part of building a data warehouse and delivering business intelligence to your users' community. A decade ago the majority of ETL systems were hand crafted, but the market for ETL software has steadily grown and the majority of practitioners now use ETL tools in place of handcoded systems. There are a lot of advantages in use of ETL system such as: Visual flow 4 and self-documentation. The single greatest advantage of an ETL tool is that it provides a visual flow of the system's logic. Structured system design. ETL tools 4 are designed for the specific problem of populating a data warehouse. Although they are only tools, they do provide a metadata-driven structure to development team. Operational 4 resilience. Many of the evaluated home-grown ETL systems are fragile: they have too many operational problems. ETL tools provide functionality and practices for operating and monitoring the ETL system in production. Advanced data cleansing 4 functionality. Most ETL systems are structurally complex, with many sources and targets. At the same time, requirements for transformation are often fairly simple, consisting primarily of lookups and substitutions.
Tezauri Data Integration Key Features Fully aligned 4 with IFW BDW models Innovative Message Concept which 4 simplifies data mapping between source data structures and BDW models Custom developed SSIS components 4 with encapsulated logic for metadata usage Agile ETL system development tool, 4 metadata based Can be used 4 for various data sources Can be adjusted for asynchronous 4 and near to real time data load Developed on Microsoft SSIS and 4 .NET platform The Pexim Advantage
18 years in banking vertical 4 World's first 4 IFW based core banking built on .Net Core banking 4 running in 31 banks E-banking product used in 33 banks 4 BDW based 4 business intelligence product running in 5 banks Member of 4Asseco group – one of the leading European IT corporations IBM Business 4 Partner Microsoft Gold 4 Certified ISV Partner ISO 9001 Certified 4
Solution
Tezauri Data integration Tool is an ETL software development tool fully aligned with IFW BDW concept. Innovative Message Concept and well designed metadata model together with custom developed components and Tezauri Manager as central application for system management, allows you to produce state of the art ETL system for your IFW BDW based data warehouse regardless of where you source data is stored.
Benefits
Capitalizes your investment in IFW 4 models by giving you state of the art ETL tool aligned with data models Solves the data structure gap between 4 IFW models and data models of operational sources Raises the abstraction level for ETL 4 developers, enabling them to focus on data concepts instead on bits and bytes Rapidly improves speed of system 4 development Custom developed SSIS components 4 with encapsulated metadata logic make ETL applications much more simple Enables easy 4 ETL system management including metadata Enables real 4 time metadata documentation generation and reporting
(continued on back)
(continued from front)
www.pexim.net
Innovative Message Concept
Message Concept is designed as a staging area between source systems and BDW in order to simplify and improve efficiency of ETL process. Major features of this Message Concept are: Messages are 4 derived from BDW data concepts and entities Small number 4 of entities, up to 20, represented as highly renormalized BDW entities Extensive usage of XML for storing 4 results of complex transformation Physical representation of Messages can 4 be: Entities (Tables), Files (txt, XML, etc.), Memory objects Message structure is build on top of 4 different types of attributes (classifications, domain mapped attributes, descriptors, etc.) Adjustment 4 for asynchronous and near to real time data load
Classification 4 metadata - Schemas - Values Messages metadata 4 Mappings metadata 4 - Classification - Surrogate Keys - Descriptions - Products ETL transformation metadata 4 - SSIS packages, tasks, groups - Jobs - Execution results Data Quality 4 metadata - DQ rules and rule sets - DQ check results
Expression 4 Engine. This is one of the most important building blocks in TDI environment. TDI EE is extensively used for building Data transformations, Data mappings, DQ rules.
Tezauri Manager
Tezauri manager is enterprise desktop application, which enables development and maintaining of Tezauri DI solution. Main purpose of this tool is: Metadata Management 4 Development/Implementation 4 Configuration/Administration 4 Maintenance/Monitoring 4 Major Features: Specialized 4CDC system oriented to batch processing Organizes source tables into logical 4 parts (Subject Areas) named Source Systems and Subsystems Defines and 4 maintains the logical and physical structure of Message Relates attributes to Classification 4 Schema Surrogate key 4 management IBM FSDM is 4 classification oriented data model Classification 4 Module enables creation and maintenance of classification schemas and values Quality of data 4 can be evaluated through different types of rules
Custom developed SSIS Components
Custom developed SSIS components are intended to encapsulate application logic of metadata and hide it from the developers. TDI has the following custom developed SSIS components: Message Mapper. Mapping Source 4 System structures to BDW. Classification 4 Resolver. Mapping Source System Values to BDW CL data concept. Surrogate Key. Surrogate Key 4 management based on metadata. Accounting 4 Unit Key. Management of accounting unit keys, based on relationships between Arrangement, Accounting Unit Type and Accounting Unit Balance.
Metadata model
Tezauri Data Integration extensively uses metadata in order to enable high efficiency and control of ETL process. All metadata are stored in common, unified TDI metadata model. There are several metadata sources: Metadata related to operational data 4 - Tables and columns metadata - Keys and relations metadata - Constraints and rules metadata
Pexim Solutions
BELGRADE: Goce Delceva 44, 11070 Belgrade, Serbia, phone: +381 11 2013 111, fax: +381 11 3015 132, e-mail: contact@pexim.co.yu SKOPJE: Naroden front 17, 1000 Skopje, Macedonia, phone: +389 2 3248 000, fax: +389 2 3216 621, e-mail: contact@pexim.com.mk