DB Collector and Exporter

Scenario

Most business data is in a database somewhere. PhixFlow interfaces can interface to most major DB vendors productsdatabases. For supported databases, see System Requirements and Compatibility.

In a DB table, in a DB product of your choice, database, create a table. Now have PhixFlow read data from that table, modify it and write it back to that table.

Solution:

• Create A a datasouce to your DBdatabase.
• Create a DB Collector database collector to take data from your datasource (via a SQL query) into a stream.
• Update the stream to modify one of the attributes of the data (for example, by multiplying it by 2)
• Create a DB Exporter database exporter to write the update back to the same DB table

See Also

• href="../../../../../../doc/training/Exercises.pdf">Patterns and Exercise Training Document
• href="http://www.phixflow-online.com:8081/patterns">PhixFlow Online Patterns and Trainingdatabase table.