SAP HANA Source System-Does it connect tenants on two different systems?

[sbelmore]

Can we connect tenants in two HANA systems using SAP HANA Source System? Is it the fastest way to connect the two tenants?

[dvankempen · Accepted solution]

Hi Steve,

You will need to elaborate a bit on your question.

Can we connect tenants in two HANA systems?

Yes, see

• Cross-Database Authorization in Tenant Databases | SAP HANA Tenant Databases, SAP HANA platform

It makes no difference whether the tenants are part of a single system or part of different systems (SID). You will need to explicitly enable access and direction. Note the section Things to Note About Remote Identities

using SAP HANA Source System

These are not official terms and hence require some explanation. Source system meaning there is replication configured? Using SLT? Data Services? Replication Server? Something else? How does this relate to the first part of the question?

[sbelmore · Accepted solution]

Good point, I should have identified SDA on HANA as the source. And in this case another HANA system on a different domain is the target.

[DotEiserman]

Hi Steve,

Yes you can do this, simply create two remote sources, one for each tenant you want to point to, the remote sources will have same hostname, but you can use the port to differentiate between the tenants. I hope I've understood your requirement. See my example below of two remote sources, each a tenant on the same host.

Thanks

Dot

[sbelmore]

I understand that SDA while created in a specific tenant, functions at the OS level. Is that correct? (An OS on a HANA appliance doesn't run completely Parallel SDA middleware?)

[DotEiserman]

Hi Steve,

As far as I know SDA is part of the core HANA application and there is no parallel SDA middleware. It does however use odbc drivers that are installed on the OS level for various DBs. Here is a nice architecture diagram for SDA/SDI:

https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS05/en-US/05a0c4823af94e238120b89...

Thanks

Dot