Install and configure BI Indexing Connector (back end)
Published: May 12, 2010
The Microsoft Business Intelligence Indexing Connector free download was removed from the download site. Customers who have downloaded the Business Intelligence Indexing Connector as of March 2011 will continue to be supported as per standard support procedures. However, Business Intelligence Indexing Connector will not be tested or supported for SharePoint Server 2010 Service Pack 1.
This article describes how to install and configure the Microsoft Business Intelligence Indexing Connector for the back end. To download the Business Intelligence Indexing Connector (back end), see Microsoft Business Intelligence Indexing Connector – Back end (http://go.microsoft.com/fwlink/p/?LinkId=195026).
Microsoft FAST Search Server 2010 for SharePoint must be installed first to provide indexing and query matching capabilities, and the administration of these features. For more information, see Install Microsoft SharePoint Server 2010 and Microsoft SQL Server 2008 (FAST Search Server 2010 for SharePoint).
Microsoft SharePoint Server 2010 and FAST Search Server 2010 for SharePoint must not be installed on the same server.
Before you start
Make sure that you have performed the steps for Install FAST Search Server 2010 for SharePoint.
Review Determine software requirements for Business Intelligence Indexing Connector (SharePoint Server 2010) and Overview of Business Intelligence Indexing Connector architecture (SharePoint Server 2010).
We recommend that you grant the Service Identity account, the account under which Business Intelligence Indexing Connector service is run, the following fixed database roles:
The Service Identity account should be added to the FASTSearchAdministrators group so that business intelligence properties are recognized on a document.
Considerations for crawling external data sources
This section explains how you can successfully crawl external data sources, specifically Microsoft SQL Server Reporting Services (SSRS) report server, Microsoft SQL Server 2008 R2 PowerPivot for Microsoft SharePoint 2010, and other files.
To crawl files that are created by Microsoft SQL Server PowerPivot for Microsoft Excel, you must deploy the same version of PowerPivot for Excel onto the instance of Microsoft FAST Search Server 2010 for SharePoint that is installed on the client. The client files that are crawled must be Microsoft Excel 2010 files that have the same version of PowerPivot for Excel that is installed on FAST Search Server 2010 for SharePoint.
To crawl SSRS .rdl files on a computer that is running Microsoft SharePoint Server with the Reporting Services Add-in, you must append
NoGetRedirect="TRUE" so that the tag in %ProgramFiles%\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML\ServerFiles_ReportServer.xml resembles the following.
<Mapping FileExtension="rdl" RedirectUrlTemplate="/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=|0" NoGetRedirect="TRUE"/>
If you have multiple SharePoint Web applications in a farm configuration, you must change the ServerFiles_ReportServer.xml file on each computer that has a front-end Web and is configured to manage report server content.
If the Business Intelligence Indexing Connector front end (SharePoint Server 2010) and back end (FAST Search Server 2010 for SharePoint) are installed on the same computer, you do not have to render the SSRS report in the browser. Clicking an .rdl document (SSRS report) in a PowerPivot Gallery gives you the option to download the .rdl document rather than rendering the report in the browser. This does not affect other SharePoint document libraries, which will render SSRS reports in the browser.
To query dynamic data in SSRS reports, you must specify the HTTP redirect as the URL after you select Enable External Data Source Crawling. The redirect would resemble the following.
To crawl SSRS report files, you must have the Business Intelligence Indexing Connector installed on the admin server. By default, all servers in a multiple server deployment, except the admin server, are non-admin servers. To learn how to determine whether a configured admin server is running, see Install FAST Search Server 2010 for SharePoint.
Install the Business Intelligence Indexing Connector
When you click Download on the download page, a Microsoft Installer Package (MSI) runs on your computer and a wizard opens. Follow the procedures in sequence.
To install the Business Intelligence Indexing Connector
A welcome page appears. Click Next to continue with installation.
Browse to change the default destination folder location. The default install location is %Program Files%\Microsoft\Business Intelligence Indexing Connector. Click Next and then click Install.
To configure the Business Intelligence Indexing Connector
On the Start Menu, point to All Programs, and then locate FAST Search Server 2010 for SharePoint. Select Business Intelligence Indexing Connector to start the wizard. A welcome page opens. Click Next
On the BI Indexing Connector Service Settings page, select service identity account settings and optionally change the port. Click Next.
To crawl external data sources, such as SSRS report server, you must enter an account that has database access.
On the BI Indexing Connector Filters Settings page, you have to option to enable external data source crawling. You can also select an SSRS report server as an external data source.
If you select to Enable External Data Source Crawling for Excel or SSRS, you must apply security restrictions to indexed information about Active Directory service accounts. Security restrictions give you the option to select one or more user accounts and one or more groups.
If you select Enable External Data Source Crawling, you may enable search users to breach the network security because of design limitations. If your file has specific data-level permissions lower than the file security, consider excluding that specific report from the crawl completely. You can do this by isolating it in a secure content source or by not giving access to the report—or underlying data—from the Service Identity account.
Users with write access to external data sources, including the Master database, can potentially index the complete database schema and execute SQL scripts. As a best practice, the database administrator should only grant read access to the Service Identity account.
Click Configure to complete the configuration of your choices.
Changes on the configuration made through the configuration wizard may stop and restart the FAST Search Server 2010 for SharePoint service after configuration has completed successfully. If the service stops after configuration or cannot restart, refer to Troubleshooting BI Indexing Connector (SharePoint Server 2010).
If you reinstall Office Filter Pack after the Business Intelligence Indexing Connector is configured, you must re-run the configuration wizard.
Verification of configuration
When configuration is completed successfully, the BI Indexing Connector service is set to start automatically.