Tips and Tricks and When to Use Oracle Analytics Desktop

Oracle Analytics allows customers to get insights on data with a couple key deployment options; cloud (OAC) and on-premises (OAS). This should cover most needs, but there are a couple of specific reasons for a desktop version.

First, if you just want to try things out you can download the desktop version. One great way check out the product is to try the free Udemy course – Modern Data Visualization with Oracle Analytics Cloud. The course can be done with OAC but the course will direct you to desktop in case you are just kicking the tires.

Second, if you need to leverage our SDK and build a custom visualization like the ones we publish to the Oracle Analytic Library. Here are some links in case you want to get started down a path of custom plugin development.

https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/create-custom-data-action-plug-ins.html#GUID-6D2C8C70-A88C-4F92-A64A-376DE7AA18E3

https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/data-visualizer-sdk-reference.html#GUID-55B663FC-9445-44CC-9C7E-CDF70D42FB4A

Also here is part one of a four part blog dedicated to building visualization on MacOS. Keep in mind these steps can be easily applied to Windows and know a Windows version of this blog is on the to do ✅ list.

https://www.linkedin.com/pulse/oracle-analytics-1-creating-custom-visualization-macos-krooss/

Tips and Tricks

So now that you know when to use Oracle Analytics Desktop here are some tips to help you along.

Run in SDK Mode

For SDK Development you will need to know how to run in SDK mode. Here are the basic command line arguments for Windows and Mac.

Windows:
"C:\Program Files\Oracle Analytics Desktop\dvdesktop.exe" --args -sdk -jettyPort=8800

Mac:
open /Applications/dvdesktop.app --args -sdk -jettyPort=8800

-sdk will launch using the standard port unless -jettyPort is used.

Clean Uninstall

By default the uninstalls will just remove the application so that when you re-install the content is still in place. With that, there are times you want to do a full uninstall and remove everything you ever created on Oracle Analytics Desktop. Below are some scripts for Windows and Mac that do just that.

Keep in mind this will remove everything, never to be recovered!!

#!/bin/sh

# Uninstall Data Visualization for Desktop on Mac
echo "Uninstalling Oracle Analytics for Desktop on Mac..."

sudo rm -rf "/Applications/Oracle Data Visualization for Desktop.app"
sudo rm -rf "/Applications/Oracle Data Visualization Desktop.app"
sudo rm -rf "/Applications/Oracle Analytics for Desktop.app"
sudo rm -rf "/Applications/Oracle Analytics Desktop.app"
sudo rm -rf "/Applications/DVDesktop.app"
sudo rm -rf "/Applications/Oracle Data Visualization Desktop Configure Python.app"
sudo rm -rf "/Applications/Oracle Analytics Desktop Configure Python.app"

# Uninstall All Data and Projects
echo "Uninstalling All Data and Projects..."

rm -rf ~/Library/Application\ Support/DataVisualization
rm -rf ~/Library/Application\ Support/DVDesktop
rm -rf $TMPDIR/DVDesktop

echo "Finished Uninstallation process."
@ECHO OFF

ECHO This will delete the following directories:
ECHO.
ECHO %localappdata%\DVDesktop"
ECHO %localappdata%\temp\DVDesktop
ECHO %localappdata%\DataVisualization
ECHO.
ECHO This will clean up the Oracle Analytics Desktop installation and it will remove all artifacts you have created including projects and data sets.
ECHO.
ECHO Basically it will all be gone, so continue with care!!
ECHO.

SET /P startCleanup=Do you want to continue (y=yes):

IF '%startCleanup%'=='y' (

ECHO.
ECHO Attempting to delete the directroy %localappdata%\DVDesktop

IF EXIST "%localappdata%\DVDesktop" (
	@RD /S /Q "%localappdata%\DVDesktop"
	ECHO deleted the directroy %localappdata%\DVDesktop
) ELSE (
	ECHO Could not find the directroy %localappdata%\DVDesktop
)

ECHO.
ECHO Attempting to delete the directroy %localappdata%\temp\DVDesktop

IF EXIST "%localappdata%\temp\DVDesktop" (
	@RD /S /Q "%localappdata%\temp\DVDesktop"
	ECHO deleted the directroy %localappdata%\temp\DVDesktop
) ELSE (
	ECHO Could not find the directroy %localappdata%\temp\DVDesktop
)

ECHO.
ECHO Attempting to delete the directroy %localappdata%\DataVisualization

IF EXIST "%localappdata%\DataVisualization" (
	@RD /S /Q "%localappdata%\DataVisualization
	ECHO deleted the directroy %localappdata%\DataVisualization
) ELSE (
	ECHO Could not find the directroy %localappdata%\DataVisualization
)

) ELSE (
ECHO OK nothing cleaned up
)
@pause

Quit OA Desktop on Mac

Sometimes, and deepening on what MacOS you have installed it can be tricky to quit the application and all its running processes (working on fixing this). If you know what to look for this can be done using Activity Monitor but here is a script to make this a bit easier.

#!/bin/sh

# Uninstall Data Visualization for Desktop on Mac
echo "Killing Oracle Analytics for Desktop on Mac..."

pid=$(ps -fe | grep 'dvdesktop' | awk '{print $2 }')
if [[ -n $pid ]]; then
    sudo kill $pid
else
    echo "Does not exist"
fi

echo "All Done!"

I keep all of these scripts up to date here https://github.com/mmilella/DV-Scripts where you can just download the latest as I am sure this blog will get out of date.

By:

Posted in:


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.