Database Connection

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.

Start of instruction setTo 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.

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