1. Visualizing Data in Oracle Analytics Server
  2. Visualize Data
  3. Connect to Data Sources
  4. Connect to a Database Using Delta Sharing

Connect to a Database Using Delta Sharing

You can connect to some databases using the Delta Sharing protocol, for example, Oracle Autonomous Database, and visualize the data.

The Delta Sharing protocol provides secure data access without direct access to the source.

For a list of databases that support Delta Sharing, see Certification - Supported Databases.

Use the connection to create a dataset and build workbooks. For example, from the Home page, click Create, then click Dataset, then select the connection that you just created. Save the dataset and use it to build workbooks.
Before you start, ask the target database administrator to set up a delta sharing area and share it with you. For example, in Oracle Autonomous Database, an administrator creates a Data Share area, and shares it with you so that you receive a email containing an activation link. The link enables you to download a JSON file containing profile details required to create a connection in Oracle Analytics.
Description of delta-share-setup.png follows
Description of the illustration delta-share-setup.png

  1. Contact the database administrator to request a data share.
  2. In the activation email that you receive from the database administrator, click the activation link.
  3. In the activation dialog, click Get Profile Information.
    A credentials file for the target database is downloaded to your local area in JSON format.
  4. On the Oracle Analytics Home page, click Create, and then click Connection.
  5. In Create Connection, click Delta Share.
  6. Enter a Connection Name and optional Description.
  7. In Connection Type, select a type suitable for your data source. For example:
    • For Oracle Autonomous Database, select Client Credentials.
    • For DataBricks, select Bearer Token.
  8. Click Import File then select the JSON file containing connection details.
    Oracle Analytics populates the rest of the input fields with values from the import file.
  9. Click Save.
You're now ready to create a workbook and start visualizing your data. For example, from the Home page, click Create, then click Dataset, then select the connection that you just created and create a workbook.