How-To Instructions for Producing Shares for Live Data

Use the Data Share wizard to create and publish shares for live data.

Follow these steps:

1. Produce a live data share.
   1. Go to the Data Share Tool. See How to Access and Enable the Data Share Tool, for instructions.
   2. Click Provide Share.

      
      Description of the illustration provide_share.png

   3. Click Provider Identification.
      
      Description of the illustration provider_id.png

   4. Enter a name for the share provider, the share provider email address and a description, then click Save. This example has the following entries:
      • Name: Sales
      • Email: <obscured>
      • Description: Sales Q4
      
      Description of the illustration provider_id_sales.png
   5. Click Create Share.
      
      Description of the illustration create_share_v1.png

   6. Enter the Name for the data share and an optional description on the Create Share dialog, then click Next.

      This example uses SalesQ4 for the Name.

      
      Description of the illustration create_salesq4_share.png

   7. Select SHARE LIVE DATA USING DIRECT CONNECTION, then click Next.

      
      Description of the illustration create_live_share.png

2. Select the objects to share.

   Select the tables and/or views you want to share from the Available Tables list on the left panel. Use the arrows to include the selected tables on the left Shared Tables panel and click Next.

   In this example, the SAHE_AGE_DIM table is selected.

   
   Description of the illustration select_tables.png

   Note:

   For live data, the Data Share tool supports 1 to 4 shared objects. If the live share data provider is sharing multiple tables which would normally be joined together by the consumer, it is recommended that the producer create a view that performs the joins and then only shares the view.
3. Associate the live data share with recipients.

   Click the drop down arrow for Select Recipient and select the recipient(s) for this share, then click Create.

   In this example, MY_REGION is selected, which means anyone in this region can potentially consume from this share.

   Note:

   If you want to create a new recipient, click the New Recipient button and complete the information displayed in the dialog box. For further information on creating a new recipient based on a consumer created Share ID, see The Data Share Tool.
   
   Description of the illustration select_recipient.png

   The new Live Data Share is displayed.

   
   Description of the illustration new_live_share.png