ssisssascognos-tm1

Use SSIS to write in other CubeSystems than SSAS

I've got a project where I have different cube systems (esp.:Tm1, Infor PM 10, SSAS). Is there a way to fill these cubes with SSIS? The Connection SSIS-SSAS for sure is an easy one. But are there any approaches to write into other Cube Systems with SSIS? (Maybe an open source Interface?)

If not, what would be the best tools to use? At the Moment I only know Cubeware Importer, but that one is so slow - I definitely Need a faster one.

Solution

  • You can use the Execute SQL task to send processing commands to the non-SSAS OLAP Servers. I'm no expert in Tm1 or InforPM, but whatever their equivalent of SSAS's XMLA is can be sent by an SSIS package.