Create an ODBC database

Create a database object that fetches data from an SQL server or a MySQL server.
Prerequisites
To connect to an ODBC database from
Windows®
devices:
  1. In
    Project view
    , right-click
    DataStores
    and select
    ODBC database
    .
  2. In
    Properties
    , in
    DBMS type
    , select the type of the database server.
  3. In
    Properties
    , complete:
    • Configuration
      :
      • DBMS type
        . Either
        SQL Server
        or
        MySQL
        .
      • (optional)
        DSN
        (Data Source Name). Applicable only for
        Windows
        devices.
        IMPORTANT:
        If specified, the DSN automatically provides the ODBC connection properties.
        You cannot overwrite the DSN properties by manually completing the
        Server
        ,
        TCP Port
        ,
        Database
        ,
        Username
        , and
        Password
        fields.
      • Server
        . IP address or hostname of the database server.
      • TCP Port
        . TCP port of the database server.
        TIP: The default 0 value resolves to 1433 for SQL servers and 3306 for MySQL servers.
      • Database
        . Database name in the database server.
        TIP: Providing the database name is optional if the database name is specified in the ODBC connector.
      • Username
        . Name of the user that can access the database.
      • Password
        . Password of the user that can access the database.
    • Store and Forward
      :
      TIP: Store and Forward stores data in case of temporary connection loss to storage. See Store and Forward.
      • SF Enabled
        .  Enables or disables Store and Forward.
      • SF Buffer Max Size
        . Maximum number of elements in the buffer, which can be set from 1 to 100000. An element is one entry (row) in a database table.
        TIP: The following diagnostic, read-only properties are available:

          SF Buffer usage
          . A diagnostics value set by runtime, indicating the current number of elements in the buffer.

          SF Buffer overflow
          . A diagnostics value set by runtime. False - indicates currently upcoming data is handled

(optional) Configure the database structure. See Configure a database table.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.