OrCAD CIS Users Guide -- Setting up OrCAD Capture CIS.pdf

OrCAD CIS User Guide Product Version 16.3 December 2009 3 Setting up OrCAD Capture CIS This chapter describes the four tasks necessary to set up OrCAD Component Information System (CIS), including: Creating a part database” on page 29 Setting up the ODBC data source” on page 44 Creating a configuration file” on page 47 Editing a configuration file” on page 56 Also included are procedures for setting the up the CIS work environment, including Setting up the ICA to access external part data” on page 74 and Creating Crystal Reports templates” on page 74. Creating a part database The part database is the entity that contains all the relevant information for the parts you use in your designs. You can think of a part database as one or more tables, with each row in a table representing a part and each column representing a part property. Apart from the tables containing part property data (henceforth referred to as primary tables), your part database may also include tables with relational data. For example, your parts database may contain a Vendors table to support handling of multiple vendor / manufacture part numbers per unique company part number. Note: Capture CIS supports a one-to-many database relationship between the part information tables and related tables. Before you create your part database, you need to choose whether to use a database or spreadsheet application. You can create a database from an existing Capture design. Then, when you create your part database, you need to carefully setup its structure and organization, including: Part property assignments. See Determining part properties” on page 32 Field formats for properties. See Setting the field format” on page 40. Number of tables used in the database