5 easy steps to run Oracle applications on dashDB

Share this post:

Looking to the cloud for your data warehouse needs but want to continue leveraging your existing Oracle application or SQL skills? dashDB is your answer.

Built on IBM’s BLU in-memory technology coupled with Netezza’s in-database analytics, dashDB is a fully-managed cloud-based data warehouse service. With its built-in SQL compatibility features, you’ll get your application running on dashDB in these 5 easy steps.

Step 1: Request dashDB be provisioned with the Oracle compatibility option

Provisioning with Oracle compatibility ensures dashDB has all the native SQL compatibility extensions required for a smooth transition. SQL extensions range from additional SQL dialect support for things like outer join (+) syntax to supporting the additional data types of VARCHAR2 and NUMBER. It also provides support for running PL/SQL procedures and functions natively. dashDB comes with the most commonly used subset of Oracle’s scalar functions and package library extensions.

SQL Dialect Data Types, Scalar Functions, SQL syntax
PL/SQL Native PL/SQL procedures, functions, anonymous blocks
PL/SQL Packages Named collection of functions, procedures, types and variables
Built-in Packages Common PL/SQL packages provide by default
Application Enablement OCI, Pro*C, SQL*Plus scripts, JDBC extensions
And more … See IBM Knowledge Centrer: dashDB Compatibility Features

Step 2: Download the Database Conversion Workbench

The Database Conversion Workbench (DCW) tool supports your conversion to dashDB. DCW is extremely useful in this process, providing an upfront evaluation report indicating your application’s specific level of compatibility with dashDB, and providing assistance in converting differences.

Locate the DCW tool within the dashDB console under “Connect > Download Tools > Database conversion software”:

Step 3: Evaluate your application

After installing the DCW tool, review the Oracle to IBM dashDB Conversion Guide to walk you through the steps of creating a project, extracting the relevant DDL and importing your SQL for evaluation.

Having evaluated your application, review the compatibility report. The report will show you the overall compatibility level achieved as well as the break down by object and statement type and a detailed report on the individual statements requiring conversion.

Step 4: Run DCW’s conversion process

Next up is the conversion process. Any incompatibilities flagged as warnings during the evaluation phase are converted by this process to be compatible with dashDB. Changes applied to the original SQL are also flagged with appropriate inline comments describing the changes.

Step 5: Execute your converted DDL on dashDB

After completing the evaluation and conversion in DCW, switch back to the dashDB console as you are now ready to execute your converted SQL. On the dashDB console, simply choose “Run SQL”.

Select “Open” to browse for your converted SQL. Don’t forget to change the statement terminator to the @ symbol that DCW uses in the converted SQL. Then choose “Run” and review the status report.

Move your Oracle applications to the cloud!

With these five steps, you’re now ready to run your application on dashDB. With native built-in SQL compatibility and easy-to-use Database Conversion Workbench tooling, dashDB simplifies moving existing Oracle applications to the cloud. The fully managed nature of dashDB then allows you to spend your time focusing on the analytics it produces.

More stories
May 1, 2019

Two Tutorials: Plan, Create, and Update Deployment Environments with Terraform

Multiple environments are pretty common in a project when building a solution. They support the different phases of the development cycle and the slight differences between the environments, like capacity, networking, credentials, and log verbosity. These two tutorials will show you how to manage the environments with Terraform.

Continue reading

April 29, 2019

Transforming Customer Experiences with AI Services (Part 1)

This is an experience from a recent customer engagement on transcribing customer conversations using IBM Watson AI services.

Continue reading

April 26, 2019

Analyze Logs and Monitor the Health of a Kubernetes Application with LogDNA and Sysdig

This post is an excerpt from a tutorial that shows how the IBM Log Analysis with LogDNA service can be used to configure and access logs of a Kubernetes application that is deployed on IBM Cloud.

Continue reading