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. To create an ODBC database
  2. In
    Project view
    , right-click
    DataStores
    and select
    ODBC database
    .
  3. In
    Properties
    , in
    DBMS type
    , select the type of the database server.
  4. In
    Properties
    , complete:
    • 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.
      NOTE: 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.
(optional) Configure the database structure. See Configure a database table.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.