T24DacBY VULTAR SYSTEMS

T24 DATA ACCESS COMPONENTS

Your T24 data.
Ready for SQL.

Bring Temenos T24 data into the tools your team already knows. Query, report and integrate through standard ODBC and JDBC connections.

Discuss your T24 setup See how it works
Built for T24. Designed for your data workflow.
t24 / account.sqlSQL EXAMPLE
SELECT TOP 3
  _ID, CUSTOMER,
  CATEGORY, CURRENCY
FROM F.ACCOUNT
WHERE CURRENCY = 'EUR'
ORDER BY _ID
Familiar rows. T24-aware fields.3 rows
_IDCUSTOMERCATEGORYCURRENCY
1000012001011001EUR
1000022001021001EUR
1000032001031002EUR
ODBC / JDBCIllustrative data
THE DATA YOU NEED. THE SQL YOU KNOW.
ONE ACCESS LAYER.
YOUR T24 BACKEND.jBASEOracleMicrosoft SQL ServerODBC JDBC

01 / BUILT AROUND T24

T24 is different.
Your tools don’t need to be.

T24Dac bridges the gap between the way T24 stores data and the way SQL tools expect to work with it.

SQL you already know

Select columns, filter records, sort results and build nested queries. Bring familiar SQL to your T24 reporting workflow.

QUERY & EXPLORE

Multivalue, made tabular

Expand T24 multivalues and subvalues into rows, or select individual values when your report needs a precise view.

T24-AWARE DATA HANDLING

Standard connections

Use a Windows ODBC driver or a Java JDBC driver to connect SQL-compatible reporting, analytics and ETL tools.

ODBC & JDBC

Your fields, included

Work with T24 local fields alongside standard fields, with field-type recognition and explicit type conversion.

LOCAL FIELDS & DATA TYPES

From records to reports

Use nested selections, grouped results and aggregates such as SUM and COUNT to prepare data for analysis.

AGGREGATE & EXTRACT

Go deeper with TAFC

Access linked fields, user-defined functions, stored procedures and jBASE EVAL in supported TAFC environments.

TAFC-SPECIFIC EXTENSIONS

02 / A CLEAR PATH TO YOUR DATA

From T24 records
to SQL result sets.

Your application submits SQL. T24Dac retrieves the records, resolves the T24 structure and returns tabular results.

YOUR T24 ENVIRONMENT
01TAFC / jBASE
02Oracle
03Microsoft SQL Server
THE ACCESS LAYERT24Dac.Retrieve · Normalize · Deliver
T24 fieldsSQL results
YOUR EXISTING TOOLS
Reporting & analytics
ETL & data warehouses
SQL & Java applications
Connected through ODBC / JDBC
01

Connect to your backend

Configure a connection for TAFC/jBASE or direct access to Oracle or Microsoft SQL Server.

02

Let T24Dac do the translation

The server parses records, handles repeated values and prepares normalized result rows.

03

Keep your familiar workflow

Your client receives a normal SQL result set through its ODBC or JDBC connection.

Explore the architecture

03 / PUT YOUR DATA TO WORK

One connection.
More possibilities.

Give reporting teams, data engineers and application developers a shared way to access T24 data.

/ 01

Reporting & analysis

Explore accounts, customers and other T24 applications with SQL. Shape the records your reports need.

FOR REPORTING TEAMS
/ 02

Data extraction & ETL

Feed T24 data into warehouse and integration workflows using tools that support ODBC or JDBC.

FOR DATA ENGINEERS
/ 03

Application integration

Connect Java applications through JDBC or Windows applications through ODBC, using standard database interfaces.

FOR DEVELOPERS

04 / TAKE A CLOSER LOOK

The technical details.
Clearly explained.

Explore the connection options, query syntax and result-delivery model before planning your setup.

TECHNICAL GUIDEGet to know T24DacDrivers, backends and the data flow.KNOWLEDGE BASEFind your next stepSetup instructions, SQL examples and configuration help.

05 / DOWNLOADS

Get T24Dac.

Download the software package and use the knowledge base to set up your server and client connections.

Read the setup guides
SOFTWARE PACKAGE · ZIP

T24 Data Access Components

t24dac.zip

Download t24dac.zip

Need help with your environment? Contact us.

GOOD TO KNOW

A few practical
questions.

Which T24 backends can I connect to?

T24Dac provides a TAFC/jBASE connection and direct connectors for Oracle and Microsoft SQL Server. For TAFJ environments, the documented approach uses the corresponding direct database connector. Contact us to confirm your particular setup.

Can I keep my existing reporting tools?

If your tool supports ODBC or JDBC, it can use the corresponding T24Dac driver. The Windows ODBC driver comes in 32-bit and 64-bit versions; the JDBC driver is written in Java. Confirm your tool, driver architecture and environment together during evaluation.

How are multivalues and local fields handled?

T24Dac understands T24 multivalues, subvalues and local fields. You can expand repeated values into rows or address specific values. The correct selection and expansion depend on the fields and result shape your report needs.

How do I get started?

Tell us about your T24 environment, database backend and intended ODBC or JDBC client. We’ll help you discuss the connection approach, software availability and evaluation requirements.

Contact Vultar Systems

LET’S CONNECT

Make more of
your T24 data.

Tell us about your environment and what you want to achieve. Let’s find the right connection.

Discuss your T24 setup office@vultar.md+373 69 125 772Vultar Systems · Chișinău, Moldova