One of our clients want to use AWS for the SAP DS server. But they want to maintain the client software on premise. We need to access to on premise data using client on on premise and server on cloud to load into either on premise database system or cloud database system.
How can on premise client communicates with cloud server and extract the data from the on premise systems.
There is not a simple answer to this. I have had engagements where our whole job was to figure this out and implement it for the client. Basically, you need to configure your proxies or whatever other network methodology you choose to allow the communications over the correct ports for the different servers to see each other.
As Ernie said in the above post, setting up the network ports and security could be your biggest issue.
A second issue is that Data Services Designer does not perform well over a WAN for development. You can minimize the pain somewhat by keeping your production repositories in the cloud database and your developer repositories in a local database.
Running Designer through Remote Desktop works OK and eliminates the WAN lag.