Integration with R_keeper 7 via PostgreSQL

StoreHouse 5 supports importing data from PostgreSQL.

Setting up Connection with R_keeper 7

Install and configure PostgreSQL before configuring import from r_keeper 7.

To integrate with StoreHouse 5, make additional settings in the PostgreSQL driver:

1. Download x32/86-bit ODBC driver from the official site

   

   Do not use the x64 bit ODBC driver.

2. Run odbcad32.exe

3. On the User DSN tab, click Add. In the window that opens, configure a new data source:
   
   

   1. Select PostgreSQL Unicode and click Finish
      
      

   2. In the connection settings window, specify:

      • Data Source — any name of the created source

      • Database — the name of the created database in PostqreSQL

      • Server — the IP address of the PosgreSQL server

      • User Name — the name of the created database user

      • SSL Mode — allow encryption, leave Allow

      • Port — the connection port

      • Password — the password of the database user.
        

   3. Click Test to test the created connection
      

   4. Click OK, then Save.

4. Go to the System DSN tab and repeat the steps from step 3

5. Set up connection between r_keeper 7 and PostgreSQL. Export data to SQL
6. Check that the settings are correct and the connection is established. After a successful import into the database, the GLOBALSHITS table should contain all closed shifts.
   
7. After that, go to the QushMan app. Create and configure connection with r_keeper 7.
   Select Postgres database as data source. Fill in the required parameters:
   
   Now data from r_keeper 7 will be uploaded to StoreHouse 5.
8. Make a primary import. Click Start on the Jobs tab.
   
9. In StoreHouse, go to Documents > Requests > Apply. You will see all imported orders.
   
10. The technical settings for communication with r_keeper are now complete. You can move to the detailed import settings.

How to configure integration between r_keeper 7 and StoreHouse 5