Siebel Analytics Platform Installation and Configuration Guide > Preparing to Install Siebel Analytics >

Installing the Microsoft Data Access Components for Windows

Analytics License: All licenses.

Operating System: Windows only.

This topic is part of a roadmap. See the topic Determining Analytics Installation Requirements.

If your operating system is Windows, before you install any Siebel Analytics server components, you must have Microsoft Data Access Components (MDAC) installed.

NOTE:  Siebel Analytics server components are described in the topic Analytics Installation Options.

MDAC is considered a Windows system component and is included with many applications, so MDAC may already be installed. If you are installing the Siebel Analytics Cluster Server feature, MDAC is not required on machines that host only Cluster Controllers.

TIP:   If you do not need to install MDAC, proceed to the topic, Configuring Analytics Web.

Checking for an Existing Installation of MDAC

Analytics License: All licenses.

Operating System: Windows only.

Use the following procedure to determine if the appropriate version of MDAC is already installed. If it is not installed, complete the MDAC installation before beginning the Siebel Analytics installation. For the appropriate version to use, see Siebel System Requirements and Supported Platforms on Siebel SupportWeb.

To check for an existing installation of Microsoft Data Access Components

1. Search for the files msdadc.dll and oledb32.dll (optional).

   These files are generally located in the C:\Program Files\Common Files\System\OLE DB folder.

2. When you locate the files, right-click and select Properties from the context-sensitive menu.

   The version information is shown on the Version tab.

If the version is not the one specified in Siebel System Requirements and Supported Platforms, you need to install MDAC according to the following procedure.

NOTE:  Refer to the Microsoft Web site for further instructions or any problems during installation.

Installing MDAC

Analytics License: All licenses.

Operating System: Windows only.

If MDAC is not installed, install MDAC using the following procedure.

To install Microsoft Data Access Components

1. Point your browser to the Microsoft Web site.

   In the Search box, type the words MDAC download and press Enter.

2. Navigate to and select the MDAC type that conforms with the type specified in Siebel System Requirements and Supported Platforms.

   Click Download.

3. After the program has downloaded, locate the file mdac_typ.exe and click it.

   This starts the MDAC installer.

4. Follow the prompts to complete the MDAC installation.