SQLstream delivers, out of the box, a rich set of adapters to automate the generation of RAM data message streams.

Adapters are plug-in modules, executing on SQLstream's RAMPs managed centrally by SQLstream's Control Node. Adapters are installed and configured as needed by RAM streaming processing applications. See the Architecture pages for additional information on general SQLstream concepts and features.

SQLstream's comprehensive set of adapters supports relevant ANSI SQL standards such as SQL/MED (mediation of external data). These adapters are packaged as plug-ins that can be dynamically loaded and extended, including JDBC/ODBC drivers, log file parsers, database adapters, JMS and SOAP adapters, email adapters, and others.

Drivers

Drivers are separate remotely-installed modules that support industry Application Programming Interfaces (APIs), which in turn talk directly to SQLstream's RAMMS in order to input or output data or to effect configuration changes.

SQLstream offers standards-compliant drivers for JDBC and ODBC, the industry standards for interactions with databases, such as inputting data into RDBMS. In the context of SQLstream, these drivers enable the insertion of messages into named RAM streams as opposed to the insertion of rows into named tables, as found in RDBMS. These drivers thus enable many existing applications to take immediate advantage of SQLstream's RAMMS with truly minimal application rewrite.

SQLstream, as the next generation of Messaging Oriented Middleware (MOM) offers a standards-compliant driver for JMS (Java Messaging Service). JMS is an Application Programming Interface (API) that is independent of the MOM product that implements the API. It allows applications to be written to take advantage of messaging without being tied to a specific MOM platform.

Plug-Ins

SQLstream offers a rich set of dynamically loadable adapters (plug-ins) that

• Generate new input RAM data streams from external data sources
• Output data streams from internal RAM streams
• Transform RAM streams using non-SQL programming modules and logic

SQLstream offers adapters for:

• Log files
• Log4J
• SOAP and Web-services
• HTTP
• RDBMS
• Email messages
• Text alerts
• Many others

RDBMS Change Data Capture

SQLstream supports RDBMS adapters that automate instrumentation of RDBMS, reading the database schema to extract the meta data and then automating the capture of transactions to selected tables (insert, update, upsert and delete).

SQLstream database adapter supports many of the leading RDBMS. It also enables transactionally safe updates and implements a wide range of sophisticated inter data model mediation, content data mediation and multi-directional synchronization without data loss. This can be done with a configurable and customizable conflict resolution strategy..

RDBMS Database Adapters

SQLstream has adopted the SQL:2003 standard for Management of External Data (SQL:2003 SQL/MED standard). This provides a simple yet efficient mechanism for reading data from a wide range of standards based RBDMS products to create named data streams with data-types generated compatible with the originating schema and to do the converse, writing output RAM streams to external RDBMS tables.

Software Development Kit (SDK)

SQLstream also offers a Software Development Kit (SDK) which enables the easy construction of any required adapter. In this way, SQLstream's RAMMS can be extended to provide any kind of processing logic to enhance and extend its already powerful SQL engine.