Home

TurboIntegrator

TurboIntegrator is a scripting language and ETL tool built into IBM Cognos TM1, now IBM Planning Analytics. It is used to automate data loading, transformation, and metadata management for TM1 cubes. TI processes enable end-to-end data integration workflows that pull data from sources such as relational databases, flat files, Excel workbooks, or other TM1 cubes, map it to TM1 dimensions and attributes, apply transformations, and load values into cube cells.

TI scripts are created in a process editor and typically organized into sections such as Prolog (initialization

Common use cases for TurboIntegrator include incremental data loads, staging area processing, ERP and database data

Overall, TurboIntegrator remains a core tool for developers working with TM1/Planning Analytics to implement robust, automated

and
setup),
Metadata
(dimension
and
element
updates),
Data
(the
loading
logic),
and
Epilog
(cleanup
and
logging).
The
language
provides
a
range
of
functions
for
interacting
with
TM1
data
and
external
sources,
including
CellPutN,
CellPutS,
and
CellGetN
for
writing
and
reading
cell
values,
as
well
as
utilities
for
data
type
handling,
date
operations,
looping,
and
conditional
logic.
Built-in
features
support
logging,
error
handling,
and
process
auditing,
helping
to
monitor
and
validate
ETL
operations.
integration,
and
metadata
management
such
as
creating
or
updating
dimensions,
hierarchies,
and
feeders
as
part
of
the
load
process.
TI
processes
can
connect
to
multiple
data
sources
via
TM1
data
connectors,
and
they
can
load
data
into
multiple
cubes
or
update
related
metadata
in
a
coordinated
workflow.
They
are
executable
on
TM1
servers
or
Planning
Analytics
services
and
can
be
scheduled
or
triggered
by
events.
data
loading
and
transformation
within
planning
environments.