OAC Semantic Layer access to Third party visual tool

Kumar.Eswaran

Can we have third party visual tools (Like Microsoft POWER BI) to access OAC Semantic Model. It helps to use OAC built-in/custom data models (Now MS calls it as Semantic Model too) rather than creating those custom models in Power BI. In this way all oracle customers can use OAC for keeping their models and just go out for visual tool of their choice.

Michal Zima

@Kumar.Eswaran OAC/OAS , respectively its core component BI Server act (for "outside world") as virtual data source, to which you can connect via ODBC/JDBC interface and leverage Subject Areas (objects in Presentation Layer of semantic model, the only visible layer in metadata) for querying - creating logical SQL queries from columns/tables in Subject Areas. So any "external" tool is able to connect (via ODBC/JDBC connectivity) to connect to Semantic Model and query data (using Logical SQL) . Besides this, there is special Power BI Connector (which is installed into Power BI Desktop), which allows you to connect to Semantic Model (metadata of OAC) and use Semantic Model as source for Power BI visualization (basically it this connector leverage the same as described above, it just make your live more easier, you don't have to write logical SQL by yourself, just picking columns from Subject Areas - the same way as you work with Subject Areas in Answers or DV).