1. iWay Integration Tools
  2. Chapter 1. iWay Components
  3. Technology Adapters
  4. RDBMS Adapter

RDBMS Adapter

Adapter Overview

If you are looking for a graphical approach for working with an RDBMS system, iWay's RDBMS adapter should be just right for you. This adapter will allow users to explore an RDBMS system and assist in writing CRUD based operations. This adapter also features a "test drive" feature where operations can be tested for proper execution.

The current supported RDBMS systems:

  • HSQLDB
  • IBM DB2 Database
  • Microsoft SQL Server
  • MySQL Server
  • Oracle RDMS
  • PostgresSQL
  • Progress OpenEdge

Adapter Functionality

What can this adapter do?

  • execute SQL statements
  • execute SQL batches
  • execute remore procedure calls, RPC's
  • listen for database events

The Test Drive

Lets see what we can do with this adapter. Within iWay's Integration Tools, IIT we want to create a new Application Project and create an iWay Flow. We then look for the iWay RDMS found within the  Technology Adapters section of the Flow palette. We drag the RDBMS adapter from the palette to the canvas and we wind up with a flow as shown below.

RDBMS adapter

 

Configuring the iWay RDBMS Adapter

At this point we need to configure the adapter to connect to the RDBMS system.

Property Page

Click on the "Plus" sign to create a new configuration. 
RDBMS generic creation

Click Next.

RDBMS Generic MySQL

Assuming your MySQL server is installed locally using the default settings, click on the "Login" Tab to configure security and database settings.

RDBMS adapter MySQL Login

At this point, click on "Test Connection" to verify your configuration. When done, click on "Finish".

Congratulations!! your iWay RDBMS adapter is now ready to be configured with a target.

See iWay RDBMS Generics to configure additional RDBMS systems.

Setting a Target

An adapter target represents the unit of work which will be executed by the adapter. For this adapter this can either be a SQL statement, prepared SQL statement or even a RPC.  Click on the "..." button to the right of the Adapter Target as shown below. This will reveal a "Set Target" menu item. Click on this item.

Adapter Target Selection

A dialog box will appear as shown below.

RDBMS adapter set target

The adapter is now connected to the RDBMS system. At this point we need to decide what we want the adapter to do. Here are our options.

  1. execute a SQL statement
  2. execute a SQL prepared statement
  3. execute a RPC
  4. execute a batch of SQL statements

Lets say we want to execute a simple SQL statement. We can either type in the SQL statement or use what we call a table function. Table functions are predefined and cannot be edited. Table functions cover many of the most utilized SQL operations. See RDBMS Adapter table functions for further details.

We will first demonstrate the use of a table function in our first example. 

 

 

 

For this adapter there will be three initial folders.

They are:

  • batches - named sets of SQL operations to be executed.
  • schemas - tables and RPC's found on the target system
  • statements - user created SQL statements with parameters 

Lets take a look at each of these in the order of importance.

Exploring Schemas

When we drill down the schemas folder we get to choose the database to explore. For our use case we will explore the usjsandbox database.

RDBMS adapter explore schema

This database contains a table named activitylog.