We work with a company that wants to host some of our listings on their website, but we use a database and they don't have a "dedicated IP" like we do, so I can't just put their IP in the "safe" list...
Is there some way to allow them read-access to our database?
In general, you want to avoid allowing database connections from any IP address. Build a simple web service or page to relay the needed records in a JSON, XML, or CSV format, over SSL, if desired, and contingent on some agreed upon access key (or "password").
There is a third option:
If your network admin familiar with VPN you can allow them authorized access to your database via VPN connection.
And yet you will need specific user with read only access.
Because even over super secure connection you do not want anyone connect to your database server and mess with unintended data.
But if they need just to read data to show on their site why not give them something like JavaScript widget hosted on your site to display your data?
Or that can be achieved by web service to throw all data in XML format at authorized request...
There is a third option:
If your network admin familiar with VPN you can allow them authorized access to your database via VPN connection.
And yet you will need specific user with read only access.
Because even over super secure connection you do not want anyone connect to your database server and mess with unintended data.
Unless you're a developer telecommuting from home over VPN. (Okay, excuse me while I get back to work... )
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
Read-access for public or for dynamic IP?
Reply With Quote
Originally Posted by alexsts
)
, VPN access is for developers not for displaying your content on someone site.
Bookmarks