Remove remote source configuration after refresh of HANA

[linda_westerhold]

We have a BW on HANA environment that has a remote source connector configured from SAP HANA to SybaseIQ in both Production and non prod environments. After we take a backup from production and restore into QA, the production remote source connector comes with the refresh. When we try to delete the remote connector in QA that points to production, we get a message saying "The source and all depending virtual tables will be deleted. Please confirm."

We do NOT want to delete any production tables and only want to have the virtual tables connect to QA SybaseIQ (which we also configured a remote source connector from the QA SAP HANA to the QA SybaseIQ.) Now we have two remote source connectors configured. One pointing to prod and one to qa.

1. How can we drop the production remote connector without impacting production?

2. How can we alter the tables copied to QA to look to the QA owned schema as well since after a copy from prod, all are owned by prod user?

[VivekSahu]

Hi linda.westerhold,

You can try below command with a user having 'DROP' privileges on Remote Source :

 DROP REMOTE SOURCE <remote_source_name>;

Some additional options are:

• CASCADE drops the remote source and dependent objects.
• RESTRICT drops the remote source only when dependent objects do not exist. If this drop option is used and a dependent object exists, then an error is thrown.

Best Regards,
Vivek Sahu

[AtulKumarJain]

Hi Linda,

I think ,it can help you.

https://help.sap.com/viewer/6a504812672d48ba865f4f4b268a881e/Cloud/en-US/f523d7ab9d134a41b3bda1a603e...

2542963 - Is it possible to rename a Remote Source in SAP HANA?

2541433 - Can you change a remote source name - SAP HANA smart data integration

Best Regards,

Atul