SAP LT Replication server – Allow Multiple Usage (Option impact for Replication configuration)
With this blog I would like to share the learning which i had when i wanted to use the same source system for replication from different clients using the same controller SLT system.
SLT Replication Server Version details:
SLT NW 731 SP5 – DMIS 2011_731 SP5 on Oracle Database
HANA Revision: 74.04
SAP LT Replication server – Allow Multiple Usage
In certain cases where any single client replication from a source system is not enough and we want to use the same source system again for the replication but this time from a different client.
For any SLT system we can use the same source systems 4 times, only if the reuse of the system is marked as true.
For making multiple source system connections using the same source system we have to make sure that the option “Allow Multiple Usage” option is checked during the first SLT replication configuration.
If the option “Allow Multiple Usage” is not selected for a particular source system the only option available in that case would be to delete the configuration and create a new one with this check “Allow Multiple Usage” as true. For new configuration we don’t need to create a new schema in HANA we can use the same schema for replication.
Please Note: Checking the option “Allow Multiple Usage” doesn’t have any impact even if the source system is not configured again for replication. Thus it is always a best practice to check the option “Allow Multiple Usage”.
Please do let me know your feedback on same or let me know in case of any questions and concern.
Thanks and Regards,
Hi Amar Ghuge ,
Nice to see your blog's ,
Can you update some SLT administration and monitoring practical documents which will be very help full for all who are in learning stage like me .
Sure i will share the details on same.
I totally agree with you on this.
I always recommend 'Allow Multiple Usage' option to be checked when creating SLT configurations based on my personal experience. I had to do lot of workaround to use 1:N replication as that option was not set first time.
Thanks for the update, and yes, I fully agree with you!
But, do you know how to create a configuration with the same name again if we had to delete and re-create?
I.e. in our case we have a lot of views and stored procedures and external access and therefore we are not able to re-create with a new configuration name (and hence SCHEMA name in HANA).