Database connection

Edit online

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

  1. Create a new Database Connection via the File > New > Entity menu item.
  2. Enter a name and description and click Next.
  3. Select the type of database that will be used as the application's database connection.
    Table 1.
    Database Driver RequiresDriver 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
  4. Click Finish. The Database Connection details are displayed.