Hey Dinesh, Does the database need to be in the cloud? I assume you're doing it that way to make some SAP data publicly accessible, but if this is just an internal thing then I'd simply move the database on-premise as well.
If you are doing it to expose some SAP data publicly, or otherwise offer an interface for customers to access, add, update, etc. data that comes from/goes into SAP then I'd break the app up into two pieces: 1. The public facing MVC site with all the HTML, etc. needed for customers to engage with the data, and a REST API for data transfer 2. The private (on-premise) app that connects to SAP and the REST API of your public app for data transfer - you'll still have to use an HTTP proxy client in your code for making the connections, but they'd be all HTTP calls instead of trying to talk to the database port directly - which should be easier to do (and there are a plethora of HTTP proxy modules available for Node, including the one I'd already linked). Having said that... let us circle back to the firewall for a second. If you are unable to make any TCP calls to the database from inside the premise, then there has to be a firewall somewhere on-premise preventing that network traffic. While a proxy might be used to allow HTTP calls out through the firewall, there still has to be a firewall involved to block all TCP traffic (proxies don't do that by themselves). So, I once again repeat my first notion that you should speak with your IT team and ask them to add a rule to allow your specific on-premise server to make TCP calls out to your specific cloud server and port. HTH! Denny -- Job board: http://jobs.nodejs.org/ New group rules: https://gist.github.com/othiym23/9886289#file-moderation-policy-md Old group rules: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines --- You received this message because you are subscribed to the Google Groups "nodejs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/nodejs/671c53e4-c731-442b-8c2d-90bb5497d279%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
