Version 9.6
 —  Designing and Developing an Application  —

Database Connection

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.

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  
    MS Access (MDB) com.ms.jdbc.odbc.JdbcOdbcDriver  
    ODBC (Microsoft) com.ms.jdbc.odbc.JdbcOdbcDriver  
    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.

Top of page