Hi
@Krishna Bejawada,
as Susan wrote early in her post we support to manage XY table with the use of the JDBC driver accessing to SAP Hana.
If you can use XY Table is fine to use JDBC Connection set up in Spatial Manager (Create Connection).
If you're facing issues to set up or to run it, please send details to our technical support -
software.support@pb.comIn case you need to support SAP HANA spatial data you need to develop a custom data provider.
There is guidance and code sample in Spectrum – prerequisities are to have Java development skills. Goto the home page of Spectrum, click on Spectrum Spatial (on the left panel tabs) and click on the tab named "Sample application" and the "Extensible DataProvider Bundle.
kind regards
Monica
------------------------------
Monica Di Martino
EMEA LI/GIS Presales Engineer
Pitney Bowes
------------------------------
Original Message:
Sent: 10-25-2019 10:33
From: Krishna Bejawada
Subject: SAP HANA Connection with Spectrum Spatial Manager
Hi Susan,
Thanks for the response. I made sure I followed all steps mentioned in the document.
I am able to make SAP HANA Connection in the spectrum Management console. But strangely, I am not able to make the connection to Spectrum Spatial Manager. All it says is that the driver not found.
I have copied the same driver in "/<spectrum root="">server/modules/spatial/lib and /<spectrum root="">server/app/lib ". Restarted service, Machine and checked. But the issue is still the same.
I hope someone who has already made the connection would guide us :)
Best Regards,
Krishna. </spectrum></spectrum>
Original Message:
Sent: 10-23-2019 06:34
From: Susan Bardet
Subject: SAP HANA Connection with Spectrum Spatial Manager
Hello Krishna,
I apologise, my response to you earlier was wrong. SAP Hana can be accessed through JDBC Driver, you would need to add JDBC driver jar and then create XY table through Spatial Manager. Please read the file I have attached.
I apologise for any confusion.
Best regards
------------------------------
Susan Bardet
Software & Data support EMEA
susan.bardet@pb.com
Pitney Bowes
Henley-on-Thames
RG9 6AB Oxfordshire
United Kingdom
pitneybowes.com
Original Message:
Sent: 10-22-2019 20:10
From: Krishna Bejawada
Subject: SAP HANA Connection with Spectrum Spatial Manager
Hello Community,
I am trying to make a connection between SAP HANA default Database ( SYSTSEMDB) and spatial Manager. I am facing a driver issue which is not letting me connect to HANA Directly.
If someone already made this kind of connections, pls advise the best practice to connect and analyze data in SAP HANA.
It will be great if someone can through light on
1. Uploading Point data ( Lat,Long) into SAP HANA DB - SYSTEM DB/ New DB
2. Connecting the same X,Y tables into Spatial Manager.
3. Right kind of driver. I tried (https://download.jar-download.com/cache_jars/com.sap.cloud.db.jdbc/ngdbc/2.4.63/jar_files.zip) this but Spectrum is not able to read the driver.
Looking forward to the support.
Cheers