The Provide Share page enables you to view, create, edit, and access information on the shares and recipients you create from this page.

Click the Provide Share menu under Data Share in the Data Studio menu to reach the Provide Share page. You can switch the display of the Provide Share screen based on the widget you select from the Shares and Recipients section.

The search field and the display area of the Provide Share page varies when you switch between the SHARES and RECIPIENTS widgets.

Shares Page

The following image displays the Provide Share page when you select the SHARES widget.

Recipients Page

The following image displays the Provide Share page when you select the RECIPIENTS widget and there is no RECIPIENT created

Click + Create Share Recipient to create a share recipient. See Create Share Recipient for more details.

Click Provider Identification to specify the name and description to identify how the recipients will view you. You can also configure SMTP settings.

The following image displays the Provide Share page when you select the RECIPIENTS widget and there is minimum one RECIPIENT already created

You can share data as a set of distinct versions, such as at the end of each day. The recipient will only see changes to the data when you publish a new version. As a versioned share Provider, you must create an OCI native credential and associate the bucket's URL with the credential.

On the Provide Share page, select + Create Share from the Create menu. This brings up the Create Share wizard.

1. On the Create Share wizard, in the Name field of the General tab, enter a name for the Share. For example: My_Share.

   In the Description field, enter a description for the link. For example: Weekly Sales report.

   Select Next to progress to the Publish Details tab of the Create Share wizard. You can alternatively click on the Publish Details tab to progress to the Publish Details screen of the wizard.

   
   
2. In the Publish Details Tables tab of the wizard, select SHARE VERSIONS USING OBJECT STORAGE.
   
   Select a cloud location where you want the share to be published. If you already have an OCI cloud storage location available, use the Select Cloud location drop-down and select any available Cloud location from the drop-down. You will view a successful message if you have access to read, write, or delete in that cloud location.

   Note
   
   Select Create Cloud location and follow the steps described in the Create Oracle Cloud Infrastructure Native Credentials if you do not have a cloud location available.

   For sharing versioned data, you can enable the schedule for share. Select Enable For Scheduling option to set up a schedule for sharing. In the time interval fields, enter a number, and select a time type and the days on which to poll the bucket for new or changed files. For example, to poll every two hours on Monday, Wednesday, and Friday, enter 2, select Hours, and then select Monday, Wednesday, Friday in the appropriate fields. You can select All Days, Monday to Friday, Sunday to Thursday, or Custom from the Week Days drop-down. The Custom field enables you to select Monday, Tuesday, Wednesday, Thursday and Friday in the appropriate fields.

   Select a start and end date. If you don't select a start date, the current time and date are used as the start date. The end date is optional. However, without an end date, the share will continue to poll. This is an optional step.

   Click Next to progress to the Select Tables tab of the Create Share wizard.

3. On the Select Tables tab of the wizard, select the schema from the drop-down menu and click the table you wish to share from the Available Tables. Choose any of the available options:
   • >: This option enables you to move the table to Shared Tables.
   • <: To remove the selected table from Shared Tables select this option.
   • >>: This option allows you to move all the tables to the Shared Tables screen.
   • <<: To remove all the selected tables from Shared Tables select this option.
   
   
   Click Next to proceed to the Recipients tab of the Create Share wizard.

   Note
   
   You may find it convenient to click on the specific tab to move back and forth. You can update changes on any screen this way.
4. On the Recipients tab of the Create Share wizard, select available Recipient from the drop-down.
   

   Select Notify Recipients When Available when you want to notify the recipients when they are available. This can be enabled when SMTP is configured to send an email notification to the recipient.

5. In case you want to create a new recipient, select New Recipient. Selecting New Recipient opens a Create Share Recipient wizard. See Create Share Recipient.
   Note
   
   Ensure there are no spaces in the name of the recipient. This field does not support duplicate recipient names. If you try creating a recipient with a duplicate name, the creation of the share fails with the "Name is already used by an existing object" error.

   Click Create to finish creating the share recipient. The newly added recipient is displayed in the list of recipients. Click Cancel to cancel the ongoing process of recipient creation.

6. After you create a new share recipient, in the granted recipient's list you can:
   • Select copy profile activation link to clipboard icon to copy the activation link.
   • Select Email recipient profile download link icon to mail the profile link to the recipient you select in this step. Once you select it, the Share tool triggers an activation mail with the profile link to the recipient’s email address. Click Send to share the profile link with the recipient. See About the Consume Share Page to know more about the activation mail and how to proceed as a recipient once you receive the activation mail.
   • Click deselect Recipient icon to remove the selected recipient.
     

   Select Create to create the share. Note that the status of the share changes from unpublished to published depending on the size of the table in the share. You will receive a successful share notification message at the top right of the display that says the share is successful. The Provide Share page displays the share along with its details such as the entity type, owner, shared objects and the recipients.

   Note
   
   The Data Share tool can create only two delta share profiles for the same recipient. If you try to create a third profile, the tool invalidates the first profile, and the newly created profile becomes active.
   
   
   
   
   
   

You can share data as of the latest database commit with Autonomous Databases in the same region. The recipient will always see the latest data.

To provide access to live shared data, you must define data shares and grant recipients access to consume them. Use the Create Share wizard to create and publish shares for live data.

Click the name of the entity or click Action to view details about the share entity. See View Share Entity Details.

After share is created, you can view the new Share entity in the Provide Share page.

To view details about an entity, click the Actions icon at the right of the Share entity entry, then click View Details.

For all entities, the details include General, Selected Tables, Publishing details, Recipients, Versions, Log Details, Lineage and Impact sections.

General

The General tab displays the Name and description of the share.

Selected Tables

The Selected Tables tab displays the list of tables you wish to share.

Publishing

This tab displays the publishing details you configure during creation of the share. It displays whether you select live data share or share versioned data.

Recipients

You can review the list of recipients with whom you intend to share objects. It displays the name of the recipient with their mail address.

Jobs

See the Jobs option below to view information about it.

Log Details

You can view the detailed status of the share in this tab. It provides information such as, the time, Status, Log Level, and Details of each activity that takes place during the running of the job, i.e., creation of the share. It also displays if any errors are encountered during the creation of the share.

Lineage

Lineage displays all known information about the dependencies of the entity, and therefore how the entity was created and how it is linked to other entities.

For example, for a share you create in the database, the lineage is just the cloud location. For a share that you create by adding files from cloud storage, the lineage includes the cloud location of the file you share.

Pointing to the name of an item in the lineage displays the share name, the application that creates it, the type of entity, the path to it, and the schema it is in.

Arrows point from an entity to the entity that it derives from. For example, for a share you create, an arrow points from the cloud location to the share. If you point to an arrow, then a Links Information box appears that shows information about the relationship between the two entities.

To view more details about an item, click the Actions icon for the item, then click Expand. For a cloud location, the files in the location are displayed. Pointing to the name of the file displays the name, application, type, path, and schema of the file. To collapse the display, click the Actions icon, then click Collapse.

Impact

Impact shows all known information about the downstream use of an entity, and therefore how a change in the definition of an entity may affect other entities that depend on it.

For a specific share entity, you can perform the following actions using the Actions context menu:

• View Details: See View Share Entity Details.
• Objects: Opens Select Tables dialog of the specific share where you can remove tables from the list of Shared Tables list or add tables from the list of Available Tables list to the list of Shared Tables.
• Recipients and Profiles: Opens the Recipients and Profiles dialog which enables you to create a new share recipient. You can also revoke the recipient right from the share by clicking X next to the recipient name. The Recipients and Profiles dialog enables you to update the list of recipients, copy profile activation link, send an activation mail to the selected recipient.
• Jobs: Opens the Jobs table and displays information related to it. A job is created whenever something needs to happen to a share. This includes the following:
  • PUBLISH VERSIONED SHARE
  • PUBLISH LIVE SHARE
  • DROP SHARE VERSIONS

  Only one job can run at a time on a single share. E.g. if the user calls publish_share while a PUBLISH job is already running, then the second job will have to wait. The STATUS column reflects the same.

  The JOB TYPE column displays the method of parquet files generation (only for a versioned share). It's values can be ODI or DBMS_CLOUD.

• Publish: Select Publish to publish the updated share.
• Unpublish: Select Unpublish to unpublish the share. This option prevents all recipients from accessing a single share, but lets them continue to access any other shares. You can restore access by publishing share again.
• Delete: Deletes the Share Provider Entity.

On the Provide Shares page, click the Recipients widget and select + Create Recipient to create a new Share Recipient.

Share Recipients are those with whom we intend to share objects with. You can share objects securely with users outside of Oracle workspace. Apart from creating recipients from the Create Share wizard, you can also create a share recipient from the Create Recipient icon on the Provide Share page and verify the details you configure while its creation.

1. On clicking the + Create Recipient icon, a Create Share Recipient dialog box appears.
   
2. On the General tab, specify the following fields:
   • Name: Enter the name of the Share Recipient. For example, Marketing_team.
     Note
     
     Ensure there are no spaces in the name of the recipient. This field does not support duplicate recipient names. If you try creating a recipient with a duplicate name, the creation of the share fails with the "Name is already used by an existing object" error.
   • Email: Enter the email ID of the recipient. For example, marketing@oracle.com.
   • Description: Add a description. This is optional.
   • Sharing ID: An intended Recipient should copy this ID from the consumer page and send it to the Producer to be used here. The Share Provider wont have access to the consumer page. This field is required for Live Share Recipients only.

     On the User token lifetime section, enter any value in the TOKEN_LIFETIME field for the share recipient. This property specifies for how long the generated token will be valid after which the recipient loses access to the data share and must request a new token. Enter 60 in the first text field. Select Minutes from the drop-down menu.

   Click Next to progress to the Shares tab of the Create Share Recipient dialog box.

3. On the Shares tab, select an available share from the drop-down. As you select the share, it lists under the Granted Shares section. You have the choice to share multiple shares to the recipient.
   

   Select Create to create the Share recipient.

Once you have created the Share recipient, you will be able to view the newly created Share Recipient entity in the display area of the Provide Share page. The new recipient card displays details such as the entity type and the owner.

Click the name of the entity or click Action to view details about the share recipient entity. See View Share Recipient Entity Details.

Click the Actions icon at the right of the Share Recipient entity entry, then click View Details.

For all entities, the details include general details, Log details, Granted Shares, Lineage and Impact.

General

The General tab displays the Name and Email address of the Share Recipient.

Granted Shares

The Granted Shares tab displays the list of shares granted to the recipient.

Log Details

The Log details tab displays the Time, Status, Log Level, Share Name, Request, End Point, Remote address, User Agent and Details of the Recipient.

Lineage

Lineage displays all known information about the dependencies of the entity, and therefore how the entity was created and how it is linked to other entities.

For example, for a share you publish, the lineage includes the files in cloud storage along with the cloud location of the files you share.

To view more details about an item, click the Actions icon for the item, then click Expand. For a cloud location, the files in the location are displayed. Pointing to the name of the file displays the name, application, type, path, and schema of the file. To collapse the display, click the Actions icon, then click Collapse.

Impact

Impact shows all known information about the downstream use of an entity, and therefore how a change in the definition of an entity may affect other entities that depend on it.