TM1Connect is a middle-tier application that provides translation services of multi-dimensional data stored in IBM Cognos TM1, into a format readily consumed by tabular or relational style applications, such as QlikView, Tableau or any other ODBC compliant software such as Microsoft Access or Microsoft Excel. TM1Connect understands cubes, dimensions, hierarchies, and attributes to quickly and easily transfer both data and metadata into a record-style format that many applications natively support.

 

TM1Connect operates in two distinct modes depending upon your needs:
 

Batch Mode                

- Export files generated on a scheduled basis

On-Demand Mode

 

ODBC        

- Any ODBC compliant consumer (Tableau, Microsoft Access, etc.)

QlikView Connector                

- Direct connect from QlikView Desktop

 
The diagram below illustrates the basic architecture for TM1Connect and how it integrates information with TM1 in on-demand mode

 

TM1Connect - On-Demand

 

 

Details on each of these modes and best practices regarding their usage, can be found in the TM1Connect QuickStart Guides.