Chapter 5. Strategic Parts Management
5.2. Installation Link database
Prev  Next

5.2. Installation Link database

5.2.1. Hardware requirements
5.2.2. ENTERPRISE 3Dfindit Setup
5.2.3. Configuration of the database server connection (exemplified by MSSQL)
5.2.4. Create database scheme and users for ERP (exemplified by MSSQL)
5.2.4.1. Installation scripts
5.2.4.2. Explanation on the database tables
5.2.4.2.1. LOCKTABLE
5.2.5. Set up ODBC data source
5.2.6. JDBC driver
5.2.7. ERP connection from ENTERPRISE 3Dfindit via ODBC/JDBC and ERP activation
5.2.7.1. plinkcommon.cfg ➝ Block [Common] ➝ Key "DBName" - Database connection
5.2.7.2. plinkcommon.cfg -> Block [PARTdataManager] -> Keys "ERPenabled" and "ERPenabledPPrj" - Activate ERP
5.2.7.3. Configuration database login

Parts management is the linking of catalog data with your data in the ERP/PLM system. This allows role-based approvals and views to be controlled and data from your systems to be displayed in ENTERPRISE 3Dfindit for the user.

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

[Important]Important

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

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

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

  • Hardware requirements

  • Installation of ENTERPRISE 3Dfindit 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 ENTERPRISE 3Dfindit 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".


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

Prev Up Next
5.1.7.2. PARTsolutions/base module ERP Home 5.2.1. Hardware requirements