What kind of information are you looking for? There isn't a detailed roadmap for semantic modeler made public yet. The tool is in preview, it only supports a subset of physical sources (only relational) and still has some issues here and there. That's what a preview is for: have a look, give it a try, don't replace…

The good old webservices are fully working in OAC (as long as you have the permissions, managed with privileges in the admin page), they didn't change for 5+ years but at least they are there still. Using that you can do the same job you would do with Catalog Manager but without the GUI. But you can absolutely get the code…

Just saying (again), think twice before using "denied" in the privileges. "denied" is stronger than any "granted", by inheritance you can disable things to everybody just by adding a "denied" on BI Consumer. "denied" should be used very carefully in the privileges page. Remove the grant to BI Consumer instead of denying…

Default application roles can be edited, you can edit everything and even drop them fully (OP talks about OAS, full access to EM and app roles management and app policies management). This is just not the point, OP doesn't really want to edit an application role but want to change default privileges grantees.

Do what Jahnavi said: go in Admin -> Manage privileges and change the privileges for the "Access to Export" privilege. You don't map privileges to app roles, you add app roles to privileges. (And if you aren't familiar with that page, stay away from "deny", you will understand why if you don't...) Just keep in mind that…

Or the webservices, the good old one that is part of the tool for 10+ years: you can recursively loop through catalog objects or search them by type and then get the "definition" (the code inside the file when on disk), all by webservice. The downside of this approach compared to what Michal suggest is that the security is…

You can script the job, but yes: find all the workbooks you need (catalog search can help) and process them one by one. That's why a script will be useful: lot faster and will not get crazy after a few workbooks...

No really, it's a product/service.

There is a way, but you will not like it... A DV workbook is just an object in the catalog. The classic OBIEE/OAS/OAC objects were all XML and Catalog Manager was able to get these info out in a report as Michal said. DV workbook went through various iterations from XML containing JSON, to JSON containing XML and other…

I did ask about the official way to get offline catalog access in OAS/OAC, not receiving a reply from PMs sounded like they did confirm to not see reasons for doing it (anyone having to administer and maintain this tool would disagree)...

A real full list of agents can't be obtained from the database tables you mention: an agent can exist in your catalog without being in those tables. The real reference for the agents is the catalog because that's where an agent is defined and stored. Sadly OAC doesn't allow any offline access to the whole catalog because…

Yeah, that checkbox is off by default. You generally use it when you want to be notified that nothing happen (and when you do that, people setup rules to automatically archive your automated emails and will not even read them when there is something real inside :D )

You can set a condition on the agent, and the condition will be if there are rows or not. The agent will still run based on the schedule, but if the condition fail (= no rows of data), it does stop there and doesn't send anything.

You maybe wanted to raise that internally somewhere? Because the error is quite clear, but only you can know if it's right or a mistake. Cloud accounts have limits set on everything. Do you have anything else running using OCPUs in your account? If you do, that's probably why you did reach your limits. If you don't have…

It actually looks a list of IP that could be a bit more correct than the one you found: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/manage-service-access-and-security.html#GUID-C13DE22F-5069-4704-B64E-2F6D28B8D027 If you scroll a bit you find a similar table as the one you did use, but this one has every…

OAC is like a black box: there is little to no logs other than what you see on screen (which is weird as OAC has about 10 different log files all containing really important messages), it's the downside of a fully manage product. To be fair I have no idea if there is an official debug process on the OAC side. I would start…

@Rajesh_Kolli : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-delivery-destinations.html In this page you see a list of supported delivery destinations, as you can see FTP and SFTP are supported. A VPN isn't a requirement, it all depends on the networking needs for your OAC instance to reach the SFPT…

I'm quite sure OAC does support a lot more than what you think, the detail is that the real smart piece of OAC is the good old RPD (or semantic model as they start calling it because of the availability of the semantic modeler). In the RPD you can do generally do everything by modelling things accordingly. Creating…

I would agree with what Michal said: the catalog archive does not contain any information about absolute paths, you can restore it where you want but you need to execute the import where you want it. I highly doubt they did change the behavior of that 10+ years old piece of logic just for this (even if the DVA does contain…

The "Export" seems to be a hybrid between DV export and catalog archive. If you do export from Catalog in DV you get a file containing a catalog archive (the same good old archive that exist for more than 10 years) for everything that is just part of the catalog (folders, DV workbooks, analysis, dashboards, agents etc.)…