I have a scenario, where I want to use tables from on premise in my application deployed in SAP BTP and it uses HDI container. For now I have made the connection using Cloud Connector between BTP and on-premise, later using Remote Source adapter I am creating the virtual tables inside an schema. Then, using Synonym concept I am consuming these Virtual Table in the application.
Instead Can I create the Virtual Table directly inside the HDI container(by giving the required privilege's of HDI container to DB-admin) and use it directly.
Request clarification before answering.
Hi varun_bhargav18
Actually way is to go through SDI (Smart Data Integration) using DP Agent to access the on-prem database and create VT
Follow this link which will help for your question.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 5 | |
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.