Accessing a web page but storing data locally

Hi Everyone

I hope you can help.

We have a requirement to retrieve web pages from a central source such as a .com or .co.uk domain. The problem we have is that the data which would populate the webpage/form needs to be retrieve locally perhaps within a database such as SQL Server.

The data CANNOT be stored centrally online due to data protection.

Technology/Platform not a real issue at this point.

Example
Office has an internal network with an SQL Server/local database. User would access a website where a webpage containing a form would be retrieved and data would be retrieved from the internal SQL Server/local database and integrated and then displayed via a web browser.

Is this possible?

Many thanks in advance.

BB

 

Thank you for your reply.

My initial idea:

We would need to sub-class Internet Explorer so that can control the document layer. We would retrieve a web page from the .com/co.uk website securely.

We would using perhaps the Web Browser component, access the individual fields within the web page and populate these with data that has been retrieved locally from the resident SQL Server.

This approach would require a .NET app to be installed which would both retrieve the web page and then retrieve the data and then integrate both before displaying to the browser window.

Would this be possible?

 

Thank you for the reply once again.

I agree. The problem we have is the customer wishes to centralise the interface, the input forms etc. This would help with updates and support. There are potentially 1000's of users.

I guess it can only be either an online solution (website) or an application solution (installed on a workstation).

Any other ideas?

Many thanks once again.

BB