Data Access Component (Data Services)

The Data Access Component is part of the a work item, which can be installed on any client machine that needs to access data. It works by passing SQL through to the application server, which then parses the SQL, processes the data, and returns it to the client, where it can then be displayed by any client that supports the OLE DB standard for retrieving data. Examples of these are: Microsoft Excel, Crystal Reports, and SQL Server Reporting Services.

Using the OLE DB to access data ensures data consistency, enforces user security, and prevents unauthorized writing to the database. Only users with the Manage Reports (View/Edit) permission can download the OLE DB Provider.

Downloading the OLE DB Provider

Only users with the Manage Reports (View/Edit) permission can download the OLE DB Provider.

To download the OLE DB Provider
  1. In the toolbar, select Settings from the drop-down next to your user name.
  2. In the Settings dialog box, click Install OLE DB Provider, and then save the OLE DB Provider to a local computer.