Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Transaction matching of around two million records in under 5 minutes in ARCS | Main | Cross Module Integration-EPBCS and EPRCS »

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, Auto coloring, 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

OOB + Custom OBIEE Business Logic and reports

 

Or RDP

 

  • 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. In its current release, it 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

 

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles