Specify the Tables to Share with an External Data Store (Preview)

Once you've performed the prerequisite steps, configured the connection, and ensured that the Test Connection is successful in Oracle Fusion Data Intelligence, you can share warehouse tables with your external data store.

1. On the Data Configuration page, click the Data Share tile.
   
   

   

   
   
2. On the Data Share page, select the Include Frequently Refreshed Data check box to include the refreshed data for tables included in frequent data refresh while publishing to the data share target.
3. Select the warehouse data tables that you want to share with different target data stores and click Edit under Target Connections in the Action menu.
   The tables available for sharing are indicated as “Eligible”. It's recommended that you select up to a maximum of 100 tables. If you need to share more than 100 tables, contact Oracle Customer Support.
   

   

   
   
4. In the Update Target Connections dialog:
   1. Verify that the Warehouse Table Name is automatically populated.
   2. Verify that the connection type in Type displays either Functional Area or another category depending on the table.
   3. Select the Oracle Object Storage Service Targets connection that you created in Target Connections.
   4. Click Update.

   
   

   

   
   
5. Click Save and then click Publish.
   After you've clicked Publish, the status of the selected tables change from Modified to Share in Progress. When sharing is in progress, you can't perform any configuration until the share process completes. To view the status of the share process, use the Request History tile within the Data Configuration tile. When sharing is completed successfully, the status of the selected tables in the Data Share tile changes to Shared.