WEBDEV Concepts

182 Part 5: Databases Retrieving data from a site A commercial site allows end users to place orders, make reservations and more, ... Several methods can be used to retrieve this information. Tip: Process the retrieved data in a "Back Office" application developed with WINDEV . 1 Sharing data The data of a WEBDEV site can be directly shared with the data found in the Back Office application used to process the operations performed on the site. Simply use an HFSQL Client/ Server database. Here is how it works: Web Server WEBDEV site Data server - HFSQL Client/Server database - 3 access accounts: o Internet Guest o Administrator o Back Office Company headquarters Back Office application Access to data Access to data Benefit : The site data is accessible in real time. Drawback : Need to manage security in an optimal way: use a secured connection to access data, open a specific port to access data (port 4900 by default), configure the firewall, etc. This solution is recommended for a site installed on a dedicated server .