Correct, the data has to be current that the user will be accessing. The user will actually use an internal SAP application first. Then they’ll go to my application to continue. Replication can ensure that the data is current, but that’s not what they want to do unfortunately.
Once the user enters my application, they’ll enter a reference number that they got from the SAP application. Based on that reference number, my app needs to pull relevant information from the SAP database.
With regards to the IP address used for my calls, I’m not sure what it represents since it’s not my domain’s unique IP address. I have shared hosting at Dreamhost. I looked at info for VPS and dedicated hosting, but there was no indication that different hosting would solve my issue.
I’m not sure how an API would help in this case since the data resides on the company’s network. If the API also lives on the company’s network, I still have the firewall issue. If the API lives outside the company’s network, that solves the problem for my application but then the API has the issue with the firewall.
If the weather data you’re getting doesn’t use authentication, then this is not a relevant example. If it is using IP authentication, then it is a very relevant example and I’ve love to know what application you’re referring to.
Feel free to keeping tossing out thoughts as I’ve come up empty!