1 Explore Oracle Health Real-World Data

You can use Oracle Life Sciences AI Data Platform to query Oracle Health Real-World Data (ORWD).

  • Sign in to Database Actions
    Depending on how your organization has set up authentication, you can sign in to Database Actions by connecting to a single, default database or you can use a schema alias to connect to multiple databases. Sign in to Database Actions to view the data catalog and run queries.
  • Access the SQL Worksheet
    Use the SQL page in Database Actions to write and run SQL queries, then create database objects based on Real-World Data.
  • Use the SQL Worksheet
    Use the SQL page to interact with your database. You can create queries, and add or edit data. You can use SQL and PL/SQL statements in the worksheet to create tables, insert data, and select data from a table.
  • Locate the Oracle Health Real-World Dataset
    Each version of Oracle Health Real-World Data is stored in its own schema. Use the navigator to select the schema.
  • Run Queries on Oracle Health Real-World Data
    You can use the code editor on the SQL page to create and run SQL statements, PL/SQL scripts, and JavaScript code on the Oracle Health Real-World Data that your organization has access to.
  • Create New Datasets
    Real-World Data and Reference Dataset schema are read-only.
  • Load New Data
    If your organization has permission to do so, you can use the Data Load page in Database Actions to make that data available to your instance of Autonomous Database.
  • Connect Using JDBC
    You can use Java Database Connectivity (JDBC) to connect your data.
  • Connect Using an Autonomous Database Wallet
    Instead of using JDBC, you can use an ADW wallet to connect to other tools.
  • Download an Autonomous Database Wallet
    A wallet is a secure container that stores authentication credentials, such as secure socket layer certificates and keys for a secure connection to an Oracle database.
  • Make Data Available in Oracle Analytics Cloud
    Your Oracle Analytics Cloud (OAC) administrator can create a default connection to a shared ADW reporting schema (such as DW_CUST_REPORT), in Autonomous Data Warehouse (ADW).
  • SQL Worksheet Guidelines
    Adhering to operational standards ensures that your queries align with system performance, data security, and query efficiency. Consider the following guidelines when you use SQL Worksheet to develop SQL queries for an Autonomous Database Warehouse (ADW) instance.