Oracle Analytics Data Modeling Tools
Use this topic to learn the differences between the data modeling tools and which tool to use based on what you want to create.
| Tool | Use to create | Description |
|---|---|---|
| Semantic Modeler | Governed data models |
A browser-based modeling tool that developers use for creating, building, and deploying the semantic model to an .rpd file. The Semantic Modeler editor is a fully-integrated Oracle Analytics component. Because the Semantic Modeler generates Semantic Model Markup Language (SMML) to define semantic models. developers have the choice of using the Semantic Model editor, the native SMML editor, or another editor to develop semantic models. Semantic Modeler provides full Git integration to support multi-user development. See What Is Oracle Analytics Semantic Modeler? If you previously created a semantic model with the Model Administration Tool, you don't have to start from scratch in Semantic Modeler. You can migrate the semantic model from an .rpd or from the deployed model into Semantic Modeler. See Plan Your Migration From Model Administration Tool to Semantic Modeler. |
|
Model Administration Tool Oracle BI Administration Tool |
Governed data models |
You might also see this tool referred to as Administration Tool. A mature, longstanding, heavyweight, developer-focused modeling tool that provides complete governed data modeling capabilities. Developers use the Model Administration Tool to define rich business semantics, data governance, and data interaction rules to fetch, process, and present data at different granularity from disparate data systems. Oracle recommends that you use Semantic Modeler to create semantic models. The Model Administration Tool is a Windows-based application that isn't integrated into the Oracle Analytics interface. You download the Model Administration Tool and install it onto and use it from your computer. |
| Data Model Editor
(For Pixel-Perfect Reports) |
XML data structure for Pixel-Perfect Reports |
The Data Model editor enables you to combine data from multiple datasets into a single XML data structure for pixel-perfect reports. |
| Dataset Editor | Self-service data models |
A user-friendly data modeling and data preparation tool that data analysts and business analysts use to create datasets containing multiple tables with joins. A dataset can contain data from local and remote files, including more than 50 connections and subject areas. The Dataset editor is available from the Oracle Analytics interface and enables business users to create self-service data models on top of existing governed semantic models. |