4.1.7. Modules
4.1.7.1. PARTsolutions/base module ERP linkdb
Prev  Next

4.1.7.1. PARTsolutions/base module ERP linkdb

This module enables the integration of company-owned META data into the PARTsolutions software.

You can connect attributes from the META data, such as for example internal article numbers, price, material, part status, etc., with the installed standard attributes of the PARTsolutions supplier catalogs.

The module covers the following functionalities:

  • PARTlinkManager - Tool for the administration of all ERP-relevant data.

    • Display and changes of datasets in the LinkDB (in the LinkDB you can find all information about the connection concerning part allocation to ERP master data)

    • Configuration of PARTsolutions ERP environment

    • Adjustment of visual display of data in the PARTsolutions environment (example: different coloring for individual rows according to condition)

    • New application of DB fields in the LinkDB

    • Dataset export and import via CSV file

  • PARTadmin - Configuration tool for PARTsolutions and administration tool for roles and users.

    • Roles and users may be applied.

    • For roles and individual users, comprehensive view filters (preferred rows, hiding certain parts and columns, etc.) may be set.

    • Roles and individual users rights (export restrictions, apply new rows, request part numbers, etc.) may be assigned.

    • System settings for PARTsolutions can be made.

  • PARTsolutions Toolbar [63]

    • New toolbar in the PARTdataManager

    • New columns with ERP information in the characteristic attribute table

    • New processes are possible, e.g. when applying ERP-numbers

  • Database scripts - Predefined scripts for creating the LinkDB, which can be used with PARTsolutions.

    • Currently available for Oracle, MS SQL, DB/2 and SAP DB

  • ERPsolutions/gateway JDBC - Gateway for accessing databases via Java DataBase Connectivity

    • JDBC is a Java based version of the database access (to LinkDB).

    • The package does not include the JDBC drivers for the corresponding databases. They have to be provided by the customer.

    • As far as free drivers are available, JDBC-drivers (free of cost), which are available under the LGPL-license are additionally enclosed in the package, they are not supported by CADENAS and no guaranteed content of the scope of delivery.

    • For installation and implementation to ERP environments an individually arranged consulting package is urgently recommended.

  • PARTsolutions/development partwarehouse ident mapping&synchronize

    • Includes command line tool to transfer attributes from the ERP system (e.g.) for ERP/PLM integration) assimilation of company specific part data (part numbers and attributes) from one database and transfer to PARTsolutions tables

    • Includes PARTdataCenter GUI for ident number matching: interface for semi-automatic assignment of ERP numbers

      [Note]Note

      • The software package PARTsolutions/development partwarehouse ident mapping&synchronize is recommended for all ERPsolutions modules.

      • For installation and implementation to ERP-environments an individually arranged consulting package is urgently recommended.

[Note]Note

  • Licences

    With the COMP license type, operation is also possible across locations in one country; with the Enterprise license type, operation is possible across locations worldwide.

    For the Enterprise license, all subsidiaries that use the software must be specified. (ATTENTION: Only applies to one ERP system, please enquire for heterogeneous ERP landscapes). A replication manager is required to replicate the database at different locations. This replication manager is provided by the customer. There are no restrictions regarding the number of columns that can be displayed.

  • For installation and implementation to ERP environments an individually arranged consulting package is urgently recommended.

  • The customer has to provide sufficient database licenses (with SQL Basis compatibility e.g. Oracle, SAP DB, DB/2, etc.). In case the customer does not have a database system, we recommend installing a free Oracle-XE or SQL-server Express version. However, they are not administered by CADENAS (backup, user management, firewall-settings, etc.). Generally CADENAS does not accept any liability for functionality and licensing of the database systems.

  • The customer has to ensure that there is a ODBC-connection, regarding software and license, to the indicated database system. For the free SAP DB, the ODBC drivers are additionally delivered under the GNU license.

There are several implementation options for the data flow from the ERP system to the PARTsolutions database (so-called coupling types, e.g. cyclical replication, replication by trigger, ...), which depend on the environment and the customer's requirements. For a "real" online link to the ERP system (i.e. generation of new part numbers directly from PARTsolutions), an ERPsolutions/gateway (e.g. the ERPsolutions/gateway SAP MM or an individually programmed gateway ) is required in addition to the ERP module.



[63] Detailed information on this can be found under PARTdataManager – ERP/PDM Erweiterungen.

Prev Up Next
4.1.7. Modules  Home 4.1.7.2. PARTsolutions/base module ERP