About Data Mashup and Transformation Options

Use the information in this section to assess the options to mash up and transform your data.

Mash Up the Data Layer	Advantages	Limitations
Extensibility Frameworks	Robust solutions at semantic layer. Best performance. Uses pre-calculated data.	Need to be an expert user of the Oracle BI Server Administration tool. Need to understand the existing metadata repository (RPD) file. Must make minor changes to the metadata repository.
Data flow to collate NetSuite repository data and third-party data	Can access the raw data in tables to create simple to complex calculated KPIs. Provides ample scope for custom analytics. Easy to extract and load data using drag and drop in data flow.	Need to know about the tables in Oracle Autonomous Data Warehouse.
Data flow to collate NetSuite factory schema data and third-party data	Easy to extract and load data using drag and drop in data flow.	Need to understand Oracle Autonomous Data Warehouse and the metadata repository. Granularity limited to the data that’s available.