Reports Integration Guide › Deployment › CA Business Intelligence › Install CA Business Intelligence › Create an ODBC Data Source for SQL Server

Create an ODBC Data Source for SQL Server

If you created a new BusinessObjects database, you must also create a new ODBC data source. BusinessObjects uses this data source to connect to the new database. This section describes how to create an ODBC data source to connect to a SQL Server database.

To create an ODBC data source for SQL Server

1. On the BusinessObjects Enterprise host server, run odbcad32.exe.

   To find this file, launch Administrative Tools from the Control Panel. Then open DataSources.

   Note: On 64-bit systems, you must specify a 32-bit ODBC System DSN to connect to SQL Server. Find odbcad32.exe in the following \Windows\SysWOW64 directory.

2. In the ODBC Data Source Administrator dialog, go to the System DSN tab.
3. Add a new data source.
4. In the Create New Data Source dialog, add the SQL Server driver that matches your version of SQL Server.
5. Specify the remaining details for the new data source. In particular:
   1. Specify the SQL Server database and instance that contains the BusinessObects database that you created previously (BOREPOS).
   2. Specify SQL Server authentication.
   3. Specify that the new data source uses the SQL Server login that you created previously (BOUSER).
   4. Change the default database to the BusinessObects database that you created previously (BOREPOS).