Mash Up NetSuite Data with Third-Party Data

You might want to mash up data from multiple sources.

For instance, you might take web analytics data from warehouses of customer data, extract customer information from the Dynamix CRM, standardize and cleanse data, and then mash it up with NetSuite data. When data is in the autonomous data warehouse, you can select the appropriate option for mashing up the data. Description of nsawa_integrate_third-party_data_figure3.png follows

Description of nsawa_integrate_third-party_data_figure3.png follows

Description of the illustration nsawa_integrate_third-party_data_figure3.png

Option 1: Extensibility Framework to Extend Models and Content
You can use the Extensibility framework to extend models and content with data from other sources to your team without having to worry about upgrades. You must understand a star schema and know how to use or modify the metadata repository (RPD) file. See Customize Oracle NetSuite Analytics Warehouse and Extensibility Reference Architecture to get you started.
Option 2: Data Flow to Mash Up Data in Oracle Autonomous Data Warehouse
You can use this option to leverage third-party tables in Oracle Autonomous Data Warehouse (imported using one of the pipeline approaches) and NetSuite data loaded using an Oracle-managed pipeline. You can use a data flow to form a union, join, or filter, and transform data from the NetSuite schema and the custom schema that contains imported third-party data. See Curate Your Data Using Data Flows.