TM1 Function for TI, ODBCOpen

Opens a connection between TM1 to an ODBC database.

What is the ODBCOpen function?

ODBCOpen opens a connection between TM1 to an ODBC database.

Where can the ODBCOpen function be used?

TurboIntegrator

What is the syntax for ODBCOpen?

ODBCOpen(DBSource, DBUsername, DBPassword);​

​DBSource = Database source​
DBUsername = user or client name for ODBC connection​
DBPassword = user or client password for ODBC connection

A demonstration on how to use ODBCOpen

Use ODBCOpen to create a connection to the AdventureWorks ODBC connection, then use ODBCOutput to insert a new transaction to the FactSalesQuota table.