Use multiple data sources in FIORI App in Business Application Studio

[RahulL]

Hi Experts;

We performed below actions in Business Application Studio:

1.- We create a Basic freestyle FIORI App from a template, selecting a Data source as Use a Local CAP Project.

2.- The FIORI App works as expected when the service is exposed from backend node.js 

3.- Now, in the same FIORI App we want to post data to on premise SAP system, the connections are successful in the same subaccount cloud connector and destination. We added the required service from the service center of BAS it generated cds and js files of the entity in srv folder but when we try to hit the service we are facing the 502 error: Failed to load destination error. 

4.- Other Alternative tried is adding the service in manifest.json file but the metadata is failing saying error code 404: Service Not found.

we tried creating a new project from the service center instead of adding to existing CAP Project the new project created is working fine all the metadata is loading and the data is fetched from the on premise system.

Now we are trying to access multiple data sources one from the local CAP Project and another service from destination in BTP Cockpit

Any guidance, in general, is welcome.

Thanks in advance.

Rahul L.