XPS Database Conversion Service
Service Definition Database Conversion
Database Conversion is the process of moving application data
from one database to another
T24 Database Conversion is typically from jBASE database to
one of the three industry standard database systems
Oracle
DB2
MSSQL
2
Service Delivery Methodology Database Conversion
Implementation
Optimisation /
Tuning
Build Phase
(offshore)
Assessment
Phase
Temenos leading Technology Partner leading Client leading
Technology Partner supporting Temenos supporting Temenos and Partner supporting
3
Assessment Phase Database Conversion
T24 & RDBMS High Level
Architecture Migration
Workshop Scoping Planning
Environments Impact & Risk Assessment
Planning & Analysis Report
Guideline
Sizing
Temenos leading Technology Partner leading Client leading
Technology Partner supporting Temenos supporting Temenos and Partner supporting
4
Assessment Phase – Client Pre-Requisites Database Conversion
• Process
• Approved RFS for Assessment Phase
• Alignment with Offshore XPS team for Scoping
• Infrastructure
• T24 Test environment – copy of production
• VPN Connectivity preferably through Remote Desktop
• Software
• Putty/Similar emulator to access Unix environment from remote desktop
• File editor ( notepad ++ ), ftp software, MS office
• Support
• System Administrators ( VPN, Remote Desktop, Unix )
5
Build Phase Database Conversion
Database Migration
Migration Test Runs Runbook
Custom Tools and RDBMS Reference
Scripts Environment
Temenos leading Technology Partner leading Client leading
Technology Partner supporting Temenos supporting Temenos and Partner supporting
6
Build Phase – Client Pre-Requisites Database Conversion
• Process
• Completion of Assessment Phase
• Approved RFS for Build Phase
• Infrastructure
• Three T24 development environments – copy of production
• RDBMS installation complete with recommended configurations and available for
hosting two T24 Database
• VPN Connectivity preferably through Remote Desktop
• Sufficient disk space on t24 server & DB server including logs, data backups
• Software
• DCD License to be purchased ( new TAFC will be delivered )
• DCD License installed and successfully tested for current jBASE installation
• RDBMS Conversion tools to be requested from Distribution
• Putty/Similar emulator to access Unix environment from remote desktop
• File editor ( notepad ++ ), ftp software, MS office
• Support
• System Administrators ( VPN, Remote Desktop, Unix )
• Database Administrators ( Installation, Configuration, Backup, Restore )
7
Optimisation Phase Database Conversion
T24 Performance Database Performance
Tuning Tuning
Performance Testing Database Architecture
Compliance
Temenos leading Technology Partner leading Client leading
Technology Partner supporting Temenos supporting Temenos and Partner supporting
8
Optimisation Phase – Client Pre-Requisites Database Conversion
• Process
• Draft/Completed Run-book from Build Phase
• Infrastructure
• T24 Test environments – copy of production
• RDBMS installation complete with recommended configurations and available for
hosting the T24 Database
• Production-like hardware sizing
• Software
• Pre-requisites as mentioned in the run-book
• Support
• System Administrators ( VPN, Remote Desktop, Unix )
• Database Administrators ( Installation, Configuration, Backup, Restore )
• RDBMS Performance Tuning Specialist ( to be resourced by Client )
9
Implementation Phase Database Conversion
Skills Transfer Migration Rehearsals
User Acceptance Test GoLive
Temenos leading Technology Partner leading Client leading
Technology Partner supporting Temenos supporting Temenos and Partner supporting
10
Service Package Database Conversion
Database Migration Full Service
• Duration
• 3 weeks of Assessment
• 10-12 Weeks of Build Phase
• 2 weeks of Optimisation
• Implementation as planned by the client
• Deliverables
• Assessment Report
• Run-Book for Implementation
• Custom Tools/Scripts
• Converted Environment for Reference
11
Solution Highlights Database Conversion
Temenos Governance
Feasibility Study
Architectural Guidance
Migration Estimates and Planning
Technical Migration Guide with localised tools/scripts
Optimisation
Mock & Production Deployment Support
12
Thank You
