coolOrange has connected Vault with over 40 different ERP systems using our middleware solution powerGate. We are often asked whether powerGate requires the use of the Vault Item Master to synchronize Vault data and BOMs with ERP. Unlike other middleware solutions available, powerGate does not require the use of the Vault Item master. With powerGate, the customer chooses whether to use the Vault Item Master or CAD files.
Deciding between using Vault Items or CAD data for ERP integration depends on various factors. Here are the pros and cons of each approach.
Direct Use of CAD BOM: The CAD Bill of Materials (BOM) is ready for direct transfer to ERP as soon as files are checked in, unlike Items which require an additional creation step in the Item Master after check-in.
Simplicity: The process skips the Vault Item Master, simplifying workflows if the CAD BOM is accurate, resulting in fewer lifecycle management steps.
Limitations with Raw Materials: Inventor lacks built-in solutions for raw materials, requiring workarounds such as using external tools (e.g., powerGate) to handle these elements.
In contrast, if you are using items, this is no longer a limitation! if you create an item, you can create a raw material in the items master and therefore it is already in the BOM.
Note: If they are created in the item master, powerGate can send it to the ERP.
Virtual components: One disadvantage compared to items would be that, inside of vault you cannot add additional BOM rows, you would have to do it through Inventor. If you have an item, and you want to add an additional BOM component, you can do it using the item master.
Completeness and Control: Vault items allow for the manual addition and adjustment of BOM data, ensuring completeness, especially in complex scenarios. Properties can be added that do not belong neither to the file nor the item, only to the BOM.
Example:
Fig.1
Separate Workflows for CAD and BOM: Allows for different release cycles for CAD drawings and BOMs, helping to manage changes more effectively without necessarily linking them directly to CAD revisions. You can create independent workflows. It can be useful to create different workflows related to files and other ones related to items.
Integration with other CAD Tools: When using CAD systems like SolidWorks or AutoCAD Electrical, CREO, and other external ones, which do not natively integrate with Autodesk Vault as seamlessly as Inventor, the Vault Item Master becomes useful! This is because, for these software's, you cannot directly get the BOM from files (by checking them into vault), and the only option is to input that information in the item master. By updating the item property associated to each CAD file.
Increased Complexity: Managing both CAD data and Vault items can add complexity and more steps to Item and BOM workflows.
Potential Redundancy of Data: If your ERP system already tracks BOM history and manages BOM row properties (e.g., length, size, surface treatment), using Vault items to do the same can result in duplication of data management tasks. This duplication does not provide additional benefits and can lead to inefficiencies in maintaining consistent and synchronized data across both systems. This conflict can become a disadvantage.
Extra Effort for Manual Completion: When a complete CAD BOM cannot be created due to complexity, using Vault items to manually complete the BOM might be useful. This manual effort can be time-consuming and labor-intensive.
Vault tracks the history of the files, whenever you check in a new file, how affect the life cycle. So, with files you have already a version/revision property and therefore history, which can be directly accessed/gathered and transferred to the ERP. Items can provide the same. The items have a property related to revisions/versions, that is updated throughout the lifecycle in vault.
Therefore, Revision and tracking happens for both items and files.
But to have access to this historical data of the BOM in files, you need to open the assembly in inventor… with items you just go to the item masters.
Fig.2 - UI Versions in Items
Vs
Fig.2 - UI Versions in Files
As you can see, the revision shown in figure 2 are only related to the main assembly. And in this dialog, you can’t see any sub-assembly or part information regarding the version.
This difference is solved when using the integration with powerGate, where this is neither an advantage nor disadvantage.
powerGate solved this because it can access the information related to history present in the BOM of files or items easily.
In the end, the decision to use Vault Items or CAD files depends on specific business needs, the complexity of the products being manufactured, and the capabilities of the existing ERP system.
For simpler operations or when CAD BOMs are consistently accurate and complete, using CAD data (files) alone can streamline workflows and reduce complexity.
With two exceptions:
For manual additions to the BOM not from the ERP, use Vault items. For ERP-sourced elements, utilize powerGate's feature within Inventor to add them.
For CAD systems like SolidWorks, AutoCAD Electrical, CREO, and other external tools that don't natively integrate with Autodesk Vault like Inventor, the Vault Item Master is essential. You can't extract the BOM by checking files into Vault; instead, update item properties in the Item Master for BOM integration.