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

DW integration

Start
Prev
1
Next
End

SandroK
Topic Author
Offline
New Member

4 years 5 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
TAFC|R12/R13, TAFJ|R20

4 years 3 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
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

4 years 3 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

4 years 3 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
TAFC|R12/R13, TAFJ|R20

4 years 3 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
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

4 years 3 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.

accrakimono
Offline
New Member

3 years 4 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.

Start
Prev
1
Next
End

Time to create page: 0.092 seconds