Throughout 2016, I posted a series of blogs introducing Oracle’s recent additions to its Data Visualization portfolio – Data Visualization Cloud Service (DVCS) and Data Visualization Desktop (DVD).
My summary blog at the end of that series, highlighted that throughout 2016, Oracle appeared to be focusing its attention on developing DVD rather than DVCS. A series of releases to DVD (up to 184.108.40.206 at that time) had extended the product functionality, whereas DVCS remained largely unchanged.
I felt that this was a shame because DVCS was more easily suited to collaborative working, and was a better fit for organisations expanding their Cloud operations.
But, in June this year, Oracle upgraded the features of DVCS to be more in line with DVD version 220.127.116.11. So DVCS now includes, amongst other things, the following features that were previously available in DVD:
Further details of many these features are illustrated in my earlier blogs.
One of the most significant enhancements to DVCS, in the upgrade since last year, is the ability to connect directly to a database. Previously a tool, such as DataSync, was needed to create a data source from database data. However, there are caveats.
At the moment, the database connections available are limited to Oracle databases, and because DVCS is in the Oracle Cloud, a network connection is required between the database and the cloud where DVCS is running.
Therefore, in order to connect to a database, the options are to:
Unfortunately, option c) is only available to Oracle Analytics Cloud (OAC) and option d) is only available using BICS or OAC.
Since option b) is undesirable, the only feasible current option is to connect to a database in the Oracle Cloud. However, this is a step forward for DVCS.
I was able to create a connection to a cloud database, the steps for which are identical to connecting to an on-premise database using DVD. These steps are described in my earlier blog about managing data sources.
While DVCS has seen a significant upgrade, there have also been a few enhancements to DVD (version 3 released at the end of June).
While DVD still remains ahead of DVCS in terms of Data Source availability and VA functionality, with the latest upgrade of DVCS it is closing the gap. This is great news. With this additional functionality, including the ability to connect to your cloud databases, plus the ability to share your content more easily than DVD, including embedding content into other web-based applications, DVCS has become a much more attractive product.
Next time I will demonstrate how to integrate your DVCS visualizations with your APEX applications.
Both DVCS and DVD are available to use to trial / evaluate:
Author: Philip Ratcliffe
Job Title: Oracle APEX Development Consultant
Bio: Philip is a Development Consultant at DSP-Explorer. Building on considerable experience in development including using Oracle PL/SQL and supporting Oracle EBS, Philip is employing APEX to provide quality, bespoke software solutions to a range of organisations.