Creating an ODBC Data Source for TM1

To configure an ODBC data source for TM1, you can use either native authentication or integrated authentication, depending on your environment and security requirements. The client software for your relational database must be installed on the same computer you are creating the FAP ODBC Data Source and TM1® server on.
Follow these steps to configure the FAP ODBC data source using native authentication:
  1. Open the ODBC Data Source Administrator.
  2. Navigate to the System DSN tab.
  3. Create a new ODBC connection using the 64-bit SQL Server driver and name it FAP.
  4. In the configuration window, enter the SQL Server name and database name.
  5. For authentication, select With SQL Server Authentication using a login ID and password entered by the user.
  6. Provide the Login ID and Password.
  7. Test the connection and click Finish.
Follow these steps to configure the FAP ODBC data source using integrated authentication:
  1. Open the ODBC Data Source Administrator.
  2. Navigate to the System DSN tab.
  3. Create a new ODBC connection using the 64-bit SQL Server driver and name it FAP.
  4. For authentication, select With Integrated Windows Authentication.
  5. Test the connection and click Finish.