Before you can access database tables from external ODBC-based tools, you must start with some preparatory steps such as developing and exposing an SQL service in the ABAP system.
When you want to enable the access to ABAP-managed data from external ODBC clients, you must start with some preparatory steps. These steps include the creation of CDS view entities for the tables for which you want to access, a service definition, and an SQL-typed service binding. Optionally, you can also create your own test tables. Test tables are used in this documentation as examples.
Depending on your access scenario (priviliged data access with a communication user or data access with a business user), you must perform different additional steps.
For accessing database tables using a communication user, you must also create a communication scenario and a communication system in ABAP Development Tools. An administrator creates a corresponding communication arrangement and user. The assumption in this documentation is that the communication user gets privileged data access.
For accessing database tables using a business user, this documentation also shows how to configure data access where access is limited to orders for a specific region. For this scenario, you must create an authorization object, access control, an IAM app, and a business catalog in ABAP Development Tools. An administrator creates a business role and assigns a business user.
Related Information