

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
- 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.
- In the ODBC Data Source Administrator dialog, go to the System DSN tab.
- Add a new data source.
- In the Create New Data Source dialog, add the SQL Server driver that matches your version of SQL Server.
- Specify the remaining details for the new data source. In particular:
- Specify the SQL Server database and instance that contains the BusinessObects database that you created previously (BOREPOS).
- Specify SQL Server authentication.
- Specify that the new data source uses the SQL Server login that you created previously (BOUSER).
- Change the default database to the BusinessObects database that you created previously (BOREPOS).
Copyright © 2015 CA Technologies.
All rights reserved.
 
|
|