Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Why can't we access Database objects from APEX when we opt for BICS Database as a Service?

Received Response
31
Views
1
Comments
Lavanya Uppalanchi
Lavanya Uppalanchi Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Why can't we access Database objects from APEX when we opt for BICS Database as a Service?

Content

Hello Team,

We opted  for DBaaS Offering in BICS. We are Using new database schema connection  as Data Warehouse instead of Default Schema which comes with Schema as a service offering,but we are not able to see  objects like connection information,tables, Views of new database schema etc in APEX, we can able to see only default schema objects in APEX.

Is it possible to access new database schema objects through APEX?

Answers

  • Hasso Schaap
    Hasso Schaap Rank 4 - Community Specialist

    I am not sure what you are asking. So I will make a guess:

    You can only connect to 2 Cloud sources:

    1. Database Schema Service that comes with BICS (this is the Default Connection)
    2. Database Cloud Service (DBCS)

    To access a schema in a Oracle database running in DBCS  first create a connection to this database in the Console.

    Then create a new Model on this New Connection. You will be able to import from your Database Cloud Service for the Schema you used in your connection.

    There are currently 3 limitations:

    1. You can't traverse schema's with the webbased BI Modeler
    2. Any webbased BIModel can only use 1 connection at a time

    To solve this use Lift and Shift a full RPD.