Let me check with the OTBI and BIP teams if this feature is in their roadmap and get back.

We are not querying the tables. We are using REST APIs of OAC to pull the data and store the outcome JSON file Locally. Using the JSON File Transform the output to a CSV file taking the required information from the JSON file. Uploading the resultant CSV file as a Dataset and building a report as an example, you can even…

Will Update soon

Sol3. Reply: Yes, you understood correctly. When you have two OAC instances in different OCI regions for Disaster Recovery, OACP and OACDR. Daily create Snapshot and Data File backup on OACP and store to the Object Storage. Upload the Snapshot and Data files from the backup to OACDR and restore them periodically or when DR…

Sol2. Reply: If your ADWNP and ADWDR are in different Subnets of the same VCN: 1. OAC is in the same Region as ADW and the same VCN but a different Subnet of the ADW VCN, use Ingress Rules in the Security List or NSG and configure such that OAC is able to reach the ADWNP or ADWDR. 2. OAC is in the same Region as ADW but on…

Sol1. Reply: Yes, it is possible. As long as the target ADW (ADWP or ADWDR) is reachable to the respective OAC (OACP or OACDR) using the PAC (OACP-PAC or OACDR-PAC), you can replace the wallet.sso, hostname, port in the console connection, and update connection to the ADW. Make sure you configure the OAC to reach the ADW…

If the SSO is through OAM, ensure that you exclude OPTIONS in OAM Configuration.

If the OAS SSO is configured using Custom SSO (Hybrid Model) using SAML SSO Docker approach, the config in Apache HTTP Server for analytics.conf should be as below to exclude OPTIONS for dv. <Location /dv> SetHandler weblogic-handler WeblogicHost <oac-bi-weblogic-hostname> WebLogicPort 9704 WLIOTimeoutSecs 6000…

Solution when OAS is configured SSO using SiteMinder: 1. in SSO siteminder a. Removed OPTIONS from the protected realm b. set autoauthorizeoptions=Yes 2. in APACHE conf Added below headers value in Virtual host 443 Header set Access-Control-Max-Age "300" Header set Access-Control-Allow-Credentials "true" Header set…

please approach me at veera.raghavendra.rao@oracle.com

Please check this Doc attached (Maybe it's better not to attach the doc if you want the doc to share your email and I can send you directly) I used a Static password. If you want you can have a Random number or a system date command to execute and compare it as a user's password. No real column in the table. SELECT…

It's already there in the OAS Documentation, For SSO to work we need Users and Groups from either the WebLogic Embedded LDAP or External Authenticator like any LDAP (MSAD, MS ADLDS, Open LDAP, ODSEE, OID, OUD, etc) We Delegate Authentication to SAML IDP. We perform Authorization at the product level. So we need the same…

You can use BISQLGroupProvider to map LDAP Users with Database Groups. If you have both Users and Groups from Oracle Database, you can use SQLAuthenticator or ReadOnlySQLAuthenticator.…

Hi Alan, Please recheck, you are wrong. the Doc ID : 2761678.1 is still pointing to the SAML and Kerberos SSO for OAS. There might be some confusion at your end, please recheck. (Also attaching the screenshot) Oracle Support Document 2761678.1 (SAML 2.0 and Kerberos Single Sign-On Configuration for Oracle Analytics Server)…

Coming to the SSO Solution for OAS on Windows, I'll need to discuss with Product Management and take a decision to make it public or not. For now, the MOS Doc is Internal and we can share with Customers only upon request for the Solution on Windows. I will update in Jan 2022.

https://support.oracle.com/epmos/faces/DocContentDisplay?id=2707401.1 This covers Kerberos SSO without Docker on Linux for OAS 5.5 basic Version without patches and OAS 5.9 and 5.9+

SAML 2.0 and Kerberos Single Sign-On Configuration for Oracle Analytics Server (Doc ID 2761678.1) This is the Docker Container-based approach for OAS Custom SSO for both SAML2 and Kerberos on Linux. SAML2 SSO works with OAS 5.5 and 5.9 whereas Kerberos SSO on Linux works only with OAS 5.5 Basic version without patches and…

SAML SSO for OAS on Windows is available as a Internal document. If any Customer requires the doc for Windows, can raise a SR and the Support Engineer should be able to upload the required Document and scripts downloadable link.

Hi, this is the Blog owner. I shall document steps to implement on Windows soon and update you. Also, the same docker image can be run on windows docker if you have Docker-based knowledge. Anyways I'll document steps for Windows without Docker. Please approach me through the comments on the blog.…