Planning Analytics

 View Only
Expand all | Collapse all

TM1 Java API or TM1 REST API

  • 1.  TM1 Java API or TM1 REST API

    Posted Wed September 15, 2021 03:49 AM
    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


  • 2.  RE: TM1 Java API or TM1 REST API

    Posted Thu September 16, 2021 08:56 AM
    Hello Marco,

    Consider exporting to text files and importing from text files in an automated manner, which I guess provides the most reliable and high performance solution for integrating big TM1 data. 

    Regards,

    Mucahit

    ------------------------------
    Mucahit Erdal
    ------------------------------