The DataBaseAxon connects to the internal database of a CortexDevice and to external databases. The Axon is able the execute SQL commands and select queries.
CortexFramework implemented SQLAPI++ library to access multiple SQL databases:
Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL, SQLite, SQL Anywhere and ODBC
Settings tab
|
|

|
•Connection status
The status of the database connection: CONNECTED or DISCONNECTED
•Connection type:
-local: internal database onboard of a CortexDevice. Settings are configured automatically.
-remote: external database. Setting see below. |
Remote database
|
|

|
•Database type:
dropdown box to choose database type: Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL, SQLite, SQL Anywhere and ODBC
•Server:
Database ipadress
•Database:
Database name
•User:
Username
•Password:
Password
•Port:
Listening port |
Triggers tab
|
|

|
•Name:
The name of the script
•Condition:
Condition to be met before an action is triggered.
•Action:
The scripted action executed when the condition is met.
|