Oracle Data Visualization Cloud Service

存储架构 2017-11-15

Oracle Data Visualization Cloud Service


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


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.


Infosys-Oracle Blog

责编内容by:Infosys-Oracle Blog (源链)。感谢您的支持!


中国唯一一家盈利的公有云公司,在AI上是这么布局的... 【本文来自钛媒体特色栏目「快公司」,项目由TMTBASE数据库「我造社区」推荐】 作为国内最早成立的一批公有云创业公司,UCloud如今已战绩...
Oracle 约束(constraint) (一)约束的概念 在Oracle中,可以通过设置约束来防止无效数据进入表中。Oracle一共有5种约束: 主键约束(primary key)...
Oracle Defends the Java Platform Module System (JP... One of the more timely presentations at the 2017 Emerging Technologies for t...
微软改组全球销售团队专注于云服务 或裁员数千人... 据《华尔街日报》报道,本周一,微软公司重组其全球销售团队以专注于云服务。知情人士透露,团队重组将导致数千人的裁员。微软全球副总裁Judson Althoff在本...
响应式 Web 应用(一) 在过去几年,Web 应用开始在我们的生活中发挥越来越重要的作用,不论是像社交网络这样的大型应用、电子银行站点这样的中型应用,还是一些小型应用,如在线账户系统以...