Replication to SPL enables to apply data to a stored procedure instead of to a target table. SPL routine can be written using Informix stored procedure language, C or JAVA UDR. Use cases include *) Realtime streaming analytics on OLTP data. Examples include 1) Asynchronously calculate per store sales report 2) Realtime leaderboard calculation for an online game
*) Data transformations. Example: While replicating data from retail stores to central home office, dynamically include data for store id column at home office server.
*) Asynchronously update external systems like message queues, graph databases, and Hadoop filesystems.
*) Replicate data for tables that do not have primary key, ER key or unique index.