2 About Database Actions

Database Actions is a web-based interface that uses Oracle REST Data Services to provide development, data tools, administration and monitoring features for Oracle Autonomous Database.

The main features include executing your SQL statements and scripts, creating Data Modeler diagrams, developing RESTful web services, managing JSON collections, and using the Data Load, Catalog, Data Insights, Business Models, and Data Transforms tools to load data from local and remote sources, view data in your tables and views, view objects in your data dictionary, and organize, analyze, and transform your data.

Note:

Some features are only available if you sign in as a user with database administration rights. For such features, a "restricted availability" statement appears at the start of the feature description. For example:

Available only if you signed in as a database user with administrator rights.

Database Actions is also available for download and deployment in your own on-premises Oracle Database or in customer-managed Oracle Database cloud services. For more information, see Oracle SQL Developer Web.

See Also:

2.1 About the Database Actions User Interface

This section describes the Database Actions user interface.

The Database Actions user interface has three components:

  • The Header at the top

  • The page body, whose content varies depending on which page you are viewing

  • The Status Bar at the bottom

Header

The header contains the Selector icon, the help icon, and the user drop-down list.



  • Selector Icon

    Click the Selector iconSelectorto see the main menu slide into view in a navigation pane. Use the Selector to switch between the Database Actions page and the navigation pane.

  • Help Icon

    Click the help icon to open the contextual or online help for the page you are viewing.

  • User Drop-Down List

    The user drop-down list shows the database user you are signed in as, and provides the following items when you open it:

    • Preferences: Opens a dialog that lets you set your preferred time zone and user interface language. The languages available are English, German, Spanish, French, Italian, Japanese, Koren, Portuguese, and Chinese.

    • Log: Opens a dialog that shows the list of HTTP calls made during your session.

    • About: Opens a dialog providing version information for the database and other components as well as copyright and licensing information.

    • Sign Out: Signs you out of your database session.

Status Bar

The status bar contains icons that link to log files. The three icons (Errors, Warnings, Processes) are filters that have been applied to the log file.

Description of statusbar.png follows
Description of the illustration statusbar.png

Errors, Warnings: Displays an Errors or Warnings dialog, which lists log entries from unsuccessful REST calls or from any other problem in the application.

Processes: Displays a Processes dialog, which logs REST calls that are either finished or ongoing.

Log notification link: Displays a Log dialog, containing log entries of the following types: Errors, Warnings, Processes, SQL History and SQL Result.

2.2 Accessing Database Actions

Database Actions runs in Oracle REST Data Services and access to it is provided through schema-based authentication. To access Database Actions, you must sign in as a database user whose schema has been enabled for Database Actions.

In Oracle Autonomous Database databases, the ADMIN user is pre-enabled. To enable another database user's schema, see Enabling User Access to Database Actions.

In the Database Actions login page, enter the user name and password of the database user for the enabled schema. Then, click Sign In. The Database Actions page appears.

2.2.1 Enabling User Access to Database Actions

To enable a database user to sign into Database Actions, run the following code as the ADMIN user:

BEGIN
 ords_admin.enable_schema(
  p_enabled => TRUE,
  p_schema => 'schema-name',
  p_url_mapping_type => 'BASE_PATH',
  p_url_mapping_pattern => 'schema-alias',
  p_auto_rest_auth => NULL
 );
 commit;
END;

where:

  • schema-name is the database schema name in all-uppercase.
  • schema-alias is an alias for the schema name that will appear in the URL the user will use to access Database Actions. Oracle recommends that you do not use the schema name itself as a security measure to keep the schema name from being exposed.

After enabling user access, do the following:

  1. The default URL for logging in as an administrator user to the Database Actions login page ends with ..ords/admin/sign-in or ..ords/admin/_sdw. Change the URL to ..ords/sql-developer. For example:

    http://<domain name>/ords/sql-developer

  2. Enter the Username (schema-alias) and click Next. You see the URL change to /ords/<schema alias>.

  3. In the login page, enter the password and click Sign in.

When you log out, you return to the login page (/ords/sql-developer) and are prompted for the user name (schema-alias) again.

2.3 The Database Actions Home Page

When you log in to Database Actions, the home page appears.

The home page contains three main groups: Development, Data Tools, and Administration. The Administration group is available only for administrator user roles. Each group consists of feature-based icons that you can click to navigate to the respective pages.

For Oracle Autonomous Database on dedicated Exadata infrastructure, there is an additional "Monitoring" group available for administrator users.

The main features are:

Development

  • SQL: Enter and execute SQL and PL/SQL commands, and create database objects. See The SQL Page

  • Data Modeler: Create diagrams from existing database schemas, generate DDL statements, and create reports. See The Data Modeler Page

  • APEX: Link to the Oracle Application Express sign-in page. Application Express is a rapid web application development platform for the Oracle database. See Oracle Application Express documentation

  • REST: Develop RESTful web services and ensure secure access. See The REST Pages

  • JSON: Manage and query JSON collections. JSON is available only if you are signed in as a database user with the SODA_APP role. See The JSON Page

Data Tools

  • Data Load: Load or access data from local files or remote databases. See The Data Load Page

  • Catalog: Understand data dependencies and the impact of changes. See The Catalog Page

  • Data Insights: Discover anomalies, outliers, and hidden patterns in your data. See The Data Insights Page

  • Business Models: Create business models for performance and analysis. See The Business Models Page

  • Data Transforms: Design your data flows and workflows graphically. Data Transforms is available only to an Oracle Data Integrator on Oracle Cloud Marketplace user that has connectivity enabled from Database Actions in the Oracle Data Integrator user interface. See Using ODI Web Studio

Administration

  • Database Users: Perform user management tasks such as create, edit, and REST enable users. Database Users is available only if you are signed in as a database user with administrator rights. See The Database Users Page

Monitoring

  • Monitor database activity and performance using various tools. Monitoring is available only on dedicated Exadata infrastructure and only if you are signed in as a database user with administrator rights. See The Monitoring Pages