× 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
  • Posts: 17
  • Thank you received: 3

SandroK created the topic: DW integration

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
#22784

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

  • Posts: 147
  • Thank you received: 11

silvergem replied the topic: DW integration

You can use the T24 API or IRIS framework
#22903

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 814
  • Thank you received: 115

VK replied the topic: DW integration

Hi
for R14? :)))
#22906

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

  • SandroK
  • Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 17
  • Thank you received: 3

SandroK replied the 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
#22909

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

  • Posts: 147
  • Thank you received: 11

silvergem replied the topic: DW integration

I think so since the video related to IRIS was publish 6 years ago
#22911

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 814
  • Thank you received: 115

VK replied the topic: DW integration

Hi SandroK,
ideal choice! good luck...
#22913

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

Time to create page: 0.122 seconds