4.2.3.31. Database Gateway OUT

The database gateway connects to a database and inserts rows into a table.

Currently, we support Oracle connections and PostgreSQL connections. Contact us if you have different database connection needs.

The connection information is common for both IN and OUT gateways:

• host,
• username,
• password,
• database name,
• service id (for oracle only),and
• SSL (check if you wish to use SSL).

The gateway builds and understands the following XML format:

<Message>
  <table1>
     <col1>my first value</col1>
     <col2>my second column value</col2>
  </table1>
</Message>

As an example, if you were to send this in a database gateway out it would try to execute:

INSERT INTO table1 (col1, col2) VALUES ('my first value','my second column value')