× 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
3 years 9 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
  • silvergem's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
3 years 7 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
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
3 years 7 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
3 years 7 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
  • silvergem's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
3 years 7 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
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
3 years 7 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
2 years 8 months 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.140 seconds