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:
- Install one of these ODBC drivers:
- MySQL Unicode
- ODBC Driver 17 for SQL Server
- Configure the ODBC data source. See Administer ODBC data sources - Microsoft Support.
- InProject view, right-clickDataStoresand selectODBC database.
- InProperties, inDBMS type, select the type of the database server.
- InProperties, complete:
- Configuration:
- DBMS type. EitherSQL ServerorMySQL.
- (optional)DSN(Data Source Name). Applicable only forWindowsdevices.IMPORTANT:If specified, the DSN automatically provides the ODBC connection properties.You cannot overwrite the DSN properties by manually completing theServer,TCP Port,Database,Username, andPasswordfields.
- 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