Open SQL driver overview
The Open SQL driver is a powerful driver because of the flexibility that it provides for accessing data in SAP. By writing reports with the Open SQL driver, you gain easy access to SAP's transparent tables, pool tables, cluster tables, and views. If you are currently involved with the production of ABAP reports, you will find it easy to quickly build reports with this driver.
The advanced functionality of the driver allows you to report against ABAP functions and ABAP data clusters. ABAP developers can therefore perform advanced tasks such as reporting against data clusters in HR. The Cluster Definition tool is provided as part of the server installation for users who need to add, edit, and delete data cluster definitions. Developers can also utilize ABAP to augment report processing.
Additionally, the Open SQL driver provides the ability to secure the data to which users have access. You can place limitations either on individual tables, or, at a more granular level, on the individual rows within a table. For more information about using the Security Definition Editor to customize your own set of data access authorizations, see the “Defining Security for the Data Access Kit” section in the SAP BusinessObjects Business Intelligence Platform Installation Guide.