Coupling NI Requirements Gateway with Microsoft Access

Publish Date: Aug 13, 2013 | 0 Ratings | 0.00 out of 5 | Print | Submit your review

Overview



Acrobat PDF


Coupling Series Home


LabVIEW


Note: This document applies to NI Requirements Gateway versions 1.1 and earlier. For information on newer Requirements Gateway versions, refer to the Coupling External Applications with NI Requirements Gateway topic in the NI Requirements Gateway help.

Microsoft Access is designed to abstract the necessity of deep database knowledge from the user, making it easy for engineers without database training to track and report record-based datasets. Microsoft’s Fluent user interface and interactive design capabilities allow users to get a jump start in their otherwise costly and time consuming database design and development. NI Requirements Gateway can interface with Microsoft Access database files that store requirements and even references with record-based organization.

Table of Contents

  1. Using the Microsoft Access Type
  2. Adding Database Files to your NI Requirements Gateway Project
  3. Specifying Requirements using Microsoft Access
  4. Specifying Coverages using Microsoft Access
  5. Additional Resources

1. Using the Microsoft Access Type

The NI Requirements Gateway Microsoft Access type does not support Access 2007 (*.accdb) files, however, users of Microsoft Access 2007 can utilize Access' compatibility mode in order to operate upon Access 2003 or earlier (*.mdb) files.

Back to Top

2. Adding Database Files to your NI Requirements Gateway Project

Though every document node in an NI Requirements Gateway project must correlate to only one Microsoft Access database (*.mdb) file, NI Requirements Gateway 1.1 and later allow you to add multiple tables stored within the database file to your NI Requirements Gateway project.  When selecting a database file with multiple tables, NI Requirements Gateway will prompt you to choose one or more tables to associate with the document node.  You can select multiple tables by using either <Shift-Click> or <Ctrl-Click> to highlight multiple options.

Figure 1 - The NI Requirements Gateway Microsoft Access type allows you to associate multiple tables with one document node

When adding an Access database file as a node in an NI Requirements Gateway project configuration, the Table variable becomes available.  After you have selected one or more tables to associate with a document, NI Requirements Gateway populates the Table variable with the name of the table(s) that you have selected.  You can manually adjust the value of the Table variable at any time in the form of an exclamation point (!) delimited list.

Figure 2 - In order to manually specify tables, specify the table names in an exclamation-point delimited list in the Table variable

Figure 3 - An example NI Requirements Gateway Management View that includes Microsoft Access tables

Back to Top

3. Specifying Requirements using Microsoft Access

NI Requirements Gateway can capture requirements from a Microsoft Access table simply by parsing the name of the columns in your database table.  When analyzing Microsoft Access tables, NI Requirements Gateway looks for the following default column names in order to designate the existence of a requirement:

  • Requirement ID – the unique requirement identifier.
  • Requirement Label – the common language name of the requirement.
  • Requirement Text – the common language description of the requirement.

Furthermore, you can optionally capitalize upon several default attributes configured as part of the Microsoft Access type by implementing the following column names in your Access table:

  • Priority – the severity level of the requirement.
  • Allocation – the owner of the requirement.
  • Category – the type of requirement.

Figure 4 - When using Microsoft Access, specify requirements by using specific column names within your tables

As with all types in NI Requirements Gateway, advanced users can customize the Microsoft Access type to read different syntactical column names in order to designate requirements.

Back to Top

4. Specifying Coverages using Microsoft Access

References specified within Microsoft Access are as easily specified as requirements themselves.  NI Requirements Gateway parses the names of tables included in your project in order to find a table by the default name of Covered Requirements.  Within this table, specify covered requirements by their requirement IDs.  If a particular element covers multiple requirements, specify those requirement IDs in a comma-separated list.

Figure 5 - In order to specify the coverage of requirements, place the ID of the covered requirements in a comma-separated list within a column entitled "Covered Requirements"

To simplify the coverage specification process, NI Requirements Gateway gives users the ability to copy requirement IDs for coverage using Microsoft Access.   When you select Copy For » Access Reference  from the right-click context menu, NI Requirements Gateway places the appropriate requirement ID string for the requirement in the system clipboard so that the user can simply paste the string into a Microsoft Access column named Covered Requirements and no longer have to worry about the appropriate coverage string syntax.

Figure 6 - NI Requirements Gateway allows you to copy the correct syntax of a reference to a requirement so that you can simply paste the coverage string into Microsoft Access

As with all types in NI Requirements Gateway, advanced users can customize the Microsoft Access type to read a different column name syntax specifying requirement coverage.

Back to Top

5. Additional Resources

NI Requirements Gateway

Download Free Evaluation Software

 

 

Back to Top

Bookmark & Share


Ratings

Rate this document

Answered Your Question?
Yes No

Submit