TM1 Function for TI, ODBCOutput
Executes a SQL query from TM1 to an ODBC database.
What is the ODBCOutput function?
ODBCOutput executes an SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen.
Where can the ODBCOutput function be used?
TurboIntegrator
What is the syntax for ODBCOutput?
ODBCOuput(DBSource, SQLquery);
DBSource = Database source
SQLquery = SQL query to update tables in ODBC database
A demonstration on how to use ODBCOutput
Use ODBCOpen to create a connection to the AdventureWorks ODBC connection, then use ODBCOutput to insert a new transaction to the FactSalesQuota table.