HANA On-Prem to HANA Cloud Datalake without HANA Cloud DB

[KarthikKumar31]

We are attempting to import a table from our HANA On-Premise database to HANA Datalake. We have successfully created a Remote Server and can view the tables of the HANA On-Premise database in HANA Datalake using the query CALL sp_remote_tables('remote_server_name'). We can also retrieve the columns of a specific table of HANA On-Premise using the query CALL sp_remote_columns (''). However, we are unable to fetch the table data. Our goal is to create a virtual table in HANA Datalake and directly import the table data from HANA On-Premise, without using HANA Cloud DB as an intermediary. Could someone please assist us in achieving this?"

[JasonHinsperger]

What message/error do you get when you try to create the remote table?

[RobertWaywell · Accepted solution]

You mentioned that you have created the REMOTE SERVER connection, but I don't see any mention of creating the virtual table definition. 

Have you executed a CREATE EXISTING TABLE statement and did it succeed? 

Assuming that you have successfully executed the CREATE EXISTING TABLE statement, can you also provide the SELECT statement that you are using to retrieve data from the virtual table? 

[KarthikKumar31 · Accepted solution]

Thank you very much for the help. The CREATE EXISTING TABLE statement resolved the issue.