Adding Support for Other Database Management Systems

TestStand 2019 Help

Edition Date: May 2019

Part Number: 370052AA-01

»View Product Info
Download Help (Windows Only)

You can add support for database management systems (DBMSs) other than SQL Server, Oracle, Microsoft Access, Sybase, and MySQL by adding a new schema in the Database Options dialog box or by using SQL scripts.

Click the Duplicate button on the Schemas tab of the Database Options dialog box to copy an existing schema and then customize the statement, column, and parameter settings to work with the new DBMS. The TestStand schemas for each DBMS conform to the default database tables.

Alternatively, you can create result tables for the default table schema for a similar DBMS by using the SQL script files located in the <TestStand>\Components\Models\TestStandModels\Database directory and modifying the schema for the new DBMS.

You can also complete the following steps to create new script files for a DBMS.

  1. Create new script files in the <TestStand Public>\Components\Models\TestStandModels\Database directory. National Instruments recommends including the name of the DBMS in the filename.
  2. In the new script files, enter the SQL commands for creating and deleting DBMS tables. Refer to the SQL database script files TestStand provides for guidelines. For example, the SQL database syntax file for Oracle result tables might contain the following commands for creating a UUT_Result table:

    CREATE TABLE UUT_RESULT
    (
    ID NUMBER PRIMARY KEY,
    UUT_SERIAL_NUMBER CHAR (255),
    USER_LOGIN_NAME CHAR (255),
    START_DATE_TIME DATE,
    EXECUTION_TIME NUMBER,
    UUT_STATUS CHAR (255),
    UUT_ERROR_CODE NUMBER,
    UUT_ERROR_MESSAGE CHAR (255)
    )
    /
    CREATE SEQUENCE SEQ_UUT_RESULT START WITH 1
    /
    CREATE FUNCTION UUT_RESULT_NEXT_ID RETURN NUMBER IS
    X NUMBER;
    BEGIN
    SELECT SEQ_UUT_RESULT.NextVal INTO X FROM DUAL;
    RETURN X;
    END;
    /
    Note Note  Notice that the script uses three separate commands, each separated by the "/" character, to create the UUT_RESULT table in Oracle.

    Use a similar syntax for deleting tables. For example, the SQL script file for Oracle might contain the following commands for deleting a UUT_RESULT table:

    DROP TABLE UUT_RESULT
    /
    DROP SEQUENCE SEQ_UUT_RESULT
    /
    DROP FUNCTION UUT_RESULT_NEXT_ID
    /

WAS THIS ARTICLE HELPFUL?

Not Helpful