Soon I will migrate the graphical data (shape and Oracle Spatial) to the ArcGIS feature class on SAP HANA (ArcGIS Pro 2.4). This test migration should be done with FME Desktop Workbenches and the productive migration from FME Server.
Question: In case of using FME Desktop Workbenches, must ArcGIS Pro software be installed on the computer or are there workarounds (copy DLL's,...)?
To clarify, while you cannot use ArcGIS Desktop(Map/Catalog) with FME to connect to your SAP Hana Geodatabase, it may be possible to use ArcGIS Server if you have that installed locally. We have not tested connecting to a Sap Hana Geodatabase with FME when only ArcGIS Server is accessible.
For FME Desktop, if you are working with any of the Esri Geodatabase formats requires ArcGIS software to be installed and licensed on the same machine as FME.
There are a few ways to enable Esri formats on a machine. This is outlined in this article, Notes on FME and Esri Version Compatibility - specifically the table under: "Esri Formats Supported by my FME Version"
As @erik_jan mentioned, one option is to use FME Desktop 64-bit and ArcGIS Desktop with Esri's ArcGIS for Desktop and 64 bit Background Geoprocessing. The other option for FME Desktop 64-bit is to have ArcGIS Pro installed on the same machine.
Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220944'. The error message from ArcObjects is: {This version of the Geodatabase client is incompatible with the dataset and cannot open it.}
Please ensure the connection parameters are correct (server=`<ipadress>', instance=`sde:hana$<ipadress>:<port>', user=`UT_USER', password=`***', database=`', version=`')
A fatal error has occurred. Check the logfile above for details
We successfully checked the connectivity to the HANA database with an ODBC test utility.
Should this type of access be possible, or do we definitely need ArcGIS Pro installed in order to access SDE geodatabase in SAP Hana ?
To clarify, while you cannot use ArcGIS Desktop(Map/Catalog) with FME to connect to your SAP Hana Geodatabase, it may be possible to use ArcGIS Server if you have that installed locally. We have not tested connecting to a Sap Hana Geodatabase with FME when only ArcGIS Server is accessible.
Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220944'. The error message from ArcObjects is: {This version of the Geodatabase client is incompatible with the dataset and cannot open it.}
Please ensure the connection parameters are correct (server=`<ipadress>', instance=`sde:hana$<ipadress>:<port>', user=`UT_USER', password=`***', database=`', version=`')
A fatal error has occurred. Check the logfile above for details
We successfully checked the connectivity to the HANA database with an ODBC test utility.
Should this type of access be possible, or do we definitely need ArcGIS Pro installed in order to access SDE geodatabase in SAP Hana ?
To clarify, while you cannot use ArcGIS Desktop(Map/Catalog) with FME to connect to your SAP Hana Geodatabase, it may be possible to use ArcGIS Server if you have that installed locally. We have not tested connecting to a Sap Hana Geodatabase with FME when only ArcGIS Server is accessible.
Thanks for the clarification and the very helpful link !
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.