Not able to access Table created in SAP HANA Cloud with Datasphere Replication

[prasad]

Hi team,

We are following a scenario for replicating data from Datasphere to SAP HANA Cloud

Created a Replication scenario in Datasphere for a table "KNA1" . This table is visible in our  container schema after replication as below . There are other tables also created in this container schema through CAPM entity creation.

The below table has no name space attached as it is directly created from Replication

Created a hdb procedure in db/src folder of our CAPM project that access the tables from both CAPM created tables and table created with Data sphere Replication .

but while accessing the tables created through Replication we are getting an issue while deploying .

The file requires "db://KNA1" which is not provided by any file [8212001] (STDERR, APP/TASK/deploy)#

Other tables which are created with CAPM framework has no issue when accessed with procedures but only tables created with a Replication scenario of Datasphere in our schema has the issue.

Please let us know if we have missed any thing while accessing these tables.

Regards

Prasad

[martinstenzig]

I would suggest the other way that I successfully used before. Create a CAP app and the associated table structure. 

You then have two options: 

1. Use the standard HANA to HANA connection to access your tables from Datasphere (the easier way)

2. Add the Datasphere database to your sub account (as described in the Datasphere documentation) and then you can redirect your HANA deployment to the Datasphere HANA database and easily, natively use the CAP tables in Datasphere.