× Discuss on Insight, business intelligence and reporting, Regulatory, Risk, Financial & Performance, Monitoring with Systar, T-Risk, ALCO Reporting, etc…

DW integration

  • SandroK
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 11 months ago #22784 by SandroK
DW integration was created by SandroK
Dears,

R14/tafc/JBase/Linux.
Quite often we use simple listings like:
LIST FBNK.LD.LOANS.AND.DEPOSITS WITH VALUE.DATE EQ 20200531 WITH CATEGORY GE 21050 AND WITH CATEGORY LE 21074 BY CURRENCY BY CATEGORY BREAK-ON CURRENCY BREAK-ON CATEGORY TOTAL AMOUNT TOTAL LOC.CNT DET-SUPP HDR-SUPP
that generates the report like:
CURRENCY  CATEGORY  AMOUNT.............  Count

             21050             36643.55     48
             21053             125961.4    137
             21057            108611.52     10
             21058             24084.59    245
             21064               125000      1

Is there any simple way to integrate such data into tools like PowerBI?

Thanks a lot
Sandro

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

  • silvergem
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13
More
1 year 9 months ago #22903 by silvergem
Replied by silvergem on topic DW integration
You can use the T24 API or IRIS framework

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R22
More
1 year 9 months ago #22906 by VK
Replied by VK on topic DW integration
Hi
for R14? :)))

Cheers
VK

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

  • SandroK
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months ago #22909 by SandroK
Replied by SandroK on topic DW integration
VK, I assume there is no IRIS framework for R14/tafc.
Now we go by developing local API routines, that just returns the raw data we require in JSON or XML format.
I guess this is the only "easy" way to get through

Thanks
Sandro

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

  • silvergem
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13
More
1 year 9 months ago #22911 by silvergem
Replied by silvergem on topic DW integration
I think so since the video related to IRIS was publish 6 years ago

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R22
More
1 year 9 months ago #22913 by VK
Replied by VK on topic DW integration
Hi SandroK,
ideal choice! good luck...

Cheers
VK

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

More
10 months 2 weeks ago #23395 by accrakimono
Replied by accrakimono on topic DW integration
You can check out my PHP code that converts OFS response to JSON on GitHub: github.com/stephentwig/TemenosTransactT24

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

Time to create page: 0.130 seconds