Pull data from 3rd party app in Tm1 Model

[Ben@ActionKPI]

Hi All,

Looking for guidance regarding capabilities Tm1 has related to Pulling data from a project management tool to be loaded into a cube and reported on.

I am relatively green when it comes to API's and REst APi's and the world of integrating with third party apps..

There are 4 apps in question, I need to know if any or all can be used to feed Tm1 models.

Teamwork: https://developer.teamwork.com/projects ... ojects-api

Wrike: https://developers.wrike.com/documentation/api/overview

ProjectManager.com: https://developer.projectmanager.com

LiquidPlanner.com: https://developer.liquidplanner.com/docs


Regards,

[tomok]

I don't know squat about any of those apps but I do know that TM1 does not have any capabilities to pull from any datasources except through ODBO, ODBC, or a text file. If those tools can provide any of those then you should be able to make it happen.

[lotsaram]

For connecting to any external application via a restful api look at TM1Py

[Edward Stuart]

You can absolutely pull data from source systems and load into TM1/ Planning analytics models via the Rest API.

For me, loading in the traditional manner from within TM1 will be by far and away quicker than utilising the API. It is, however, potentially very useful and could present some real opportunities to integrate applications.

There are code samples on the Teamwork site which should give you a decent starting point to what kind of data you can retrieve

https://github.com/Teamwork/codesamples