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

Question

Summary

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?

Hasso Schaap · Answer

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

You can only connect to 2 Cloud sources:

* Database Schema Service that comes with BICS (this is the Default Connection)
* 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:

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

To solve this use Lift and Shift a full RPD.