4.2. Installation Link database

Parts management is the connection of catalog data with your data in the ERP/PLM system. This enables role-based releases and views to be controlled and data from your database system can be made visible for the user in PARTsolutions.

General information on this can be found under Section 4.1, “Introduction”.

[Important]Important

An essential component of an installation with ERP, PDM and PLM integration is the link database, which stores links between PARTsolutions and third-party systems.

To set up a productive system, use an existing database system.[64]

This chapter "Installation Link database" guides you through the complete installation procedure step by step:

  • Hardware requirements

  • Installation of PARTsolutions parts management with PDM/ERP/PLM integration

  • Configuration of the database server connection (exemplified by MSSQL)

  • Create database scheme and users for ERP (exemplified by MSSQL)

  • ODBC driver

  • JDBC driver

  • ERP connection from PARTsolutions via ODBC/JDBC and ERP activation

For demo purposes, install the Sales Offline package. This installs an SQLite database with all the required configurations and demo data. You can skip this chapter "Installing the link database".




[64] MSSQL, Oracle, etc. Information on installing a database system is not included in this manual. SQL scripts can be found at $CADENAS\tools\databases.