1. Oracle Autonomous Database Data Share Quick Start Guide
  2. Share Live Data Using Direct Connection
  3. Use Oracle as a Data Share Consumer of Live Data
  4. How-To Instructions for Receiving Shares for Live Data

How-To Instructions for Receiving Shares for Live Data

To consume live data shares, you need to subscribe to them and create views of tables included in the live share. The views can be queried using SQL scripts.

Follow these steps:

  1. Browse available live shares.
    1. Go to the Data Share tool. See How to Access and Enable the Data Share Tool.
    2. Click CONSUME SHARE.

      Description of consume_live_v1.png follows
      Description of the illustration consume_live_v1.png

      A list of available live shares appears.

  2. Subscribe to the live share provider.
    1. From the list of available live share providers, click the + icon to the right of the share provider you want to consume.

      In this example, the QA4-LIVE_ADMIN live share provider is selected.

      Description of select_live_share.png follows
      Description of the illustration select_live_share.png
    2. From the Subscribe to Share Provider page, you can make changes to the name and description or leave as is. Click Next.

      In this example, the defaults are kept.

      Description of provider_settings.png follows
      Description of the illustration provider_settings.png

      The list of Available Shares for this share provider displays.

    3. Select the share you want to consume and move it to the Selected Shares section using the middle arrows. Click Subscribe.

      In this example the SALESQ4 share is selected and moved.

      Description of subscribe.png follows
      Description of the illustration subscribe.png

  3. Create a view on top of tables in your share.
    1. Expand the live data share to view tables included in the share. Drag and drop the table you want to consume to the right panel. Click Start.

      In this example, the SALESQ4 live share is expanded to display the SAHIE_AGE_DIM table. The table is dragged and dropped to the right panel.

      Description of create_view.png follows
      Description of the illustration create_view.png
    2. Click Run, in the dialog box that appears.

    3. When the view has been created, the new view displays with status showing Complete.

      Description of view_complete.png follows
      Description of the illustration view_complete.png
  4. Query the live share data.
    1. Click Database Actions in the breadcrumb.

      Description of db_actions.png follows
      Description of the illustration db_actions.png

    2. Select Development, then click SQL.

    3. Select Views, on the left Navigator, from the object drop down. From the list of available views, drag and drop the SAHIE_AGE_DIM_1 view to the worksheet.

      Description of view_over_share_v1.png follows
      Description of the illustration view_over_share_v1.png

      A dialog displays offering the types of available insertions.

    4. Click Select, then Apply.

      Description of insertion_type.png follows
      Description of the illustration insertion_type.png

    5. Click Run (the arrow icon at the top of the worksheet). The returned data displays under Query Results.

      Description of results.png follows
      Description of the illustration results.png