In our current project,we are using smart data access to connect to Sybase IQ. I could connect to the remote IQ server from Hana Studio and create Virtual tables in Hana.But i am not able to consume them into my Hana Information models.. I Created a separate schema to accomodate 4 Virtual tables for IQ.
When i tried creating Calculation view, i could not see the above virtual tables in the selection list itself.
Can anyone guide me how to add these virtual tables to my views.?
We also checked if there are any additional privileges that are required to perform the above task.I could not find any.
I have sufficient privileges like ‘Create Remote Source’ and privileges to ‘create and drop virtual tables’.
So,we tried doing the above task from ‘System ‘ User to figure out whether if it is the issue related to Security.Even with this User,I am not able to consume these virtual tables into my models.
Can anyone help me on this?