Dbeaver Sap Hana

Posted : admin | On 01-05-2021



  • Dark theme support was improved (Windows 10 and GTk)
  • Data viewer:
    • Copy As: format configuration editor was added
    • Extra configuration for filter dialog (performance)
    • Sort by column as fixed (for small fetch sizes)
    • Case-insensitive filters support was added
    • Plaintext view now support top/bottom dividers
    • Data editor was fixed (when column name conflicts with alias name)
    • Duplicate row(s) command was fixed for multiple selected rows
    • Edit sub-menu was returned to the context menu
    • Columns auto-size configuration was added
    • Dictionary viewer was fixed (for read-only connections)
    • Current/selected row highlighting support was added (configurable)
  • Metadata search now supports search in comments
  • GIS/Spatial:
    • Map position preserve after tiles change
    • Support of geometries with Z and M coordinates was added
    • Postgis: DDL for 3D geometry columns was fixed
    • Presto + MySQL geometry type support was added
    • BigQuery now supports spatial data viewer
    • Binary geo json support was improved
    • Geometry export was fixed (SRID parameter)
    • Tiles definition editor was fixed (multi-line definitions + formatting)
  • SQL editor:
    • Auto-completion for objects names with spaces inside was fixed
    • Database objects hyperlinks rendering was fixed
  • SQL Server: MFA (multi-factor authentication) support was added
  • PostgreSQL: array data types read was fixed
  • Oracle: indexes were added to table DDL
  • Vertica: LIMIT clause support was improved
  • Athena: extra AWS regions added to connection dialog
  • Sybase IQ: server version detection was improved
  • SAP ASE: user function loading was fixed
  • Informix: cross-database metadata read was fixed
  • We migrated to Eclipse 2021-03 platform

In my previous post Secure connection from HDBSQL to SAP HANA Cloud I worked with HDBSQL. Now let’s move to DBeaver CE — a free database manager that I have used in some previous posts already. Today it got the latest update 7.0.3, which I already installed on my machines.

SAP HANA Cloud…

… is the new cloud-native SAP HANA product, used in my previous post or in the recent live coding episode by Thomas Jung.

Two quick notes before we start:

  1. As of today, it is available only as a paid service in SAP Cloud Platform, but (usual disclaimer about forward-looking statement applies) the trial version should be available later this year.
  2. As a reminder, the IP address of a machine from which a DB client tries to connect to SAP HANA Cloud instance — should be whitelisted by your administrator.

DBeaver is a free and open source database tool and can be used with the SAP HANA JDBC driver. The following steps demonstrate how to configure it to connect to SAP HANA Cloud or SAP HANA, express edition using the JDBC driver. Download and install the community edition of DBeaver. Create a new SAP HANA database connection. Mathias Kemeter‘s Good Things Come Together: DBeaver, SAP HANA Spatial & Beer. A minute of weakness It was not just beer that excited me in his post, but Yes, I can confirm that Munich is the German destination for a beer. DBeaver is free and open source universal database tool for developers, database administrators, analysts and all people who need to work with databases. It supports all popular databases like MySQL, PostgreSQL, SQLite, DB2. You can find more information from here. Manage SAP HANA data with visual tools in DBeaver like the query browser. The CData JDBC Driver for SAP HANA implements JDBC standards that enable third-party tools to interoperate, from wizards in IDEs to business intelligence tools. This article shows how to connect to SAP HANA data with wizards in DBeaver and browse data in the DBeaver GUI. Tag: DBeaver for SAP HANA Cloud. How to connect SAP HANA Cloud from DBeaver.

Luckily, in my case, I am one of the admins of this SAP HANA Cloud instance. So, it is accessible from my IP addresses.

I need to grab the endpoint of my instance, which is:

2246ed61-81df-48e8-9711-323311f7613f.hana.prod-eu20.hanacloud.ondemand.com:443.

Back to DBeaver…

…where you can notice two great things:

  1. SAP HANA is already included in the list available drivers and
  2. HANA JDBC driver ngdbc is downloaded automatically when required or updated. If needed, you can still point to a driver you might have pre-install on your machine already.

Let’s create a new connection.

So, I need to put Host and Port accordingly to the endpoint copied from my HANA Cloud instance cockpit. This will automatically populate the JDBC URL. Plus populate Username and Password fields. Ok, let’s Test Connection….

“Receive of connect failed.“? Why? Of course, you know, if you read the previous post 😉

Clients can establish only secure connections to SAP HANA Cloud!

Let’s add this encrypt parameter to the connection. Unfortunately, this is where I found DBevaer UI somewhat unintuitive.

Switch to Driver properties and right-click on User Properties to add a new property.

Unfortunately, DBevar did not allow me to put encrypt=true just right here. Instead, I added encrypt property, and then (it took me half an hour to figure our) double-click next to my property in Value column to edit. Type true there.

Ok, let’s Test Connection now…

Bingo! Now I can connect and work with my instance.

Here’s another obvious disclaimer.

Never use admin user, like DBAdmin, to do your work!
Create separate users for admin or for development.

We are on MacOS… Have we missed anything?

Again, if you read the previous post, then you might remember that “DigiCert Global Root CA” root certificate was required to authenticate SAP HANA host to establish secure communication. And you might remember that on MacOS or Linix we had to explicitly use that certificate with HDBSQL.

What is different with DBeaver? It is a Java app and it is using the JDBC driver. The complete JRE is included in the DBeaver installation.

And by default JRE comes with the cacerts store of root certificates. Let’s check.

Don’t you trust yet?

Dbeaver

Personally, I certainly would like to double-check, if these assumptions are correct.

I have another Java installation on my Mac:

/usr/local/Cellar/openjdk/13.0.2+8_2/libexec/openjdk.jdk/Contents/Home

Dbeaver Sap Hana

so let’s check if it can be used to provide the trustStore property for our JDBC connection instead.

Dbeaver Sap Hana Portal

And what about Windows?

Dbeaver Sap Hana

Well, not much different. You use the default JRE installed with DBeaver…

…or you can use cacerts delivered in some other %JAVA_HOME%, like with SAP JVM in my case.

Looking for more information about JDBC?

There is a tutorial from https://people.sap.com/daniel.vanleeuwen available: Connect Using the SAP HANA JDBC Driver as a part of the tutorials mission Use Clients to Query an SAP HANA Database.

Sap Hana Interview Questions

Dbeaver sap hana download

Trust me, I am an engineer.
-Vitaliy (aka @Sygyzmundovych)