Scribd
Upload
243 views

How To Connect and Extract Data From T24 Oracle XML

This document provides tips on connecting to and extracting data from a T24 Oracle XML database using QlikView. It discusses installing Oracle Client, configuring the tnsnames.ora file and an ODBC connection, and connecting to the database in QlikView. Assistance from a T24 consultant may be needed to understand the database structure and identify specific data to load.

Uploaded by

Zakaria Almamari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
243 views

How To Connect and Extract Data From T24 Oracle XML

This document provides tips on connecting to and extracting data from a T24 Oracle XML database using QlikView. It discusses installing Oracle Client, configuring the tnsnames.ora file and an ODBC connection, and connecting to the database in QlikView. Assistance from a T24 consultant may be needed to understand the database structure and identify specific data to load.

Uploaded by

Zakaria Almamari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

How to connect and extract data from T24 Oracle XML

Hi, I just want to use the opportunity to share some tips on my experience with working on T24
database source which was really challenging for me. The Qlik community has been a lot of help for me
on Qlik projects and have had to rely on the many professionals and users documents and tips to aid
myself. And this has led me to put up this little piece hoping I could also contribute my little to this
wonderful community. T24 is a core banking application by Temenos AG Switzerland majorly used by
Banks in Nigeria. The commonly scripting language used by T24 is called jBASE and although there are
known connectors for T24 database which are independently developed by people such as one by Vultar
and another connector by Temenos as well.

I would be focusing on setting up a connector for Oracle and extracting the data with QlikView. The
Oracle database is in XML format.

First, install Oracle Client 11g home which can be downloaded from the oracle website. You can see the
following links by other various people on the Qlik Community to guide you more on that. See here and
here. Upon the successful installation, navigate to the oracle path on the C drive - “C:\oracle\
Administrator\product\11.2.0\client_1\Network\Admin” and edit the tnsnames.ora file.

You can create as many connection on the tnsnames.ora file by label each with a unique name to guide
yourself and others about each connection setup.
Once the above is completed successfully open the ODBC Data source Administrator and add a new data
source. Select the Oracle home 11g and input the IP address for the T24 server details, Use the Test
connection tab to ensure all credentials are accurate to give you a Test Connection successful message.

Press Okay and Exit the ODBC Data source Administrator.

Note: Create its important one creates a system DSN configuration for ODBC data source and not a user
DSN. Using a User DSN results to failure reloads when setting up data reload or refresh on the QlikView
server.
Use QlikView Desktop to connect to the database by selecting the ODBC connection.

Input the required credentials to ensure a successful connection.

The connection to the T24 database has been established but to retrieve meaningful data would require
additional information or expertise from a T24 consultant or Administrator.

After successfully connecting to the T24 Oracle Database, to select and pull data requires some form of
understanding of the T24 database structure. Using the jBASE command on Reflection or VOC or the
command prompt which I am not properly familiar with. With help from specialist on jBASE tables and
fields to pull into QlikView should be identified.

Also the use of Oracle SQL Developer to quickly search for table names and columns to identify data to
be loaded. It also good to note that the use of a looping script so as to load multiple load statements
without having to type repeatedly the different table names for different company data.
Please feel free to add to this document or drop comments.

Ayodele Makun

You might also like