Create multiple source systems in one Schema in SLT
By default, SLT lets you create a new schema for every source system connection. But if you are wondering how to connect multiple ECC source systems into one in SLT, you’re stuck because there isn’t much documentation on that. But how to do that?
Multi System Support
SAP let’s you create several different connection possibilities of creating a schema for SLT:
If you want to report over multiple source systems in one report you can solve that by using views across different schema’s, but that requires extra attention when you create a report. This is the reason why it is preferable to have one single schema in which there is only one uniform table, which gets it’s data replicated by from multiple source systems. Each table usually has LOGSYS field to filter records if necessary.
Add a System to a current Schema
If you want to add a source system to a schema, first make sure that system is not yet used a other schema. This sometimes requires you to delete a schema, when your SLT is setup like the top situation in the first picture.
To add the free source system to a current schema, go to your SLT system and logon. Then go to transaction LTR where you can see and maitain your schema’s. Click on “New” to start the wizard to create a new schema. But in stead of typing in a new schema name in the field “Configuration Name”, use the current schema name. In the “Description”-field you can type in any name as you like, but this also means that you may get confused because it will look like that it has two different schema’s. My advise therefore is to use the same description as the current schema.
Key in the Source System credentials and in the next screen of the wizard the Target System credentials. When this is complete, the system correctly identifies what you want to do effectively, that is to add a source system. In the pop-up select “yes” to add it to the current schema. Enter other specific wizard settings to complete the configuration.
This will then lead to one schema with multiple source systems within the SAP HANA studio. In this table data is replicated from both systems.
I hope this will be usefull for SCN members and adds to the existing SAP documentation.
SAP BI consultant for CGI.