I have some reports thare currently in a folder with Shared Folders and I need to export the catelog from my production environment to my pre-production enviroment - suggestions please...
Catalog Manager has an archive and unarchive feature. Did you try it?
The first thing to do is to know if you just want to copy a part of the catalog, a folder and all its content for example, or the whole catalog (including the personal folders).
If it's the first case (that's what your original question hints at), if you have an account with the permissions to access all the objects in the folder you want to copy, you can do it from the web interface directly, just open the 2 environment in 2 pages: archive in one, download the file on your PC, unarchive in the second by uploading the file you just saved.
In alternative to the web interface you can use Catalog Manager installed when you install the OBIEE client tools. Connect to one environment, archive and save the file somewhere, connect to the second environment and unarchive the file.
If permissions can be a problem, you will have to work offline. You can connect in offline mode with the Catalog Manager tool, but that requires to be on the OBIEE server itself (if it's a linux without GUI, Catalog Manager also fully works by command line). When connecting offline you should provide the path on disk where the catalog is physically stored (and in OBIEE the catalog is still on disk, it's only with OAS that it has been moved inside the database).
Hi @User_3V9PJ,
If you are looking to move only specific catalog folders and objects you can use Archive(source env) and Unarchive in target environment.
If you want to move the entire catalog you can use BAR file approach if it's OBIEE 12c and higher versions.
What process is required for the BAR file approach to export (and then import)
Hi @User_3V9PJ ,
To export/import using BAR fil, please look at this MOS note:
2611464.1 OBI 12c: How To Export/Import Metadata To/From A BAR File Using 'exportarchive' And 'importarchive' Commands
Here is the Oracle documentation:
Managing Metadata and Working with Service Instances
https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-7FCD90A3-E005-49BF-902F-30FBF9B41B07.htm
Regards,
Ezequiel.
WIll the Catalog manager allow me to export and tehn import the catelog to a different environment
Yes, because the "archive" generate a file, and when you do the "unarchive" you much provide the file you want to unarchive.
You just have to connect to the 2 different environments for the job.
What is the best way to connect the environments to complete the process
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
