Data Access Component (Data Services)

The Data Access Component is part of the 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.