AnsweredAssumed Answered

SAP HANA schema visibility (strange chars)

Question asked by dmorosiesriitalia-it-esridist Employee on Jul 21, 2017

Hi everyone,

I'm trying to visualize in the Catalog of ArcMap some tables hosted by a SAP HANA instance. The full name (schema + table name) of the tables is something like this:

 

SCHEMA_NAME.TableName

 

or

 

SCHEMA_NAME::DM.TableName

 

I'm not an expert in HANA but the people working on it are saying that the ::DM part of the schema is a suffix for Data Model. However, the first kind of schema.table is showed correctly in the Catalog, while the one with the ::DM part isn't viewable.

By the way, if I create a Query Layer by adding it directly (File -> Add Data -> Add Query Layer) and I write something like "select * from SCHEMA_NAME::DM.TableName" it works, so it only seems a problem of visibility in the Catalog.

Have you ever experienced something like this? I'm using ArcGIS 10.3.1 and the version of the SAP HANA ODBC driver is 1.00.120.042.1474657934

 

Thanks

Outcomes