PhixFlow Help

Load From and Write to a Database

Scenario

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

In a database, 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 database.
  • Create a 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 database exporter to write the update back to the same database table.


Please let us know if we could improve this page feedback@phixflow.com