ERP Scheduler: CFS Interface Setup

Understand all the pieces needed for CFS interface (Computerway, Chickway, Queue, R7). 

Pre-Requisites

1. Make sure you have login privileges to the SQL server and SQL. (Refer to the Client connection page for this information)

2. Make sure you know where ERP Scheduler is installed and configured (Refer to ERP Scheduler: Setup and Configuration)

3. Make sure Computerway has installed the Progress OpenEdge ODBC driver (Refer to ODBC Data Source Administrator)

Step-by-Step Guide

1. Check ODBC Data Source Administrator for Progress ODBC Driver 
   
   
   

   1. Use Windows Search to locate ODBC Data Sources
      
      

      Open

      

      
      
      
      

   2. Check Drivers tab for Progress OpenEdge Driver
      
      

      Open

      

      
      
      
      

   3. Check System DSN for Progress OpenEdge Driver
      
      

      
      
      
      

   4. Check System DSN Configure for Progress OpenEdge Driver
      
      

      
       

2. Check for QT ODBC  software we use to manually run ODBC SQL command on CFS interfaces database
   
   
   

   1. Locate QT ODBC Icon
      
      

      
      
      
      

   2. Select Data Source use Machine Data Source (value will match System DSN in ODBC Data Source Administrator)
      
      

      
      
      
      

   3. Logon to Progress database 

      1. Host must match Progress Driver Config

      2. Port must match Progress Driver Config

      3. Database must match Progress Driver Config

      4. User must match Progress Driver Config

      5. Password (value will vary by Client, refer to ERP ImportExportConnections table for password)
         
         

         
         
         
         

   4. QT ODBC Query Tool
      
      

      
      
      
      

   5. ODBC SQL commands are just like Mircosoft SQL with one exception, table name must be prefixed with PUB (see sample below)
      
      

      
      
      
      

3. ERP Database Connection for ComputerWay is in the ImportExportConnection table. Note DSN, Uid and Pwd will match settings in Progress Driver Config
   
   
   

   
   
   
   

4. Notes