Trimech-Main-Site-Group-Navigation Solid-Solutions-Group-Navigation Javelin-Group-Navigation Trimech-Enterprise-Solutions-Group-Navigation Trimech-Advanced-Manufacturing-Group-Navigation Trimech-Staffing-Solutions-Group-Navigation Solid-Print-Group-Navigation 3DPRINTUK-Group-Navigation 3DVERKSTAN-Group-Navigation Macdac-Site-Group-Navigation GRM-Consulting-Group-Navigation Solid-People-Group-Navigation
The TriMech Group offers a comprehensive portfolio of engineering and design software, hardware, professional services, and support, to clients accross the globe. Use the links above to visit the group's websites and learn more.
x
Search

How to Connect ERP Databases to SOLIDWORKS Electrical

Monday April 24, 2023 at 8:00am

Let’s show you how to connect ERP databases to SOLIDWORKS Electrical.

Regardless of whether these are databases for equipment stock, management databases, or manufacturer catalogues, the method below will show you how to connect a database to SOLIDWORKS Electrical.

First, let’s associate this SQLite database to the existing Manufacturer Part library.

We can associate up to 20 user data with cables and other 20 user data with manufacturer parts.

Below we can see only the technical data of a single part.

We can associate the ERP through the Library Tab > ERP connection Database. We need to tick the option Authorize connection to connect the database and select the database type:

  • ADO Access Connection
  • SQL Server Connection
  • SQLite connection
  • ODBC Data Source connection

For the SQLite we need just the database name and if you have specific credentials, you must insert them too.

The section Main Data is fundamental to mapping the database and ensure the attributes are assigned to the correct parts.

The reference number is alphanumerical code. Most of the time it is a unique cipher, but it may happen that two brands have the same reference number (e.g. Siemens and ABB).

Both parts should have the same part number but different attributes. To make sure these map correctly to their respective parts, we need two values. Ideally, these are the reference and the manufacturer.

Assign a name to each user data and sort them into groups before associated each user data with the right SQLite field.

Let’s test the new SQLite database. As we can see, the part that we assign to this push button has a dedicated ERP tab and all the values are pulled through as expected.

To show any of these properties on the scheme, modify the symbol and within the Part User Data section, add the right attribute. After adding any of these attributes, we can display their values next to the symbol.

The SQL database is edited and only the parts in the library will have this information updated. To update the parts already inserted into the project we can use the command Update Data in the Process tab.

This tool shows all the parts that have some property discrepancies with the library and allows us to choose which part we want to update. In a few click we can update the entire project.

To show the new properties in the report, add a new column. Sometimes the user data that we want to show is not listed in the predefined query, so we need to add it manually.

Access the Expert Mode section, find the User Data fields, click edit and add them to the report query. The command Test will show us a preview of the available properties. Finally, we can add the column and save the report.

Every time we connect an ERP database a .EWINI file is generated on the server in the ERP folder, this file stores the connection settings, field mapping, database location, username, and password.

Open and modify it to change these settings.

WATCH THE WALKTHROUGH

This quick guide will walk you through the commands we've explored above.

Take the Next Steps...

Enhance your SOLIDWORKS Electrical skills with our CPD-accredited training courses.

Whether you’re a beginner or are intimately familiar with CAD, our friendly and expert trainers are ready to help you get the most out of SOLIDWORKS, either online or in a classroom local to you.

Related Blog Posts

DriveWorks World 2024
DriveWorks World is the biggest DriveWorks technical event of the year, and tickets are FREE for all active DriveWorks subscription customers! This two-day digital event always puts a large focus on sharing knowledge, technical know-how, and automati...
Easter Egg-citing Innovations: Unwrapping Core Fun
SOLIDWORKS SHEET METAL TOOLS CAN DESIGN PRODUCT PACKAGINGAn egg of such grandeur deserves a luxury home.SOLIDWORKS Sheet Metal tools can be applied to a cardboard medium to produce intricate and functional packaging designs.Employing multibody part d....
Reduce Your Time to Market with these 5 Reasons to
As you look to reduce your time to market, SOLIDWORKS PDM frees up your resources by keeping processes ticking over in the background. Let’s break it down.

 Solid Solutions | Trimech Group

MENU
Top