Database
Use database objects to define project-embedded databases or an external databases.
Database types
FactoryTalk Optix Studio
supports the following database 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:
An embedded database supports up to 2000 table columns.
|
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 series data. 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 Studio 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. For more information, see Create a remote Influx database. |
Use of databases
You can read from and write to a database through:
- SQL queries. See SQL queries.
- OPC UA methods exposed by the object. See OPC UA.
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 box | |
Combo box | |
Trend | |
Data logger | Write data |
Event logger | |
Recipe schema | Write and read data |
Provide Feedback