SAP HANA HDI Cross Container Access (Multiple MTA)

[sandeepmalhotra]

Hello Everyone,

I am having two standalone MTA projects in same org and space in Cloud Foundry

1. A HANA Native app for replicating the tables in HANA cloud via SDI in HDI Container named as replication-container. This project is not having any db folder. In this project few tables such as LFA1,KNA1 from ECC is replicated via replication task. All tables got successfully created in HANA container like TARGET_LFA1.

2. A CAP Project named as project-container having its own db and srv folder. In this project I need to use the tables created in replication-container

I am having below mentioned queries

In the first project , Do I need to create roles with object privilege for external access.

IF yes, How I can create a valid hdbrole file as I don’t have any explicit db folder .

HDB Role File having errors

If db folder is mandatory what I need to add in it ? As all my tables are created successfully via replication tasks

Thanks

Sandeep

[Cocquerel · Accepted solution]

As you are using wildcard for the name of the tables in the hdbrole, you should add "pattern_mode" property like in this example:

{
    "role": {
        "name": "RO_Business_User",
        "object_privileges": [{
            "name": "Share%",
            "type": "VIEW",
            "privileges": ["SELECT"],
            "pattern_mode": "include"
        }]
    }
}

[sandeepmalhotra · Accepted solution]

Thanks , I missed the pattern_mode