Does BI Connector work with Oracle BICS / Oracle Analytics Cloud (OAC) / Oracle Analytics Server (OAS) / Oracle Autonomous Analytics Cloud (OAAC)?

Modified on Mon, 19 Oct 2020 at 05:53 AM

Yes.  BI Connector works with Oracle BICS / Oracle Analytics Cloud (OAC) / Oracle Analytics Server (OAS) / Oracle Autonomous Analytics Cloud (OAAC).  When you configure ODBC DSN for Oracle BICS / Oracle Analytics Cloud (OAC) / Oracle Autonomous Analytics Cloud (OAAC), Oracle Analytics Server (OAS)  you should use the following settings:



  1. Server Name:  Please enter the server name for your OAC here.  
  2. Port:  Use 443
  3. Check the Single Sign-on box
  4. Choose one of the following options:
    1. If your BICS/OAC/OAS/OAAC environment uses Oracle Access Manager, ie., if the URL for the login page to your Oracle Cloud has "oam", then choose OAM in the drop-down list.  
    2. If it doesn't include OAM, then choose "Default" in the drop-down list.


With these settings, if the Test Connection is unsuccessful, please contact us at support@biconnector.com with your BI Connector log file.  We will work with you to help troubleshoot the root cause of the issue.