A database connection is an entity that is used for direct database access in a flow procedure. Once the database connection is defined, it is possible to connect to it in any 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.