We are planning to integrate PDM Standard to a new ERP System we are proposing to implement.
Can I go ahead and plan on doing this integration or do I need to upgrade to Solidworks PDM Professional for integrating to PDM? Please advise.
You'll need Pro if you want access to the API and the Import/Export data functions.
Probably you´ll need pro because PDM Standard is very limited in most of the option, but the final answer depends on your needs
SOLIDWORKS PDM Pro will give you more options and more chances of success for sure!
For SOLIDWORKS PDM Standard, NO integration per se since there is no API. However, if your ERP solution can query SQL databases natively or through their own API, and if you know the inter-workings of PDM tables, then it is plausible to formulate what you may be looking in PDM through read-only T-SQL. i.e. a BOM of a certain assembly part number, etc. We haven't done anything like this yet, but you may want to inquire with a 3rd party data integration company - preferably one that is a SOLIDWORKS partner - if your VAR can't help. I can't vouch for a 3rd party data integration company, you'll have to do your homework on that.
Francisco Guzman | CSWS-DMA
Francisco was spot on!
I'm not sure if they are working with PDM Standard but you may want to check Q-Builds (https://www.qbuildsoftware.com/). I've worked with them on a few projects and they are awesome to work with.
Hope this helps.
Applied CAD Solutions
With PDM Pro you have 3 options > XML, API, SQL
With PDM Std you have just one > SQL
Please have a look "Querying the SOLIDWORKS PDM Database" document in my.solidworks.com > support > solidpractices
Just to chime in here, have a look at CUSTOMTOOLS alongside PDM Standard. They have ERP integrations via SQL.
ERP integration means a lot of things:
- reading meta-data from the ERP database and populate to your data card fields
- remote calls to your ERP system to create new articles
- synchronizing data between these two db's
- generate, format and publish BOM tables in XML, Excel or DB tables
- automatically generate neutral format files (PDF, DXF, STEP) and submit to folders outside PDM
You need (at least) PDM Prof. to make these things happen!
Hi Heiko, Not necessarily. Its enabling the 2 databases to talk to each other. It can be done with PDM Standard and CUSTOMTOOLS easily. I have seen it work with Odoo ERP and PDM Standard.
If it was me, I wouldn't even think about it. You're going to have a mess on your hands in the long run. Good Luck!
Retrieving data ...