Importing from an ODBC Source

Using TurboIntegrator, you can create cubes and dimensions from data in relational database tables. To do this, you must have the following software on your machine.

  • The client software for your relational database installed on the same machine on which you are running TurboIntegrator.
  • An ODBC data source established for your relational database. You build data sources through the Windows Data Sources control panel.

When you have defined the ODBC data source, the steps for creating a cube or dimension from relational data are identical to creating a cube or dimension from a text file. For a complete step-by-step tutorial of creating objects in TurboIntegrator using an ODBC source, see "TurboIntegrator Tutorial."

Note: TM1 requires DataDirect drivers to access an Oracle ODBC source on Solaris. These drivers are not supplied with TM1 and must be acquired separately.