I'm fairly new to HANA's SDI functionality. Essentially I am trying to create a flow graph that will copy data from a virtual table to a physical table. I can set my data source as the virtual table, however when I try to set the physical table as my target, nothing appears. I am essentially doing this from within a HDI Container while the physical table is sitting in a tenant DB.
Same server and schema though.
Any help appreciated, thanks in advance.
To access tables that are not part of the HDI container from within an HDI container it's necessary to create synonyms to those tables.
There is what feels like a metric ton of documentation and tutorials available on just this point.
Examples:
Once the synonym to the target table is correctly set up for your HDI container, you should be able to "see" it in SDI.
Be aware that the account that is used for the synonym definition needs to be able to write to the target table, otherwise your data loading won't work.