Fiorano Logo  
     Fiorano Login 
Fiorano SOA™ Platform
 Fiorano ESB™
 Fiorano Orchestration Tools
 Fiorano Adapters
 Product Features
 Business Benefits
 Developer Benefits


DB Adapters

DB Adapters are a set of services that provide connectivity to heterogeneous databases. They are typically used to integrate applications, which involve operations on a database. The DB Adapters service category consists of the following prebuilt services:

RDBMSOutAdapter

The RDBMSOutAdapter service is used for continuously monitoring specific tables in a database. You can set the monitoring details for a particular table or column. If any insert, update, or delete operation occurs on the specified table or column, the record is retrieved from the database and sent to the output port in XML format. The XML format can be user defined or default. You can also use the adapter to execute specified SQL statements periodically on a database.

RDBMSInAdapter

The RDBMSInAdapter service inserts, deletes or updates records into a JDBC and ODBC databases. The RDBMSInAdapter service receives records as XML documents at its input ports and performs the required operation on the specified database. The adapter may also be used to insert, delete, or update records in multiple tables, from a single input message.

RDBMSQueryAdapter

The RDBMSQueryAdapter service represents an adapter for querying any database. It accepts a select query at its input port and queries the database. It then sends the retrieved data to the output port in XML format.

JAlloraOutAdapter
 

The JAlloraOutAdapter service represents an adapter to the third party product called JAllora Mapper. Based on the defined mappings and using the JAllora Mapper application, it retrieves data from the database and sends it to the output port in XML format. The JAllora Mapper is integrated with the service and launched from the Fiorano Enterprise Service Bus™ environment. The adapter is event-based. This implies that data is retrieved from the database only when an event occurs at the input port.

JAlloraInAdapter
 

The JAlloraInAdapter service represents an adapter to the third party product called JAllora Mapper. It receives data from the input port in the XMI format. Using the JAllora Mapper application, this data is inserted in the database, based on the defined mappings. The JAllora Mapper is integrated within the service and launched from within the Fiorano Enterprise Service Bus™ environment.

JAlloraQueryAdapter
 

The JAlloraQueryAdapter service represents an adapter to the third party product called JAllora Mapper. It accepts a select SQL statement from the input port, executes the query and sends records as XML, to its output port.

 

For getting the sample source code of some of these services, Download Fiorano Enterprise Service Bus™ Now. After installing Fiorano Enterprise Service Bus™ , the sample source code can be located in the following drive $TIFOSI_HOME\Services\





© Fiorano Software Inc. All Rights Reserved. Privacy Statement |Terms of Use
  Site Developed & Maintained by Fiorano Webteam.


 World Wide Support
 USA
:
+1-408-354-3210
 INDIA
:
+91 80 4017-0000
 UK
:
+44(0) 19328 95005