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…

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

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?

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

On enabling Oracle EBS getting error, Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service

Hi Madeep, Thanks for your response and please have a look there is an option to get authorization from Oracle EBS so if this is used means then user will be able to login using Oracle EBS account/user and if so then will it apply any security. If not then as you suggested how a DS query we can write for the following…