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 all any the streams that are configured already onfigured to create a database view. Is there an easy way to find this e.g. in the database? |
In the PhixFlow Database
1. Create a role in the PhixFlow database.
...
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_xxxx. When 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. |
...
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.
...