No direct access is permitted to the application database either through Toad, SQL Developer, or command line utilities. This also means that you cannot create new tables or related data including new Maintenance Objects, custom audit tables, and database links.

Query access is supported both in Analytics Publisher and Oracle Database Actions (see Chapter 21: Oracle Database Actions for more information), which are available as part of the cloud deployment. For more information about Analytics Publisher, see https://www.oracle.com/middleware/technologies/analytics-publisher.html.

Analytics Publisher deployment includes a JDBC data source configured with credentials that allow access to read-only synonyms in the production schema.

Note that in some cases it may be feasible to create a custom zone in the application to provide online display to view data.