Export XML to SQL Server Database
Automatically Export your PDM PDM BOM to SQL Server for integration with ERP using SOLIDWORKS PDM
With this Q! Tip – We did you a solid! We created an SQL Stored Procedure that will consume your XML BOM that your Data export rules created and consume them in SQL Server. The big picture is, once the data is inside SQL, you can use SSIS (SQL Server Integration Services) to setup the integration with your ERP system.
Extract, Transform, Load (ETL) your data from your XML BOM directly into SQL Server database then use SQL Server Integration Services to then push that SQL database content directly to your ERP System.
Download the Forever FREE SQL script to help you integrate your PDM XML BOM to SQL and SSIS for loading into your ERP System. Download the script today.
See our Q! Tip on how easy PDM XML BOM integration with your ERP System is.
There are no reviews yet.