ODBCOpen function for IBM Planning Analytics (TM1)
ODBCOpen opens a connection between TM1 to an ODBC database.
In this video, ODBCOpen will be used to create a connection to the AdventureWorks ODBC connection, then ODBCOutput will be used to insert a new transaction into the FactSalesQuota table.
Where can the ODBCOpen function be used?
TurboIntegrator
Which TM1 Server version is the ODBCOpen function available for?
Version 11 and 12
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
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