Technical Exasol

How to use DbVisualizer with Oracle, PostgreSQL and Exasol

09 Jul 2019 | Share

DbVisualizer with Oracle, PostgreSQL and Exasol

As a database developer or administrator, it’s unlikely that you’ll work with only one platform.

It’s quite useful to have one single tool to handle multiple different database platforms –that’s the ambition of DbVisualizer.

Let’s assume you’re a database administrator who works on a migration project moving from Oracle to EDB Postgres and Exasol.

The goal might be to replace the corporate Oracle database landscape, moving the online transaction processing (OLTP) part to EDB Postgres and the data warehousing (DWH)/analytics part to Exasol.

Instead of having to switch constantly between, say, SQL Developer, psql and EXAplus, it would be more efficient to use DbVisualizer for all three.

I created one connection for each of the three databases for this demo:

 

DbVisualizer

Now let’s see if the Oracle statements also work in EDB Postgres and Exasol:

Oracle

Oracle

EDB

EDB

Exasol

Exasol

And they do – for all three. The convenient thing is that you only need to select the database connection from the drop-down while leaving the statement unchanged. No need to copy and paste even.

But what about schemas and tables?

Oracle

Oracle

In EDB, you therefore need to create a schema:

In Exasol, the schema and table can be created in the same way:

Exasol

Exasol

Note that the data types got silently translated into the proper Exasol versions:

Exasol

Exasol

There’s no DBA_TABLES in Exasol, though:

Exasol

Exasol

Of course, there’s much more to check and test during a migration, but this gives you an idea how a universal SQL client like DbVisualizer might help your project.

10 trends impacting data analytics

Now that we’re well and truly in the age of data, what’s coming next? 

Free

Whitepaper