DB streaming out - introduction
The GenesisToDb module enables you to stream data from the Genesis low-code platform to classic RDBMS databases, such as Oracle or MSSQL.
The process listens to changes in Genesis tables (insert, modify and delete) and immediately reproduces them in the selected RDBMS.
Broadly, you need to do the following things to make GenesisToDb work:
-
Configure your target RDBMS server so that it has the relevant field and table structures to accept the incoming data from Genesis.
-
Set up one or more streams, each of which defines a source table in Genesis and a destination table in your RDBMS.
-
Include routines for handling the relevant insert, modify and delete actions.