About TM1Connect

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

About TM1Connect

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.