Note: OAC instance is SSL enabled
Why do you need that?
OAC being fully managed you have the dedicated "Open in the cloud" button in the Model Administration Tool.
I just want to run "nqcmd" option to run a logical query script in my local system where I have installed my Oracle Analytics Admin Client Tool. To run this "nqcmd" then we need to configure ODBC dsn for oracle analytics cloud BI server in local system.
I would say you can't, because it's OAC.
The port isn't exposed, you can't connect directly and that's why the Model Administration Tool required that new button that doesn't use a defined ODBC connection in your system but goes through a proxy or something like that.
I don't remember having seen something mentioning a direct connection was possible.
Thank you Gianni Ceresa for your response. I am wondering that I am able to connect online admin tool in cloud using SSL option(cacert file - shared) and just checking if there is any similar way like this to connect to oracle analytics BI server using odbc system DSN. I can see there is an option in odbc dsn for SSL property as well and I am not sure how this works. Now, I am learning that it is not possible to connect in this way as you said in above comment. Thanks!
The thing is that the Model Administration Tool only asks you for hostname and port number, because OAC has something special in place. I didn't look into the packets exchanged between the Model Administration Tool and OAC, but my guess is that there is a proxy in between and I can't even say if it is an ODBC connection at all or just a kind of webservice or something like that.
As you have a need that required the ODBC connection, you can try by opening an SR asking for an official answer. But the fact that OAC is a kind of black box I doubt they will make efforts to give you an ODBC access to it...
Sure, We will try to get an official answer. Thank you for your response . I appreciate it.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
