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