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 | |
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 |
Click
. The Database Connection details are displayed.