Database

A Database object represents a project-embedded database or an external database.
You can read from and write to a database through:
  • Standard SQL queries
  • OPC UA methods exposed by the object

Availabledatabase types

Object
Description
Embedded Database
An object that represents an SQLite database internal to the project at runtime. You typically use an Embedded Database object to manage data supporting other objects within the
FTOptixApplication
.
An embedded database has no read/write limits.
TIP: The maximum number of table columns is 2000.
ODBC Database
An object that represents a local or remote database supported by the Open Database Connectivity (ODBC) protocol. You can use ODBC to query or populate a remote database maintained with other systems that contains data for the project.
Depending on the access management policy of an external database, the external database can have read/write limits.
Influx Database
An object that represents a remote Influx database especially useful for time seriesdata. In a limited way, you can use SQL to query or populate a remote database maintained with other systems that contains data for the project.
TIP: FactoryTalk Optix parser can transform only some SQL commands to InfluxQL (Influx query language). See Influx database limitations.
Depending on the access management policy of an external database, the external database can have read/write limits.

Use of databases

Examples of objects that can read from and write to a database
Object
Database interaction
Data grid
Query a database to obtain data to be displayed at runtime. For example, display database records from a specific date in a Data grid.
List
Drop-down selection
Trend chart
Data logger
Store data
Event logger
Recipe schema
Store and read data
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.