Skip to Content

Remove remote source configuration after refresh of HANA

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 14, 2020 at 09:15 PM

    Hi Linda,

    I think ,it can help you.

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

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 15, 2020 at 03:15 AM

    Hi Linda,

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.