PhixFlow Help

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

DB Collector and Exporter

Scenario

Most business data is in a database somewhere. PhixFlow interfaces to most major DB vendors products.

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

Solution:

  • Create A datasouce to your DB
  • Create a DB 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 to write the update back to the same DB table

 

  • No labels