Gamma Soft to Feed DB2/400 Data to NuoDB
December 10, 2013 Alex Woodie
Gamma Soft recently announced it has formed a partnership with NewSQL database startup NuoDB to provide data integration capabilities. The partnership will see Gamma’s data integration software serving DB2/400 data, among others, into NuoDB’s database in a real-time manner.
NuoDB is one of the more promising startups chasing the sudden interest in, and demand for, so-called “NewSQL” databases that have been built from the ground up to handle huge data volumes and a variety of data types in a way that would cause the schema to break in a traditional SQL database. What makes NuoDB interesting is how its distributed database can handle the scalability, durability, and data-type flexibility without breaking the strong consistency bonds that users of traditional SQL-based databases have come to rely on for reliably processing transactions. Only a handful of the dozens of NoSQL and NewSQL databases can do this; NuoDB is considered one of them.
This is all well and good, but what’s in it for IBM i shops? Thanks to the partnership with the French software company Gamma Soft (not to be confused with IBM i HR software maker Gamma Software of Oregon), NuoDB customers can replicate data to and from the NuoDB and a variety of source and target systems, including DB2/400, Oracle, SQL Server, MySQL, PostgreSQL, and Progress OpenEdge.
Gamma Soft’s eponymous data integration tool accesses source databases using logs or journal files using standard APIs. This prevents it from impacting the source database, which provides sub-second synchronization and transformation. In addition to standard transactional databases, it supports analytical-oriented databases, such as Actian Vectorwise, IBM Netezza, EMC Greenplum.
“The integration of our real-time technology with the NuoDB distributed database will provide the security, traceability, and immediacy of data that customers need as they transition systems to NuoDB,” stated Gamma Soft CEO Henri Descraques in a press release. “Given NuoDB’s popularity, Gamma Soft opens up new opportunities for NuoDB customers to enhance and create valuable data-driven systems.”
NuoDB is based in Cambridge, Massachusetts, where Gamma Soft maintains its US office.