Defining an ODBC Data Source

To define an ODBC data source, follow these steps.

1. Open the Server Explorer.
2. Right-click the Processes icon beneath the server on which you want to create the process and choose Create New Process.
   The TurboIntegrator window opens.
3. Choose the top ODBC in the Data Source Type box. TurboIntegrator displays the fields required to define an ODBC source.
4. Click Browse and choose an ODBC data source name. Only data sources that have been defined on the computer on which the TM1® server runs are accessible.
5. If they are required to use this source, enter a valid username and password for the target database in the UserName and Password fields.
6. In the Query box, enter an SQL query to extract data from the source. The syntax and format of the SQL query depends on the type of database you are using. For example, if you are using an Microsoft Access Database, you can run Microsoft Access, open the database, use the SQL view, then copy the SQL statement into this Query window.
   Note: If the query references a table name that contains spaces, you must enclose the name in double quotes.
7. Click Preview.
   If the query was valid, and the connection was properly defined, the first ten records of the target database table appear in the TurboIntegrator window.