Share Data with External Systems (Preview)

Use Data Share capability to share the data processed by Oracle Fusion Data Intelligence pipeline with external data stores alongside Oracle Autonomous AI Lakehouse. This enables you to enhance your analytics by combining data from Oracle Fusion Data Intelligence with data from your external data stores.

If you've an analytics stack built on these external data systems, such as data lakes or third-party data warehouses, you can integrate this with the curated data from Oracle Fusion Data Intelligence to improve your analytics.

Note:

This feature has licensing restrictions. See About Licensing.
This capability shares only the data that is flowing through the Oracle Fusion Data Intelligence pipeline. This includes data processed for factory content as well as data augmentations and data applications (such as Descriptive Flexfield Mapper, Configurable Account Analysis, Fusion Accounting Hub, and Data Augmentation Script-based data applications). You can use it for data coming from Oracle Fusion Cloud Applications as well as other third-party data augmentation sources.

Note:

Any data that is not processed by the Oracle Fusion Data Intelligence pipeline, even if you have used Oracle Autonomous AI Lakehouse associated with Oracle Fusion Data Intelligence to store it, you can't share it with the Data Share capability.
The system refreshes the Data Share targets with full loads, incremental loads, and Frequent Data Refresh V2. Data Share target refreshes with with on-demand data refresh is currently not supported. Currently, the external target data store that you can share with is Oracle Cloud Infrastructure Object Storage. For Object Storage, this process shares data in the DELTA or ICEBERG table formats and parquet file formats.

Note:

This capability doesn't support Oracle Fusion Data Intelligence instances with a private endpoint; it supports only public instances currently.
To share data, ensure to complete these tasks:
  • Perform the applicable prerequisite steps.
  • Create a connection to the external system using Manage Connections tile in Data Configuration tile.
  • Use the Data Share tile to select the desired warehouse tables and the target connection.

When you share the selected warehouse tables, the Data Share process prepares the data and based on the setup for target data stores, it then pushes the data to the target data bucket in your tenancy. The first time you share, the process loads complete data from the Oracle Fusion Data Intelligence warehouse for the selected datasets into the target data buckets. It automatically refreshes the subsequent incremental and frequently refreshed data on all the configured targets. To share the frequently refreshed data to external data stores, you must use Frequent Data Refresh V2 capability and enable Data Share for Frequent Data Refresh in the Pipeline Features section under the Preview Features tab on the Enable Features page. You can add or remove datasets or targets and issue the publish command at any time. After sharing the warehouse tables, you can remove individual tables using the Remove action for the applicable table or remove tables in bulk using the Delete Connections button that gets enabled after you select multiple tables. These options remove the selected warehouse tables from the previously specified targets.

Note:

Deletion of modules can update the data share definition. For example, if you delete functional areas, data augmentations, custom applications, target data model upgrade, or deploy and undeploy custom applications, the system deletes the tables that you had selected for these modules from the data share process.

Topics: