PhixFlow Help
How To: Read from a Database
A common task in PhixFlow is to read data from a database. This example shows how to read data from a CRM database, which is hosted on a local instance of SQL Server 2008, but the same principles apply for other database platforms on networks or in the cloud.
Step-by-step guide
- Add a new Datasource to your model and Select the driver class to match your database and check all three checkboxes on the details tab
- Click on Datasource Instances and add a new instance providing the connection string, username and password as shown below. (For SQL Server, the connection string specifies the Server, SQL Server Instance and Database)
- Save and close the Datasource.
- Hover over the Datasource and select Add a new database collector
- Check both the checkboxes on the details tab and save.
- Add a SELECT query to the query string tab and test by clicking the Run query button. You should see results from the table in your query
- Save and close the database collector.
- Hover over the database collector and select Create a new stream using the attributes returned by the query
- View the attribute expressions to confirm that each column in the query has been configured
- Run analysis on the stream and view the results
Sample Model for reading from a Database
Connection String for Local Instance of SQL Server
Attributes configured automatically from the SELECT Query
Model Ref: 003
Related articles
Filter by label
There are no items with the selected labels at this time.
Please let us know if we could improve this page feedback@phixflow.com