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:

    • 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.