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.

Pre-requisites

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 Retail Management - 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 Retail Management - 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: This is where the system will create the web database or the web database already exists.
7. Port: It is an IP or a Web Address as provided by the company from which you have purchased the web location.
8. User Name & Password: This is the credentials created by the user in time of installing database and using which the system can log into the web location.
9. Database: Provide here the name if 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 as per the provided database name.
12. After creating the database connection, you can test the connection by clicking on the Test Connection button. 

Related articles

• Page:
  Adding, Editing & Extinct Coupons through Ginesys POS Management
• Page:
  Managing Web Database
• Page:
  How To: Manage Voucher Sale in Ginesys HO
• Page:
  How To: Allocate Gift Vouchers
• Page:
  How To: Generate Gift Vouchers