mO SharemO Share

Managing Web Database

Owned by Deepankana Roy (Unlicensed)
Last updated: Jul 11, 2022 by Subhasree Banerjee (Unlicensed)
2 min read


 Web Database Configuration

Web Database configuration is required to to have an automatic synchronization with the web database scheduled. This article describes how to configure and manage Web Database in Ginesys HO.

Prerequisites

  1. The users' role must have access to the Web Database feature by enabling Add app operation for the feature in Admin - Security - User - Role through Desktop POS Manager- Utilities - Configure.
  2. Microsoft SQL Server must be installed. 
  3. SQL Server Management Studio (SSMS) must be installed.

Step-by-step guide

The following steps are to be executed:

  1. Go to POS Manager - Utilities - Configure - Web Database.

  2. Web Database Migration module opens.

  3. Click on Add button.

  4. The Web Database Migration Detail window will open.
  5. Effective Date: Select the Effective Date from the provided calendar. Effective Date must be grater than the System Date.
  6. Host: In general terms, the 'host' term is usually attached to a powerful device or program that delivers services to some smaller and less capable device(s) or program(s). In this case, it is the system where the web database will be created or the web database already exists.
  7. Port: It is the IP or Web Address as provided by the company hosting web services for the user.
  8. User Name & Password: These are the credentials created by the user in time of installing SQL database and using which the system can log into the web location.
  9. Database: Provide here the name of the database to which it will be linking or the name of the database which you want to create.
  10. Click on the Create Database with Object.
  11. The new database connection will be established and one new database will be created the specified database name.
  12. After creating the database connection, you can test the connection by clicking on the Test Connection button. 



 Add Current Configuration File

Prerequisites

  1. The users' role must have access to the Web Database feature by enabling Create Current Configuration File app operation for the feature in Admin - Security - User - Role through POS Manager - Utilities - Configure.
  2. Web Database Configuration must be created.

Step-by-step guide

The following steps are to be executed:

  1. Go to POS Manager - Utilities - Configure - Web Database.

  2. Web Database Configuration module opens.

  3. Select a Web Database Configuration. 

  4. Go to Action and then click on Create Current Configure File option.

  5. Once done, "Configuration File generated Successfully" - message will be displayed.