Import and Export Data to a Database
- Former user (Deleted)
- Fiona Sargeant (Unlicensed)
- Anthony George
- Chris Welford
Owned by Former user (Deleted)
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 table.
- Update the table 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.