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
Details on each of these modes and best practices regarding their usage, can be found in the TM1Connect QuickStart Guides.