Contents
How to setup BI Publisher
Objects in Oracle Cloud POD
1. Local Connections with Administrator Privileges
When you are using a local connection and have the admin privileges, SQLConnect will automatically upload BI Publisher Objects for you. You will get following message. You can check if you have administrative privileges or not using instructions listed in Step 5
Please go through Step 4 to setup the permissions
2. Update Existing Connections with administrative privileges
In case of P2T you may have to setup the connections information again, you can upgrade the existing connections. If you are using Local Oracle cloud login and have administrative privileges, then you can follow the steps as in screenshot below.
3. SSO Connections/ or Without administrative Privileges
At the time of setting up SQLConnect, if you do not have admin Privileges or if you are logging in as SSO, you will get following message.
You can follow the steps below to setup
3.1 Download the latest catalog file
3.2 Login to Oracle POD as BI Publisher Administrator
Once the file is up, login to your Oracle Cloud POD as an administrator
Example URL:
You will see on the right if you have admin rights or not
3.3 Unarchive the Catalog file downloaded earlier
Click on Custom Folder, Unarchive the file you have downloaded.
After uploading the files, Please go through Step 4 to setup the permissions.
4. Set Permissions
Once the object is uploaded, Cloud Tools folder should appear in Custom Folder.
At this time change the permissions so that only BI Administrator (or any IT Developer role) has access to run queries using SQLConnect.
After deleting the undesired roles, you can apply permission to items within folder and subfolders.
5. Check if you have administrative privileges in BI Publisher
Login to your Oracle Cloud POD BI Publisher
Example URL:
You will see on the right if you have admin rights or not
