Company Events Academic Community Support Solutions Products & Services Contact NI MyNI

DSC Settings: Database Page

LabVIEW 2013 Datalogging and Supervisory Control Module Help

Edition Date: June 2013

Part Number: 371618J-01

»View Product Info
Download Help (Windows Only)

Requires: DSC Module

Use this page of the Project Library Properties dialog box to enable and configure data logging and alarms and events logging for a LabVIEW project library.

This page includes the following pages and components:

  • Citadel—Use this page to configure the project library to log data to the Citadel database.
    • Enable Data Logging—Configures the project library to log data to the Citadel database.
    • Log to computer—Specifies the name of the computer where the Citadel database resides. The default is localhost.
    • Browse—Displays the Browse Computer dialog box, which you can use to select a computer from the network.
    • Database name—Specifies the name of the Citadel database where the LabVIEW Datalogging and Supervisory Control (DSC) Module logs data.
    • Browse—Displays the Browse Database dialog box, which you can use to navigate to a Citadel database.
    • Database path—Specifies the file path to the Citadel database where the DSC Module logs data.
    • Browse—Displays the Open dialog box, which you can use to select the path of the Citadel database.
    • Data Lifespan—Specifies the length of time, in days, that the data the DSC Module logs is available.
      • Data always available—Specifies that logged data is always available in the Citadel database.
      • Data available for N days—Specifies the number of days that the Citadel database stores the logged data. After the specified number of days, the DSC Module might remove the logged data.
    • Enable Alarms and Events Logging—Configures the DSC Module to log alarms and events to the Citadel database.
    • Use the same database for alarms and events—Configures the DSC Module to use the same Citadel database for alarms and events logging as the Citadel database for data logging. If you place a checkmark in the Use the same database for alarms and events checkbox, the DSC Module ignores the other alarms and events database options on this page.
    • Log alarms and events to computer—Specifies the name of the computer where the Citadel database resides. The default is localhost. Click the Browse button to select a computer on the network.
    • Browse—Displays the Browse Computer dialog box, which you can use to select a computer from the network.
    • Alarms and events database name—Specifies the name of the Citadel database where the DSC Module logs alarms and events data.
    • Browse—Displays the Browse Database dialog box, which you can use to navigate to a Citadel database.
    • Alarms and events database path—Specifies the file path to the Citadel database where the DSC Module logs alarms and events.
    • Browse—Displays the Open dialog box, which you can use to select the path of the Citadel database.
  • Relational Database—Use this page to configure the project library to log data to one of the following supported relational databases: Microsoft Access, MySQL, Oracle, PostgreSQL, and SQL Server.
    • Enable Data Logging—Configures the project library to log data to a supported relational database.
    • Enable Alarms and Events Logging—Configures the project library to log alarms and events to a supported relational database.
    • Connection Settings—Specifies the settings to connect to a supported relational database. Contains the following options:
      • Use Default Database—Specifies to use the default supported relational database to log data. The default relational database is the Microsoft SQL Server 2008 R2 Express, which installs with the DSC Module. The Microsoft SQL Server 2008 R2 Express and the background services run automatically. You can monitor these services in the Services utility.
      • Use Preconfigured System DSN—Specifies to use a preconfigured ODBC system data source name (DSN). A preconfigured ODBC system DSN is an ODBC data source you create in the System DSN tab of the ODBC Data Source Administrator dialog box. In the Windows Control Panel, navigate to the Administrative Tools folder, and double-click the Data Sources (ODBC) shortcut to display the ODBC Data Source Administrator dialog box.
        Note  On 64-bit Windows, you must create a 32-bit system DSN for the DSC Module to detect it. Refer to http://support.microsoft.com/kb/942976 for information about creating 32-bit system DSNs on 64-bit Windows.
        • Preconfigured System DSN List—Lists the preconfigured ODBC system DSNs.
        • Refresh—Refreshes the items in the Preconfigured System DSN List.
      • Use Custom Database Connection String—Specifies to use a user-defined database connection string.
        • Custom Database Connection String—Specifies the user-defined database connection string.
        • Build—Displays a dialog box from which you build a user-defined database connection string that connects to ODBC data. The dialog box guides you to select an Microsoft OLE DB Provider and to specify how to connect to the ODBC data.
      • Username—Specifies the username, if any, for authentication when LabVIEW logs to the supported relational database. This option is valid only if you select Use Preconfigured System DSN or Use Custom Database Connection String. Username overrides the username setting in the preconfigured system DSN or database connection string. If Username is blank and you set the username in the preconfigured system DSN or database connection string, LabVIEW uses the username in the preconfigured system DSN and database connection string.
        Note  If you select Use Custom Database Connection String and you specified a username when building the user-defined database connection string, you do not need to enter the username in Username. The Use Custom Database Connection String field contains User ID=xxx, where xxx is the username.
      • Password—Specifies the password, if any, for authentication when LabVIEW logs to the supported relational database. Each character displays as an asterisk (*). This option is valid only if you select Use Preconfigured System DSN or Use Custom Database Connection String. Password overrides the password setting in the preconfigured system DSN or database connection string. If Password is blank and you set the password in the preconfigured system DSN or database connection string, LabVIEW uses the password in the preconfigured system DSN and database connection string.
        Note  If you select Use Custom Database Connection String and you specified a password when building the custom database connection string, the Use Custom Database Connection String field contains Password=xxx, where xxx is the password. To mask the password in the Use Custom Database Connection String field, leave the password field blank when building the custom database connection string and specify a password in Password.
    • Reconnect Period—Specifies settings to reconnect to the supported relational database.
      Note  LabVIEW ignores the following options until LabVIEW encounters a problem when connecting to the database.
      Contains the following options:
      • Reconnect period—Specifies the length of time to wait before reconnecting to the supported relational database.
      • Reconnect units—Specifies the unit of measurement to reconnect to the supported relational database. You can select from the following units: Seconds, Minutes, and Hours.
  • Table Management—Displays the Table Management dialog box from which you set the table name of each type of logged data.
  • Test Connection—Tests the connection to the supported relational database based on the Connection settings.

 

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
Add Comments 1 2 3 4 5 submit