"Automated" Schema Mapping

[Former Member]

Dear experts,

whilst I quickly managed to map a schema manually I couldn't figure out a way to do it automatically.

The scenario is the following:

- We create quite a number of Hana systems fully automated where we have the ERP data in a different schema than SAP_ECC.

- We’d like to use SAP HANA Live functionality which requires the ERP data in SAP_ECC or alternatively an active schema mapping.

If anyone can provide a way to either conduct the schema mapping via sql statement or alternatively integrate the schema mapping in a delivery unit I'd be very thankful.

Looking forward to your answers,

Tobias

[RashmiAcharya · Accepted solution]

Hi Tobias,

You can use below sql statement for creating schema mapping,

insert into "_SYS_BI"."M_SCHEMA_MAPPING" values('AUTH_SCHEMA_NAME','PHYSICAL_SCHEMA_NAME')

Regards,

Rashmi

[Former Member · Accepted solution]

Hi Rashmi,

sometimes live can be that easy 🙂

Many thanks for the fast and to the point feedback!

Regards,

Tobias