Connect with Built-in SQL Developer Web

You can access SQL Developer Web, a browser-based interface of Oracle SQL Developer, from Autonomous Data Warehouse. On Autonomous Data Warehouse SQL Developer Web is named Database Actions. You can run SQL statements and scripts in a worksheet and perform other tasks on your database with SQL Developer Web/Database Actions.

About SQL Developer Web (Database Actions)

Oracle SQL Developer Web in Autonomous Data Warehouse provides a development environment and a data modeler interface for Autonomous Data Warehouse.

SQL Developer Web, also known as Oracle Database Actions, is a browser-based interface for Oracle SQL Developer. It provides a subset of the features of the desktop version. See About Oracle SQL Developer Web in Using Oracle Database Actions for more information.

These are the main features of SQL Developer Web:

  • Run SQL statements and scripts in the worksheet

  • Export data

  • Design Data Modeler diagrams using existing objects

Access SQL Developer Web as ADMIN

SQL Developer Web is bundled with each Autonomous Data Warehouse instance.

Oracle SQL Developer Web runs in Oracle REST Data Services and access is provided through schema-based authentication. To use Oracle SQL Developer Web, you must sign in as a database user whose schema is enabled for SQL Developer Web. By default the ADMIN user is enabled to access SQL Developer Web.

See Provide SQL Developer Web Access to Database Users to enable another database user's schema to access SQL Developer Web.

To access SQL Developer Web you can use the Oracle Cloud Infrastructure console or the Autonomous Data Warehouse Service Console.

Note:

If your Autonomous Data Warehouse is configured to use a Private Endpoint, then you can only access Oracle SQL Developer Web from clients in the same Virtual Cloud Network (VCN). See Configuring Network Access with Private Endpoints for more information.

To access SQL Developer Web from the Oracle Cloud Infrastructure console:

  1. On the Autonomous Database details page click the Tools tab.

    Description of adwc_console_tools.png follows
    Description of the illustration adwc_console_tools.png
  2. In the SQL Developer Web area, click Open SQL Developer Web.

  3. In the SQL Developer Web Sign in page, enter your Username and Password.

  4. Click Sign in.

    This shows the Oracle Database Actions SQL Worksheet.

  5. On the SQL Worksheet you can use the Consumer Group drop-down list to select the consumer group to run your SQL or PL/SQL code.

    See Executing SQL Statements in the Worksheet Editor for more information.

To access SQL Developer Web from the Autonomous Data Warehouse Service Console:

  1. On the instance details page click Service Console.
  2. Click Development.
  3. Click SQL Developer Web.
  4. In the SQL Developer Web Sign in page, enter your Username and Password.
  5. Click Sign in.

    This shows the Oracle Database Actions SQL Worksheet.

  6. On the SQL Worksheet you can use the Consumer Group drop-down list to select the consumer group to run your SQL or PL/SQL code.

Provide SQL Developer Web Access to Database Users

The ADMIN user can provide access to SQL Developer Web to other database users.

Database users, who are not service administrators, do not have access to the Autonomous Database service console. The ADMIN user provides access to SQL Developer Web (Database Actions) by REST enabling the user and providing a URL to the user to access SQL Developer Web (Database Actions).

See Create Users on Autonomous Database for information on adding database users.

Note:

As an alternative to these steps, The ADMIN user can use Database Actions User Management to REST enable a user and copy the URL. See Manage Users and User Roles on Autonomous Database - Connecting with SQL Developer Web for more information.

To REST enable a schema to provide access to SQL Developer Web:

  1. 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 => TRUE
       );
       COMMIT;
    END;
    /

    where:

    • schema-name is the database schema name in all-uppercase.
    • schema-alias is an alias for the schema name to use in the URL to access SQL Developer Web.
    • p_auto_rest_auth specifies the REST /metadata-catalog/ endpoint requires authorization. REST uses the metadata-catalog to get a list of published services on the schema. Set this parameter to TRUE.
  2. After enabling user access for the specified schema, the ADMIN provides a user with the URL to access SQL Developer Web, as follows:
    1. Select the Autonomous Data Warehouse instance.
    2. On the instance details page click Service Console.
    3. Click Development.
    4. Right-click SQL Developer Web and choose Copy URL.

      The copied URL is the same as the URL the ADMIN enters to access SQL Developer Web. For example:

      https://dbname.adb.us-ashburn-1.example.com/ords/admin/_sdw/?nav=worksheet
    5. To provide a user with access to SQL Developer Web you need to edit the copied URL to use the alias for the schema specified with the parameter p_url_mapping_pattern in step 1.

      For a user to access SQL Developer Web the part of the copied URL with "admin" is replaced with the "schema-alias".

      For example, after editing you would provide this URL for the user to login:

      https://dbname.adb.us-ashburn-1.example.com/ords/schema-alias/_sdw/?nav=worksheet
  3. Provide the user with the modified URL.

To access SQL Developer Web a user pastes the URL into their browser and then enters the schema's Username and Password in the Sign-in dialog.