nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Pre-requisites for subject area creation?

Malik Sikandar Hayat

Hi,

We need to create subject areas in our local instance in Oracle Analytics 2026 so which tools we need to install locally on windows pc or we can create subject areas online without using any local tool?

Thanks

Find more posts tagged with

Subject Areas

Accepted answers

Malik Sikandar Hayat

HI, Had to create SR but still issue remained to installed complete instance again and now not facing the issue to connect. thanks

All comments

Aman Jain-Oracle

Hello @MalikSikandar , Thank you for posting your question in the Oracle Analytics & AI Community.

You have both options available for developing Subject Areas (Semantic Models) in Oracle Analytics:

1. Oracle Analytics Model Administration Tool (Offline/Desktop)

This is a Windows-based client application used to create and maintain semantic models (formerly known as RPDs).
The tool must be installed locally on a Windows machine.
It provides full semantic modeling capabilities and is commonly used for enterprise-scale modeling and advanced administration tasks.

Documentation:

Model Administration Tool Overview and difference between model administration tool vs semantic modeler : https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/understand-differences-between-model-administration-tool-semantic-modeler.html#GUID-B4F80954-631A-4C69-AB1E-F52C96CD9A99
Download and Install Oracle Analytics Client Tools: https://www.oracle.com/middleware/technologies/oac-tools-downloads.html

2. Web-Based Semantic Modeler (Online)

Oracle Analytics also provides a browser-based Semantic Modeler, so no local software installation is required.
It offers a modern, intuitive interface for creating and managing governed semantic models directly within Oracle Analytics.
The Semantic Modeler supports collaborative development, Git integration, model validation, and deployment from the web interface.

Documentation:

What is Oracle Analytics Semantic Modeler: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/what-is-oracle-analytics-semantic-modeler.html
Building Semantic Models in Oracle Analytics Cloud: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/index.html

If you are using Oracle Analytics Cloud (OAC) 2026, the web-based Semantic Modeler is generally the recommended approach for new development, while the Model Administration Tool remains available for users who prefer desktop-based modeling or need specific advanced capabilities.

Hope this helps!

Malik Sikandar Hayat

Hi Aman,

Thanks for the details shared and now when I am trying to create connection it is giving error while all details are correct so hope not a bug?

"Failed to save the connection. Invalid connection details were supplied"

Thanks

Aman Jain-Oracle

Could you please share what source you are trying to connect to and whether you are using Semantic Modeler or the Model Administration Tool? A few more details will help us narrow it down to the root cause.

Malik Sikandar Hayat

Hi, It is EBS database details same as using in Oracle SQL Developer & XML Publisher but in this it is giving error like IP, PORT, Service Name, user, password while both are local instances. Do we need any other configuration/agent to use semantic modeler?

Malik Sikandar Hayat

Aman Jain-Oracle

If your EBS database is on-premises, then additional connectivity configuration is required. Depending on your environment, you might need either:

A Private Access Channel (VPN/private network connectivity between OAC and your data center), or
Oracle Analytics Data Gateway for Remote Data Connectivity.

Since the same connection details work in SQL Developer and XML Publisher, the issue may be related to how Oracle Analytics is reaching the database rather than the database credentials themselves.

To find out how to set up a private access channel or Data Gateway, see:

Malik Sikandar Hayat

Hi Aman,

thanks for your details now I am wondering as Oracle Analytics and Oracle EBS if both are on premises then still we need VPN/Data Gateway as in case of clouse I can understand but since both are local then even Basic connecvitiy should not work? thanks

GayathriAnand-Oracle

Its not clear if you are using Oracle Analytics Cloud or Oracle Analytics Server.
If its Oracle Analytics Cloud, you need additional setup (RDG or PAC plus oci networking setup) to get connectivity from OAC to onprem db working.

Malik Sikandar Hayat

Hi Gayathri,

I have clearly mentioned there is not cloud involved both are

"Oracle Analytics and Oracle EBS if both are on premises"

so in this case Basic or Advance should work? As XMLPublisher is connecting from same instance so IP or port blocking can't be an issue. Now if there is any extra step required to connect DV to database which I am missing need to know. Even I tried JDBC connection same error.

thanks

Malik Sikandar Hayat

Hi, Anyone faced this issue as both instances Oracle Analytics and Oracle EBS are on premises but still not connecting? Do we need any patch or any setting? thanks

Gianni Ceresa

What does the logs tell you?

Because the GUI only gives a generic error message, but if you check your OAS logs you should see the real error. You maybe just misspelled something…

And what is your database? (EBS being what it contains, not the database itself that has a vendor and version)

Malik Sikandar Hayat

HI, Had to create SR but still issue remained to installed complete instance again and now not facing the issue to connect. thanks

Upcoming Event

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…

Top Leaders