powered by CADENAS

Manual

Manual

5.2.2. Database installation per PARTsolutions Setup

Before parts management can be set up, a full version of PARTsolutions must be installed. Ideally, you should install the most up-to-date version.

  1. The basic components for PARTsolutions are installed in the PARTsolutions programs dialog by selecting PARTsolutions parts management.

    PARTsolutions programs

    PARTsolutions programs

    This ensure the installation of the following basic modules:

  2. The modules for parts management with ERP, PDM, PLM integration are installed in the dialog PARTsolutions parts management with one of the following options.

    PARTsolutions parts management

    PARTsolutions parts management

    • Parts management productive (without database)

      For users who already have a database and want to manually connect PARTsolutions to it.

    • Parts management demo environment (incl. SQlite)

      For users who want to test parts management but do not want to implement it productively. Here the demo data will be installed.

      [Note] Note

      In order to display the demo data, the installation of the standards DIN, EN, ISO, etc., is required.

    • SAP interface (MM/DVS): Module to connect PARTsolutions to SAP MM.

    [Note] Note

    As soon as you have selected parts management with ERP, PDM, PLM integration, you are working with link database connection. In a standard installation without adjustments only the Database login… dialog will show up during the start of the PARTsolutions modules.

    Database login…

    Database login…

    • When using the standard SQL scripts in your installation medium the link database PLINKDB is created with the following users:

      • Standard user: User 'erpuser', password 'erpuser'.

      • Administration: User 'sa', password 'PARTsol9.0!'.

    • For the demo database PLDBDEMO, the following users are available:

      • ecat

      • location

      • mechanical

      • plant

      • product_aircraft

      • product_automotive

      • quality

      • supplier

      • release

      Password entry can be left out.

    For each of the above mentioned options PARTlinkManager (Section 5.21, “ PARTlinkManager reference ”) is installed.

    [Note] Note

    If parts management is installed with ERP, PDM, PLM integration, you can find the directory erp under $CADENAS_SETUP\scripts.

  3. Driver for database

    If Parts management demo environment (incl. SQlite) had been selected, you don't have to select any driver here. JDBC is installed by default.

    If Parts management productive (without database) had been selected, the standard selection is MS-SQL Server ODBC driver configuration.

    Detailed information on ODBC and JDBC can be found under Section 5.2.5, “JDBC driver ” and under Section 5.2.4, “ ODBC driver”.

    Database connection selection

    Database connection selection

  4. You also have the option of selection EDM/PDM/PLM integrations.

    EDM/PDM/PLM integrations selection

    EDM/PDM/PLM integrations selection

  5. For complex problems, such as for example part reduction and importing the initial filling, you need:

[Note] Note

More information concerning the setup-routine can be found under PARTsolutions Teilemanagement.