The SAP HANA instance in question is very, very large and due to volume limitations, as well as the potential risk of performance degradation, it is not feasible to load everything.

When schema is set as “PUBLIC”, the loader does not return anything - fails as there is no corresponding schema in SAP HANA (it is only virtual space, not an explicit schema).no value entered), the loader loads everything, however in the “_SYS_BIC” schema, only synonyms are loaded and not the views. When schema is set as “_SYS_BIC”, the loader only loads the views from this particular schema, with no synonyms.On SAP HANA side, when running the loader, user can (optionally) define schema name(s) they wish to load, however: Loading problem analysis (using standard Alteryx loaders) This is because the object names are quite clearly different, and the loader doesn’t currently resolve the synonym to view translation (as per standard SAP HANA SQL parsing behaviour). Thus, the lineage is not established when the SAP HANA objects from schemas are loaded (containing the “/”, and at the same time, the Tableau dashboards linked to the synonyms (“::”). An example below, where first row is the view and the second row provides the related synonym: “GSTP_VALIDATION/CA_01_C_PDA_GRA_001”), however synonyms from the “PUBLIC” schema are loaded with a differentiator of “::” (e.g. These two are differentiated with a “/” when loaded from the “_SYS_BIC” schema (e.g. When loading the objects from SAP HANA, the object names contain the package name as well as the object name (view etc.). According to SAP, public synonyms are the official access interface for the system views. The synonyms are created for each view by default and always appear to be in the schema “PUBLIC”, however, this is not actually an explicit schema. In SAP Hana, there are two types of objects – views (which are present in relevant schemas, e.g. This specifically occurs when Tableau dashboards are pointed to HANA synonyms (“::”) as opposed to the views (“/”). Tableau & SAP HANA) in version 2019.2 are unable to detect the HANA object link due to a misaligned naming convention ( “:: ” vs “/”). Establish lineage/relationship between SAP HANA and Tableau (reports)īy default in Connect, we are unable to see data lineage between SAP HANA and Tableau.

Connect to hana from tableau on mac