How to set up a secondary database connection to hana with SLT default schema
We configured SLT through t-code "LTR", as tutorials shows, we had an schema like "DEFAULT_SCHEMA" in hana named from "LTR" configuration name.
Then how can we set up a secondary database connection from ECC by schema "DEFAULT_SCHEMA" through t-code "DBACOCKPIT". The only thing I know, is the dbco would only achieve the schema named the same as the user named in hana.
I'm not sure if I had describe the issue clearly with my poor English, but still hope you guys can help me to solve this.
Abhishek Singh replied
Steps to change password in HANA and replicate in DBCO.
1. Open HANA Studio.
2. Stop LTR.
3. Goto System User Schema -> Catalog -> Authorization -> User (Check whether User has been created). Set its password.
4. Right Click on System User Schema and click “Add Additional User”
5. It prompts for a password change once you enter username and password.
6. Change password in DBCO of SLT.
7. Restart LTR.