Configuring the Database Interface Program (PSDB)
The PSDB Interface program PSDB.DLL is the interface program that Infor M3 SWB uses to transfer data from and to a database using ODBC.
This topic includes these main topics:
- How Data is Transferred Using ODBC
- Requirements for Using PSDB
- Variables in the Infor M3 SWB INI file
How Data is Transferred Using ODBC
The PSDB.DLL interface enables Infor 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 Infor M3 SWB.
Requirements for Using PSDB
These installations and configurations must be in place before PSDB will work:
- 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 Infor 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.