Introduction

Importing data from a database requires three modelling objects:

1. Datasource: Provides the connection to the database.
2. Data Collector: Defines what is to be collected from the database, this is a SQL statement.
3. Table: The location in PhixFlow to hold the data.

Solution

1. Setting up the Datasource

For a datasource, you must:

• Enter a Name.
• Select a Driver class.
• Add at least one datasource instance.
• Tick the Enabled check box when it is ready to use.

We recommend you tick Protect during import to prevent this datasource being updated or deleted during import.

For a datasource instance, you must:

• Enter a Name.
• Enter the URL for the database.
• Specify the Username and Password.
• Tick the Enabled check box when it is ready to use.

Other settings are optional.