Oracle Data Visualization Cloud Service

Oracle Data Visualization Cloud Service

Overview

Visual Analysis and Self Service discovery cloud service from Oracle. It has the following main features

  • Easy Upload

Upload data from a variety of sources (for example, spreadsheets, CSV files, Fusion Applications, and many databases) to your system and model it in a few easy steps

  • Simple Mash up

Data from different sources is automatically connected

  • Easy Exploration

Create visualizations and projects that reveal trends in your company’s data by creating insights and stories

  • Visual Experience

Auto visualization, Brushing and Intuitive, Filtering, Autocoloring, Built in Maps

Data Sources

DVCS can use data from the following sources for creating stunning visualization projects

  • Spreadsheet /CSV (<= 50="" mb="" in="" size)

  • Data from Oracle Applications data sources

  • Oracle Transactional Business Intelligence Oracle BI EE analysis and subject areas

  • Data from a database as a service or on premise database using Remote Data Connector

  • Data from various on premise data sources such as (CSV, relational Databases, SQL query) can be uploaded and used in DVCS using Oracle Data Sync

  • Oracle Data Visualization Cloud Service REST API can also be used to programmatically load on-premises data to a data set that you can explore

Sample Hybrid Cloud Architecture with OBIA, OTBI and DVCS

  • DVCS can be used to create visualization stories and projects directly using data from Oracle Applications data sources with Oracle Transactional Business Intelligence using Oracle BI EE analysis and subject area

  • Data extracted from the cloud ERP into an on premise data warehouse can then be used to create data visualization analysis and projects

DVCS Security Features

  • Identity domain

    • Identity Domain is a construct for managing certain features of Oracle Cloud including DVCS

    • The identity domain controls the authentication and authorization of users who sign in to Oracle Cloud services including DVCS

    • Several predefined roles and user accounts are available when DVCS is provisioned in an identity domain

    • If one has EBS on the cloud and uses DVCS to connect directly to OTBI subject areas. The 2 cloud services can share the same identity domain or it can be separate. The specifications of choosing the identity domain should be in the contract, but in theory both cases are possible

    • The roles in Identity domain are recognized in Web Logic

  • SSO

    • SSO is a token service for authentication while an identity domain allows you to manage users and roles.

    • One can integrate existing Oracle SSO with the identity domain of DVCS

  • Application Roles

    • Comprises a set of privileges that determine what users can see and do after signing in to Oracle Data Visualization Cloud Service

    • There are two types of application role

      • Predefined

      • User Defined

  • Data Level Security

One cannot control data visibility within DVCS but only control object visibility based on Application Roles/Users => meaning you can control which report a user can see but you cannot control what data the user can see in the report. This is because you don’t do any modeling within DVCS, so no data filters can be applied. The data visibility is driven by the username used to connect to OTBI – whatever data this user sees will be visible within DVCS

Conclusion

DVCS is a powerful addition to the Oracle BI tools. It provides self-data discovery features with rich UI and visualization capabilities. It’s a step in the right direction towards incorporation of the modern BI and Analytics features. It supports cloud and hybrid deployments supported. DVCS be used for root cause analysis data visualization project. Supported by Oracle’s strong infrastructure, it provides an attractive option for Oracle’s install base. It is not typically used for creating reports with large volumes or large number of columns. Using BICS, OBIEE, OAC one can develop tabular report with 500+ or 1000+ columns. t is not possible to print or share (create for example a pdf and then send it via email) analysis created from the catalog those buttons are disabled.

References

https://docs.oracle.com/en/cloud/paas/data-visualization-cloud/bidvc/getting-started-data-visualization.html

Infosys-Oracle Blog稿源:Infosys-Oracle Blog (源链) | 关于 | 阅读提示

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 后端存储 » Oracle Data Visualization Cloud Service

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录