Extract Transform Load (ETL)
provides for flexible, scalable and efficient data extractions, normalization and loading into an Operational Data Store (ODS), which serves as a conduit for subsequent aggregation in a Data Warehouse (DWH). The solution has been customized to work with TEMENOS' T24™ core banking solution and can additionally integrate data from other banking and non-banking sources. Sophisticated, automated workflows can be designed via an intuitive GUI and enabled on-demand. Real-time "Eye in the Sky" monitoring and process controls are available to the Bank, including the provision for manual or automated rule-based data unification, harmonization and enrichment, prior to final historization in the DWH.
Frametexx provides support for:
- Multi-Company setups, all T24™ tables, fields, I/J descriptors, local reference and local development fields.
- Full T24™ support including compatibility with all new T24™ components, e.g. TOCF (online), OFS (batch), TSDK, TAG etc.
- Highly optimized, multi-threaded ETL for "raw" data export and "direct" loading into high-performance RDBMS.
- Automated, Optimized Indexing and Historization of Bank Data.
- A repository for resolving foreign key relations between Temenos T24™ applications.
- Data Security via encryption and decryption.
- Clustering and Load balancing.
- Optimized, cost-effective Storage, Retrieval and Archival via "valid-to-date" partitioning.
- Specialized procedures to handle large objects.
- Pre-Built interfaces to ATM (ISO8583), FIX, Schufa, Reuters and other middleware.
- Common standards like XML, J2EE, SQL, etc.
- Deployment of all workflows as WebServices in an SOA environment.
- Full development environment including version control and release management.
All standard T24™ data (Customer, Account, Statement Entry, etc) can be extracted & aggregated for data warehousing, analysis and business intelligence.
The Frametexx features provide:
- Comprehensive and flexible workflow design via easy to use GUI.
- Decoupling of analysis and reporting from core systems.
- Automated data transfers including triggers by change data capture.
- Client directed Intra-Day Extractions
- Real-Time mirroring of T24™
- High Performance, Reliable, Scalable mass & granular data transfers
Benefits
- Real Time Access to Bank Data
- Shorter Close of Business Cycle
- Easy Realization of Business Rules
- Improved Data Integrity/Security
- Data Unification & Harmonization
- A Single Source of Truth