Is This Content Helpful?
We're glad to know this article was helpful.
SAP HANA Studio allows shapefiles to be imported into a SAP HANA database. After importing a shapefile, the spatial table may throw an "Insufficient privilege" error when drawing the shapefile in ArcGIS or viewing the properties of the feature class.
The SAP HANA Studio Import tool surrounds lowercase or sentence case names with double quotes (ex: “railways”). Because ArcGIS accesses names in uppercase without quotes, this causes a Table not found/No permission error. This error can be fixed by renaming the columns and table names to all uppercase letters. Geoprocessing tools (such as Feature Class To Feature Class) convert the fields to uppercase automatically.
Before selecting a shapefile to import, ensure the name of the tables and columns are in capital letters in the geoprocessing tool.
Note: This was tested and confirmed with SAP HANA version 1.00.122.04.1478575636.