Configuring the Database Interface Program (PSDB)

The PSDB Interface program (PSDB.DLL) is the interface program that M3 SWB uses to transfer data from and to a database using ODBC.

Transferring data using ODBC

The PSDB.DLL interface enables M3 SWB to access data from tables in the customers MRP system through ODBC. The PSDB.DLL uses a parameter file to determine the information to be transferred to and from M3 SWB.

Requirements for using PSDB

These installations and configurations must be in place before PSDB works:
  • Install the ODBC Driver Manager, minimum version 3.0.
  • Install an ODBC driver for the selected database.
  • Define an ODBC DSN (Data Source Name) that uses the ODBC driver that is specified above.

Variables in the APP INI file

These variables defined in the M3 SWB INI file are used by the PSDB.DLL:
  • PMSIMDB_PARAMSQL

    This variable states the name (including full path) of the parameter file.

  • PSDB_INIPATH

    This variable states where the PSDB.INI file resides. Only state the directory name here.

  • PSDB_LOGPATH

    This variable states where the PSDB log file resides. Only state the directory name here.