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.