Getting data into TM1

[mkm177]

Hi All,
I am very new to this Cognos TM1 product. I am aware of a "TurboIntegrator" option available for loading data into TM1. I was wondering if there are other means/tools that can be used for data loading? We use Informatica as our ETL tool and being our enterprise standard the direction we would like to take is using that tool. Is that a viable option? Does anyone have any experience getting Informatica and TM1 talking?

Thanks,
Murtaza.

[Martin Ryan]

It is not possible for any other tool to write to TM1's cubes. You must use either TI or Excel (or the cube viewer) to load data into TM1.

I suggest you use your ETL tool to manipulate the data as you wish into a nice clean staging table or flat file that mirrors the TM1 cubes' structure exactly, then use TI to pull the data from there, which will ensure your TI code is very straight forward, so you need only worry about the code in Informatica.

Cheers,
Martin

[Mike Cowie]

To add onto Martin's point, you can also integrate TM1's TI components to some extent with your overall scheduling tools. TI lets you build what it calls "Processes" and "Chores" that perform the various data and metadata operations within TM1. TM1 has its own capabilities through it's client tools to execute these Processes and Chores manually or according to its own scheduler, but you can also execute these from other sources using something like a command-line executable. One of those can be found here in the useful code section:
http://forums.olapforums.com/viewtopic. ... =548#p1621

I don't know Informatica that well, but those EXEs use the TM1 API and could be included as steps in a broader scheduled process to manipulate and import data to TM1. You'd still need to develop the Process and/or Chore objects in TM1, but could rely on your own enterprise tools to call those components.

Regards,
Mike

[wissew]

I feel sorry for you being stuck with Informatica. If you can connect to the data source via obdc you should be able to use any sql generated by Inforamtica in TI. We frequently have to do this with Toad, Peoplesoft or Bus Objects reports.