Yes.  BI Connector works with Oracle BICS / Oracle Analytics Cloud (OAC) / Oracle Autonomous Analytics Cloud (OAAC).  When you configure ODBC DSN for Oracle BICS / Oracle Analytics Cloud (OAC) / Oracle Autonomous Analytics Cloud (OAAC), 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/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.