Thursday, October 27, 2016

Oracle DV - New filtering options in Oracle DVD 12.2.2

Visualizations in Oracle DV are not just cool looking charts, they have the capability to drive your analysis and gain wonderful insights from your data. Oracle DV already has capability to use any visualization as a filter.  The selected visualization acts a driver and filters all the visualizations in that canvas according to your selection on the driver visualization. This helps users in narrowing their analysis. How to do that? Its just few mouse clicks.
       With Oracle DVD 12.2.2, Visualizations have become even more powerful and functional and therefore integral part of your analysis flow. In Oracle DV 12.2.2, now users can also add visualization level filters. The visualization level filters help users add filters to the visualizations they are interested in rather than the entire canvas.

Please go through this demo video to see new filtering options in Oracle DVD 12.2.2 :

Monday, October 24, 2016

Upgrade OBIEE in your SampleApp V607 to 12.2.1.2


Want to have OBIEE 12.2.1.2 in your SampleApp V607 and enjoy VA lightweight SSO (no double logins when opening VA), or dva projects import/export ?
You can directly upgrade the version of OBI in your image to 12.2.1.2 by following simple steps, without losing any of your content. 

Download the software from here  and follow the steps outlined in this doc to perform this update:

This is an inplace upgrade, that is, the upgrade operations are performed on the existing 12.2.1.1 domain, so you wont loose any dashboards/reports that you built. 

Friday, October 21, 2016

Oracle DV - Connect to Dropbox and fetch files directly

Want to analyze the Sales performance data present in excel & .csv files in your Dropbox account?? 

With Oracle DV you don’t even have to download them. New Oracle DV Desktop allows to connect to your Dropbox account and fetch excel, .csv files for analysis. You can prepare the data using host of available wrangling functions, then visualize and analyze the data to gain insights.

In case the data in the excel sheet is updated you don’t even have to re fetch the files. All you have to do is refresh your data sources in Oracle DV. The modified files will be fetched automatically from your Dropbox account.
How to connect to Dropbox? Users have to generate the OAuth credentials from Dropbox developers’ console and use those credentials in connection page of Dropbox.


This video demonstrates how to connect to Dropbox and perform analysis:




Oracle DV - Connect to Dropbox and fetch files directly

Want to analyze the Sales performance data present in excel & .csv files in your Dropbox account?? 

With Oracle DV you don’t even have to download them. New Oracle DV Desktop allows to connect to your Dropbox account and fetch excel, .csv files for analysis. You can prepare the data using host of available wrangling functions, then visualize and analyze the data to gain insights.

In case the data in the excel sheet is updated you don’t even have to re fetch the files. All you have to do is refresh your data sources in Oracle DV. The modified files will be fetched automatically from your Dropbox account.
How to connect to Dropbox? Users have to generate the OAuth credentials from Dropbox developers’ console and use those credentials in connection page of Dropbox.

This video demonstrates how to connect to Dropbox and perform analysis:




Oracle DV - Connecting to MS Access

Visualize data present in MS Access database and draw meaningful insights using Oracle DV. New Oracle DV can connect to MS Access and fetch the data by selecting the tables they want to analyze. Users can also fetch the data using Custom SQL. Data fetched from MS Access can be wrangled/prepared in Oracle DV and can be mashed up with data from other data sources seamlessly.

How to connect to MS Access from Oracle DV? It’s as simple as choosing the access database files on which you want to perform Analysis. Oracle DV supports multiple file formats of MS Access db files like .accdb & .mdb. Users have to mention the File Name along with Path information and Username, password (if any) to access the files. Viola! They have their MS Access data ready for Analysis in Oracle DV.


Take a look at this video to see how to connect to MS Access from Oracle DV:


Thursday, October 20, 2016

Oracle DV - Connecting to Apache Drill

Oracle DV introduces a data source connector to Apache Drill and opens the door to some powerful analysis opportunities.

Apache Drill is an open-source software framework that supports data-intensive distributed applications for interactive analysis of large-scale datasets. Drill supports a variety of NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. It can access these data sources by simply configuring storage plugins on the Drill web console.

With Oracle DV's connectivity to Apache Drill, you can now explore, query and visualize different types of datasets simultaneously without having to write code or build custom applications.





#OracleDVD 2, Share, Export & Print


Oracle DVD 2  offers users a variety of easy to use options to share their data.  Export your entire project to be shared with other DV users, create pdfs and ppts for your presentation or extract the underlying data directly into a re-usable xlsx format.