{"id":7863,"date":"2019-03-01T16:44:58","date_gmt":"2019-03-01T16:44:58","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/oracle-data-visualization-desktop\/"},"modified":"2026-11-03T19:29:06","modified_gmt":"2026-11-03T19:29:06","slug":"oracle-data-visualization-desktop","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/oracle-data-visualization-desktop\/","title":{"rendered":"Oracle Data Visualization Desktop"},"content":{"rendered":"<p><strong>Introduction<\/strong><\/p>\n<p>This blog covers how to use the Oracle\u00ae Data Visualization Desktop (DVD) to&nbsp;analyze data. Oracle&#8217;s DVD version 12.2.4.3, released in May 2018, makes it easy to visualize&nbsp;data. You can upload data files or connect to a database by using available data&nbsp;sources.<\/p>\n<p>DVD is a single-user desktop application that provides visualization functionality&nbsp;to business users. DVD is better than the Oracle Business Intelligence Enterprise&nbsp;Edition (OBIEE) 12C analyzer and is a user-friendly tool.<\/p>\n<p><strong>Benefits<\/strong><\/p>\n<p>DVD offers the following benefits:<\/p>\n<ul>\n<li>A personal, single-user desktop application: Install on personal systems and analyze the data there.<\/li>\n<li>Offline availability: Shared and imported projects are always available.<\/li>\n<li>Completely private analysis: Analyze data without depending on others.<\/li>\n<li>Full control of data source connections: Choose from many connection types&nbsp;that provide secure connections.<\/li>\n<li>Direct access to on-premises data sources: Connect to the database by using a VPN.<\/li>\n<li>Lightweight single-file download: Directly download and install the `.exe` file.<\/li>\n<li>No remote server infrastructure: Easily manage the standalone application on your personal system.<\/li>\n<li>No administration tasks: Administrative tasks like start, stop, and upgrade&nbsp;are&nbsp;required.<\/li>\n<\/ul>\n<p><strong>Installation&nbsp;<\/strong><\/p>\n<p>DVD installation has the following minimum system requirements:<\/p>\n<ul>\n<li>Operating system: Microsoft\u00ae; Windows\u00ae x64 (64-bit) 7 SP1+, 8.1, or 10; Windows Server\u00ae; 2012 R2; MacOS\u00ae Sierra (10.12) or High Sierra (10.13)<\/li>\n<li>CPU: Inte\u00aeCore&amp;trade;2 Duo CPU E8400 @ 3.00 GHz, 2992 Mhz 2 Cores, 2&nbsp;logical processors or faster<\/li>\n<li>Memory: 4.00 GB memory or more<\/li>\n<li>Minimum free disk space: 2 GB plus space for any uploaded data files<\/li>\n<li>User privileges: Administrative privileges to install<br \/>\n\t&nbsp;<\/li>\n<\/ul>\n<p>When you select <strong>From Database<\/strong>, you see the available database connection&nbsp;types as shown in the following image:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture4_12.png\" alt=\"Oracle dvd pic 4\" \/><\/p>\n<p>When you select <strong>Oracle database<\/strong>, you are prompted for connection details as&nbsp;shown in the following image:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture5_10.png\" alt=\"oracle dvd pic 5\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Features of DVD version 12.2.4&nbsp;<\/strong><\/p>\n<p><strong>DVD features include the following items:<\/strong><\/p>\n<ul>\n<li>New data connector types<\/li>\n<li>Duplicating data sets<\/li>\n<li>Machine learning (ML) capabilities to make predictions and intelligent suggestions<\/li>\n<li>Data flow enhancements<\/li>\n<li>Data source editor changes<\/li>\n<li>Updates to projects and visualizations, including map backgrounds<\/li>\n<\/ul>\n<p><strong>Create a project and choose a data set&nbsp;Create a project and choose a data set<\/strong><\/p>\n<p>By using DVD, you can analyze data from various data sources such as Microsoft&nbsp;Exce\u00ae, database, and Oracle applications, by creating a project and data&nbsp;sets to fetch data.<\/p>\n<p>To create a project, use the following steps, as shown in the following image:<\/p>\n<p>1. Go to the Main Menu.<\/p>\n<p>2. Select <strong>Project<\/strong><\/p>\n<p>3. Click <strong>Create<\/strong>.<\/p>\n<p>4. Click <strong>Data Set<\/strong><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture2_21.png\" alt=\"Oracle dvd pic 2\" \/><\/p>\n<p>After you click <strong>Data Set<\/strong>, you must select from the data sources as shown in&nbsp;the following image:&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture3_18.png\" alt=\"oracle dvd pic 3\" \/><\/p>\n<p><strong>From a File<\/strong>: You can upload an Excel file (assuming the first row of the spreadsheet is column headings).<\/p>\n<p><strong>From Oracle Applications<\/strong>: You can connect to live OBIEE instances, where OBIEE reports as direct sources.<\/p>\n<p>From Database: You can connect to various databases such as Oracle, DB2&amp;reg;, MySQL\u00ae,&nbsp;and so on.<\/p>\n<p><strong>Connect to a database<\/strong><\/p>\n<p>When you select <strong>From Database<\/strong>, you see the available database connection types as shown in the following image:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture4_11.png\" alt=\"Oracle DVD Pic 4\" \/><\/p>\n<p>When you select <strong>From Database<\/strong>, you see the available database connection&nbsp;types as shown in the following image:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture4_13.png\" alt=\"oracle dvd pic 4\" \/><\/p>\n<p>When you select <strong>Oracle database<\/strong>, you are prompted for connection details as<br \/>\nshown in the following image:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture5_11.png\" alt=\"oracle dvd pic 5\" \/><\/p>\n<p>After the data source is connected, click on <strong>Create Data Set<\/strong>&nbsp;on the home page&nbsp;and select the tables to use by clicking on the available schemas in the database.&nbsp;After the Data Set is created, you can modify the columns or add new columns in&nbsp;the Data Set.&nbsp;<\/p>\n<p>You can use <em>Shift+click<\/em>&nbsp;or <em>Ctrl+click<\/em>&nbsp;to select multiple columns. Click&nbsp;<strong>Add Selected<\/strong>&nbsp;to add the columns you selected, or click <strong>Add All<\/strong>&nbsp;to include&nbsp;all the table columns in the data source. Drag identical columns to the dashboard&nbsp;data element, and click <strong>Change Visualization Type<\/strong>&nbsp;in the canvas as shown in the following image:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture6_7.png\" alt=\"Oracle DVD pic 6\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture6_9.png\" alt=\"oracle dvd pic 6\" \/><\/p>\n<p>The visualized canvas has a color section, which allows you to make the&nbsp;visualization more attractive by adding colors to measure values, as shown in&nbsp;the following image:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture7_6.png\" alt=\"oracle dvd pic 7\" \/><\/p>\n<p>The following image shows the project view after you add data elements to the&nbsp;dashboard::<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture8_7.png\" alt=\"oracle dvd pic 8\" \/><\/p>\n<p>Each canvas at the bottom of the dashboard can have multiple visuals of data.<\/p>\n<p>You can duplicate the canvas and visuals, and you can change the visualization&nbsp;depending on your needs. You can also add an image to canvas such as adding&nbsp;client logs to dashboard.<\/p>\n<p>The following images show the canvas view:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26523-body-Picture9_4.png\" alt=\"oracle dvd pic 9\" \/><\/p>\n<p><strong>Importing and sharing<\/strong><\/p>\n<p>\nDVD has options to share the project files with other users and to import&nbsp;project files shared by external users. When you share the project, you need to&nbsp;give the password to protect the file.<\/p>\n<p><strong>Importing<\/strong><\/p>\n<p>Follow these instructions to import a project or application:<\/p>\n<p>1. Go to the Home page.<br \/>\n2. Click <strong>Projects<\/strong><br \/>\n3. Click <strong>Page Menu<\/strong>.<br \/>\n4. Select <strong>Import<\/strong><br \/>\n5. In the <strong>Import<\/strong>&nbsp;dialog, click <strong>Select File<\/strong>&nbsp;or drag a project or application file onto the dialog.<br \/>\n6. Click <strong>Import<\/strong><\/p>\n<p><strong>#### Sharing a project<\/strong><br \/>\nFollow these instructions to share a project:<\/p>\n<p>1. Go to the Home page.<br \/>\n2. Click <strong>Projects<\/strong><br \/>\n3. Select the project or folder that you want to share.<br \/>\n4. Click <strong>Actions<\/strong><br \/>\n5. Select <strong>Share<\/strong><br \/>\n6. Click <strong>File<\/strong><br \/>\n7. In the <strong>File&nbsp;<\/strong>dialog, click <strong>Include Data<\/strong>&nbsp;to include the data with the&nbsp;project or folder.<br \/>\n8. If you want to include the data source connection\u2019s username and password with the exported project, click <strong>Connection Credentials<\/strong><\/p>\n<p><strong>Differences between Oracle DVD and 12C OBIEE VA<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_technical_images\/26523-body-Captureoracle-dvd.PNG\" alt=\"table showing differences\" \/><\/p>\n<p><strong>Conclusion&nbsp;<\/strong><\/p>\n<p>Oracle DVD is a simple business intelligence (BI) tool that is used to analyze data, and it doesn\u2019t need to connect data warehouse instances. Easy to install&nbsp;on a desktop, DVD enables you to analyze data by connecting with various data&nbsp;sources. It\u2019s a user-friendly tool and can be used by anyone with minimal&nbsp;knowledge of analysis.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Data Visualization Desktop<\/p>\n","protected":false},"author":2,"featured_media":7865,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26523","content_type":"blog","created_by":"10130","authored_on":"2024-01-21T16:44:58+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Praveen Muthyala, Oracle Applications Database Administrator , Rackspace Technology","seo_description":"Continue upgrading Vertex 9 for Oracle E-Business Suite (EBS) R12.2. Configuration details for the upgrade process.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26523-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2019-03-01T16:44:58","rxt_solutions":"Application Modernization, Databases, Data Management, Data Modernization","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Oracle Data Visualization Desktop | Rackspace Technology","field_topics":"","field_slug":"oracle-data-visualization-desktop","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7863","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7863"}],"version-history":[{"count":4,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7863\/revisions"}],"predecessor-version":[{"id":17132,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7863\/revisions\/17132"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7865"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}