ODBCOutput function for IBM Planning Analytics (TM1)

ODBCOutput executes an SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen.

In this video, ODBCOutput will be used to create a connection to the AdventureWorks ODBC connection, and then ODBCOutput will be used to insert a new transaction into the FactSalesQuota table.

Where can the ODBCOutput function be used?

TurboIntegrator

Which TM1 Server version is the ODBCOutput function available for?

Version 11 and 12

What is the syntax for ODBCOutput?

ODBCOuput(DBSource, SQLquery)

DBSource = Database source
SQLquery = SQL query to update tables in ODBC database

Relevant Functions

ODBCClose = Closes an ODBC connection
ODBCOpen = Opens a connection between TM1 to an ODBC database
ODBCOpenEx = Opens an ODBC data source for output specifying that the connection should be opened as a Unicode connection
ODBCOutput = Executes a SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen
SetODBCUnicodeInterface = Sets whether the ODBC interface should use the Unicode wide functions or the regular single-byte character functions