Database entities are used for direct database access, in flow procedures. Once the database connection is defined, it is possible to connect to it in any flow procedure and perform execute, select, commit and rollback statements.
To create a Database Connection
Create a new Database Connection via the menu item.
Enter a name and description and click .
Select the type of database that will be used as the application's database connection.
| Database | Driver | Requires Driver Files |
|---|---|---|
| Apache Derby | org.apache.derby.jdbc.EmbeddedDriver | |
| MS Access (MDB) | com.ms.jdbc.odbc.JdbcOdbcDriver | |
| ODBC (Microsoft) | com.ms.jdbc.odbc.JdbcOdbcDriver | |
| SQL Server | com.Microsoft.jdbc.sqlserver.SQLServerDriver | Yes |
| Oracle | oracle.jdbc.driver.OracleDriver | Yes |
| MySQL | org.git.mm.mysql.Driver | Yes |
| DB2 | COM.ibm.db2.jdbc.app.DB2Driver | Yes |
Note:
ApplinX currently works "out-of-the-box" with database types MS Access (MDB) and ODBC (Microsoft). In the next version, you
will require driver files. See also Features not Supported in Next Version.
Click . The Database Connection details are displayed.
