× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Interconnecting T24 (JBase) with other databases

  • MStiocic
  • Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 9 months ago #21916 by MStiocic
Hi all,

Simple question. Is it possible to interconnect a T24 (R14) JBase database with other databases (particularly Oracle) so that the two communicate and exhange data?

Can it be done via jEDI and ODBC?

Thanks in advance!

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
6 years 9 months ago #21919 by VK
Hi
everything is possible but what for? You can use Oracle Direct Connect driver from Temenos to store T24 data in Oracle (in XML format). Using it allows to still use native jBASE hashed files as well.

If you want some other Oracle DB engine to update T24 data, you'll not be able to do that because most of DB update logic is at T24 application level.

Cheers
VK

Please Log in or Create an account to join the conversation.

  • MStiocic
  • Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 9 months ago #21920 by MStiocic
Thanks very much for the reply.

There are basically two databases; the T24 (jBase) one, and an Oracle one.

The Oracle database contains data which are associated with the data in T24 so I don't want to maintain two databases which may contain the same data since this is error-prone.

So basically my question is whether I can acccess the data in the Oracle database via the T24 application.

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
6 years 9 months ago #21922 by VK
Hi
If your Oracle data is a regular RDBMS DB I afraid the answer is no... (or you'll have to apply something complex like call Java class from Basic)

Also - the whole architecture looks wrong to me.

Cheers
VK

Please Log in or Create an account to join the conversation.

Time to create page: 0.044 seconds