Hide Table of Contents

ERP database connection

You can connect an external database, such as equipment stock management database, to manufacturer catalogs. This lets you retrieve data from your database and associate it with the electrical project components.


Menu: Library > ERP database connection


Opens a dialog box that lets you configure links between the SOLIDWORKS Electrical database and your personal database.


Authorize connection to management data database: Check this box to activate the connection between the two databases.

Custom database for catalogs management

You can choose either to connect to the database supplied in SOLIDWORKS Electrical or to your own personal database.

Connection to database

Enter the settings for the connection to the ERP database.

Database type: Enter the type of database (ADO Access, SQL Server, SQLite or ODBC Data source).

Server name: Enter the name of the server for the SQL Server database. This setting is used in all connection modes except the ODBC Data source option.

Data source: Opens the Windows selection data source dialog box to select the file you want to connect. This setting is only available if you select the ODBC Data source option.

User name: Enter the user name to connect to the SQL Server database.

Password: Enter the password to connect to the SQL Server database.

Database name: Enter the database name you want to connect.

Write data: Select the mode for updating data in the ERP database. If you enable Read-only mode, the data will not be updated in the ERP database.

The Test connection button tests the connection between the two databases.

Main data

Manages the links between the various tables and fields in the database (Manufacturer parts and cable references).

Table name: Select the name of the table in the ERP database where the data is.

Reference: Select the field in the ERP database where you can find the reference.

Manufacturer: Select the field in the ERP database where you can find the manufacturer.

User data for manufacturer parts - cable references

Allows you to connect the fields in the ERP database with the manufacturer part user data. The Customize... button lets you access the management interface for manufacturer reference user data.

Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

Subject:   Feedback on Help Topics
Page:   ERP database connection
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:


We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again

Web Help Content Version: SOLIDWORKS Electrical 2023 SP02

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.