Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page is for administrators who need to configure direct access to the PhixFlow database.

...

Tip

Before you start, we recommend you have a list of any the streams that are already onfigured configured to create a database view. Is there an easy way to find this e.g. in the database?In the repository right-click the Streams heading and select View Detailed List. You can filter the detailed list to show those with a database view.

In the PhixFlow Database

1.  Create a role in the PhixFlow database.

...

For a MariaDB database: set the Grant option GRANT OPTION privilege for the PhixFlow database user; see the MariaDB documentation on The Grant Option Privilege.

In the PhixFlow Application

3.  Set up the specific streams that need to be available to generate database views.  In the stream properties → Advanced → Database View, enter a string in the formatv_xxxxWhen the stream is published to the database, PhixFlow creates a view for the stream data.

Tip

If you have already created database views, they will only become available to database users after you republish the stream data.

4.  In the System Configuration→ Advanced →  Database View Role, enter the name of this database role.

Note

This option refers to a role in the PhixFlow database not in the PhixFlow application.

...

7.  Tick the Enabled box again and resave the stream. This forces PhixFlow to publish .

8. Access the stream data and to create the database view, so that PhixFlow publishes it and recreates its database view. To access stream data do one of the following:

  • Open a stream view.
  • Run analysis on a model that contains the stream.
  • In the 
    Insert excerpt
    _administration
    _administration
    nopaneltrue
     menu, select Other Options → Publish Streams. This publishes all pending changes and may take some time.

If the configuration is incorrect, publishing a stream with a database view will fail. Check the console for error messages to help you correct the configuration.

Anything specific they can look for if it goes wrong?

When the configuration is correct, publishing will complete successfully.

...

8.  To republish existing database views, you can either follow steps 6 and 7 to 8 to trigger republishing. Alternatively, you can open any stream view for the stream.  

Tip

Remember that the 

Insert excerpt
_administration
_administration
nopaneltrue
 →  Other Options → Publish Streams option only publishes changed stream data. You need to use the disable/enable method or opening a stream view to "touch" the data, so that PhixFlow knows to republish it.

If pubslising fails, PhixFlow will not attempt to republish until the stream configuration changes (steps 6-8 above).

Managing the Database Role

...

Once the database role is created, making changes to the System Configuration→ Advanced →  Database View Role name does not update existing views or remove them from the previous role. 

...