Hi Stuart,
thanks a lot for your answer.
So, we will stay with the TM1 Rest API and will have an look into the httpcomponents.
Sorry, for my newbie question, but we have not so much experience with TM1, yet. So, what are TI processes doing and how can we get the results (structure, CellSet). Are they stored in a view, which we can adress via Rest API?
And for gaining more basic knowledge about TI Processes, could you recommend a link for getting more insights?
Best regards,
Marco
------------------------------
Marco Spyker
------------------------------
Original Message:
Sent: Thu September 16, 2021 07:28 AM
From: STUART KING
Subject: TM1 Java API or TM1 REST API
Hi Marco,
I would recommend using the REST (ODATA) API instead of the Java API. While the Java API is not deprecated, we do not plan to carry it forward to the next major version of TM1 Server.
If you are developing in Java you might want to consider investigating something like HttpClient (https://hc.apache.org/httpcomponents-client-5.1.x/).
In regards to moving big data, the best option today is still TI processes. Note that you can create, update, delete, and execute TI processes with the REST API.
------------------------------
Stuart King
IBM Planning Analytics Offering Manager
Original Message:
Sent: Wed September 15, 2021 03:50 AM
From: Marco Spyker
Subject: TM1 Java API or TM1 REST API
------ Sorry, this post was sent twice -----
---- Please follow to the "original post" --> Link
Hi all,
in our current project we have the technical requirement to consume TM1 data.
One part of the requirement is about handling big data, like an export / import scenario (TM1 -> target system). The other part of the requirement is consuming data "on-the-fly", like in a dashboard scenario, where not much data will be retrieved from TM1.
We started with the "TM1 Rest API" and made good results for the "on-the-fly" scenario, but quickly realize that for the export/import scenario our approach came to a limit.
From technical point of view, we have a complete "JAVA" stack, which means, that all data requested via the Rest API is handled in some kind of a servlet container and proccesed.
After "googling" around, we found the TM1 Java API and after a spike solution (Link) we are wondering, which way we should go, should not go or maybe use both APIs?
We had not much luck asking Google, so maybe someone could give us a little bit more insights or link for more information for questions like:
- Does the "TM1 Java API" uses internally the "TM1 Rest API"?
- Is "TM1 Java API" deprecated?
- For big data import/export and from developemnt point of view: Could there be another approach to "move" data from TM1 to a target system?
Thank you very much in advance,
Marco
------------------------------
Marco Spyker
------------------------------
#PlanningAnalyticswithWatson