![]() Now your are all set to use DBeaver with SAP HANA and – of course – SAP HANA Spatial in particular! Previewing a Spatial DatasetĪs an example, I am going to use Open Street Map POI (Point of Interest) data from Germany. Confirm this message with ‘OK’ and click ‘Finish’ to add your instance to the DBeaver Database Navigator. Simply confirm the automatically suggested download by clicking ‘Download’.Īfter the download you should receive a message that the connection has been established. Don’t worry! DBeaver will do the job for you. When you first use a connection to SAP HANA the respective driver needs to be download. HANA Cloud or HANA Platform), enter the connection details for your SAP HANA instance and click ‘Test Connection’: Select SAP HANA and click ‘Next’.Ĭhoose your respective database edition (i.e. Switch to the ‘All’ tab on the left side and enter “HANA” as a search keyword. ![]() So, now let’s configure the connection to your SAP HANA instance. You can also manually open this dialogue by clicking the plug sign on the upper left corner. When you open up DBeaver the first time, you will be presented with a dialogue to connect a new database. SAP HANA (Spatial) support comes out of the box and there is no need to install a separate plugin. If you downloaded and installed the latest version, you have everything you need. The easiest way to install DBeaver is to download and execute the ready-made binaries.Īlternatively you may also install the DBeaver plugin into your existing Eclipse installation, which I would only recommend if you have a good reason for doing this. ![]() Since DBeaver is actually an Eclipse plugin it runs on Windows, Mac and Linux (…and probably anywhere else where you manage to run Eclipse). Open Source GIS with SAP HANA Installing DBeaver ![]() If you do not have a SAP HANA instance at hand and would like to setup a free SAP HANA Express to load some spatial data, I recommend reviewing my previous blog post first: Yes, you caught me red-handed: I want to fool your mind and create positive associations! As an example we are going to do a DBSCAN clustering on a beer garden dataset. This article should give a quick overview of how to use DBeaver with SAP HANA Spatial to get some quick map visualizations of database objects without using a full-blown GIS client software. Since version 6.2.2 it offers support for SAP HANA and since version 6.3.1 the support of SAP HANA Spatial has been contributed. DBeaver is a free universal database client with excellent built-in spatial datatype support. SQL and GIS (database) developers may be familiar with an open source client tool called DBeaver. Furthermore, by leveraging the SAP HANA embedded machine learning capabilities developers are equipped with the ability to infuse spatial analytical models into their applications without the explicit need to actually visualize the geo-referenced input data.Įspecially for those scenarios, but also for the data preparation of complex visualizations, it is handy to have a tool to do quick intermediate visualizations in order to check partial results or quickly do a feasibility check of the data. SAP HANA Spatial offers in-database capabilities for handling and processing geospatial data. German areas with high Biergarten density? Spoiler: The result won’t surprise…
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |