Using TI, there is also the ability to read and create flat files. Users can also layer in additional logic to transform / manipulate the data as required by the implementation. The TM1 GUI will help with a lot of the configuration. The TI scripting in both of the two mechanisms above is normally very simple and only requires a basic understanding of TI functions. It is generally slow and is normally only appropriate for smaller data volumes It executes and commits a single SQL command at a time (i.e. Unlike the pull mentioned above, the ODBCOutput function is not very sophisticated. This function allows for the execution of a SQL command for a defined ODBC connection. Push data back into relational tables using the “ODBCOutput” function. This approach is commonly used to load GL Actual into cubes during the monthly close process, often times as frequently as every 15 minutes during critical times. The uploads can be scheduled or executed on-demand as necessary. This process is pretty efficient and fast, TM1 allows “multi-threading” to load data using parallel ports with significant speed. This is the most common way to pull data into TM1. Once the ODBC is established, TM1 integrate with the database to both load up data but also push data back as follows: Pull Data into cubes with a defined SQL query. Using TI, TM1 can leverage an ODBC connection to almost any relational database. The language can be used as an ETL tool as well as for other scripting and rule writing. TI also provides a powerful scripting language that is used by TM1. Turbo Integrator (TI) is a utility that lets you create processes to automate data importation, manage your metadata, and perform other administrative tasks in the TM1 environment. The three most common integration options are the following: ODBC Connection using TM1 Turbo Integrator The three most common options are outlined below – which one is the most optimal will vary by every situation depending on the criteria outlines at the end of this post. TM1 has a set of embedded tools that make the integration reasonably straight forward for any combination of cloud and on-premises interactions. Effective integration of IBM Planning Analytics (TM1) with the existing infrastructure is usually one of the top priorities of organizations looking to use TM1.

Using ti connect