Free Trials

Download a free trial to find out which Altium software best suits your needs

How to Buy

Contact your local sales office to get started on improving your design environment

Downloads

Download the latest in PCB design and EDA software

  • PCB DESIGN SOFTWARE
  • Altium Designer

    Complete Environment for Schematic + Layout

  • CircuitStudio

    Entry Level, Professional PCB Design Tool

  • CircuitMaker

    Community Based PCB Design Tool

  • NEXUS

    Agile PCB Design For Teams

  • CLOUD PLATFORM
  • Altium 365

    Connecting PCB Design to the Manufacturing Floor

  • COMPONENT MANAGEMENT
  • Altium Concord Pro

    Complete Solution for Library Management

  • Octopart

    Extensive, Easy-to-Use Component Database

  • PRODUCT EXTENSIONS
  • PDN Analyzer

    Natural and Effortless Power Distribution Network Analysis

  • See All Extensions
  • EMBEDDED
  • TASKING

    World-Renowned Technology for Embedded Systems Development

  • TRAININGS
  • Live Courses

    Learn best practices with instructional training available worldwide

  • On-Demand Courses

    Gain comprehensive knowledge without leaving your home or office

  • ONLINE VIEWER
  • Altium 365 Viewer

    View & Share electronic designs in your browser

  • Altium Designer 20

    The most powerful, modern and easy-to-use PCB design tool for professional use

    ALTIUMLIVE

    Annual PCB Design Summit

    • Forum

      Where Altium users and enthusiasts can interact with each other

    • Blog

      Our blog about things that interest us and hopefully you too

    • Ideas

      Submit ideas and vote for new features you want in Altium tools

    • Bug Crunch

      Help make the software better by submitting bugs and voting on what's important

    • Wall

      A stream of events on AltiumLive you follow by participating in or subscribing to

    • Beta Program

      Information about participating in our Beta program and getting early access to Altium tools

    All Resources

    Explore the latest content from blog posts to social media and technical white papers gathered together for your convenience

    Downloads

    Take a look at what download options are available to best suit your needs

    How to Buy

    Contact your local sales office to get started improving your design environment

    • Documentation

      The documentation area is where you can find extensive, versioned information about our software online, for free.

    • Training & Events

      View the schedule and register for training events all around the world and online

    • Design Content

      Browse our vast library of free design content including components, templates and reference designs

    • Webinars

      Attend a live webinar online or get instant access to our on demand series of webinars

    • Support

      Get your questions answered with our variety of direct support and self-service options

    • Technical Papers

      Stay up to date with the latest technology and industry trends with our complete collection of technical white papers.

    • Video Library

      Quick and to-the-point video tutorials to get you started with Altium Designer

    Integrated Design Software vs. Access Databases For Bills of Materials

    Altium Designer
    |  October 3, 2018

    File cabinet in a laptop screen

    Building databases in programs like Access is easy enough. Access databases deserve a lot of credit for helping organize tons of information in one place. But adapting these programs to electronics design can be a real challenge.

    Any PCB that is intended for manufacturing must have a corresponding bill of materials. This document is critical as it lists all of information about your PCB in a standardized format. Your bill of materials contains a master list of all components that will appear in your PCB, as well as sourcing information. Database software can be useful for building a bill of materials, but it takes time to develop compared to a tool that interfaces with an integrated components library.

    Database Software vs. Integrated Design Tools

    Database software like Access is extremely useful in many applications and has helped revolutionize the way businesses operate. You can design a custom database that catalogs anything you like, including electronic components for use in your PCB. Plenty of businesses use these database tools to track inventory across their organization, including electronic components suppliers.

    Despite its usefulness in a variety of areas, database software is just like any other piece of software: it is great for its intended application, but it can create problems if used outside of these core areas. When you compare the required capabilities by PCB design software and manufacturers with the core capabilities of database software, the drawbacks of using database software for bills of materials become apparent.

    PCB design software needs to pull information from your component libraries so that you can create a full layout of your device. Your design software then needs to compile component information in your bill of materials before you move to production. When you use a 3rd party database format, you’ll be stuck manually moving information between your component library and bill of materials when you prepare for manufacturing.

     PCB assembly and testing

    PCB quality assurance is necessary for any assembly or production stage.

    Reinventing the Wheel

    Taking an Access template and adapting to a bill of materials for your next electronic device, or building a new template from scratch is not a difficult task. The difficult and time-consuming task involves importing your electronic parts information, specifications, and sourcing data into this database. You’ll need to import this information from another database, enter it manually, or retrieve it directly from component suppliers.

    In effect, you are building a components library from scratch, despite the fact that many of these libraries already exist. Great PCB design software will include a components library that provides all of this information. These libraries are designed to integrate with your PCB design software, whereas an external database file does not have this functionality.

    When creating your bill of materials in a database program, you’ll have to import information from your library database into your bill of materials database. But this creates the risk of falling victim to obsolescence. Unless your database program can obtain sourcing and lifecycle information from component suppliers, you risk including obsolete or un-sourceable components in your PCB. Inevitably, you won’t find out this has happened until you are on the cusp of production, forcing a costly redesign and database updates.

    If you ever go to update or build a new version of an old device, you create the same risk all over again, and you’ll have to go through the same database updates. This consumes more time on the front end with database updates, it could potentially consume more time on the back end with redesigns, and cuts into your overall manufacturing budget.

    Person typing on a laptop

    Forget about updating component information manually

    Using An Integrated BOM Tool Over Database Software

    The major problem with using database software for your component libraries and your bill of materials is time lost due to lack of synchronization with your design, and lack of obsolescence and sourcing information. Even if you do use a service that provides an updated component library in a database format, you’ll have to manually search suppliers for sourcing information and copy this information into your bill of materials.

    Sure, you could write a program that accesses supplier information and updates it into your database, but you’ll just be reinventing an inferior wheel. Your design software will still be unable to synchronize with your components database and your bill of materials database, forcing more manual entry of information in these files.

    Rather than writing custom software to integrate database formats that were never designed for use with electronics design, an excellent PCB design software platform can do this for you. Your design software platform should periodically update your sourcing information, ensuring that you and your fabricator can access the critical components your PCB needs to work properly.

    Great design software can take unify your schematic, layout, and component data in a single interface. This information is then used to automatically generate your bill of materials, and you can rest assured that your manufacturer will have all the information they need to begin production.

    You can take your next PCB from idea to a real product when you use a great piece of PCB design software like Altium Designer. The ActiveBOM tool and your component libraries are unified with your other design tools, allowing you to generate industry-standard layouts, your bill of materials, and manage your components.

    To learn more about product management and how Altium Designer can help you bring your next device to production, talk to an Altium expert today.

    About Author

    About Author

    PCB Design Tools for Electronics Design and DFM. Information for EDA Leaders.

    most recent articles

    Back to Home