...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
...
...
...
...
...
...
...
...
Datasource behaviour is also determined by these parameters set elsewhere in PhixFlow:
- Privilege 'Allow anonymous updates on datasources'. Only a user with this privilege can modify the 'Anonymous export allowed' flag on a datasource.
- System Configuration. parameter 'Allow anonymous export by default'. This causes the 'Anonymous export allowed' to be true by default on all new datasources.
To configure a datasource you must specify:
- a name
- a driver class. This should match the type of datasource you are connecting to, e.g. Oracle; see Driver Classes.
- The protect during import flag can be used to prevent this datasource being updated or deleted during import.
To prevent orphaned datasources, when a parent application is deleted by the import, its datasources will also be deleted. - Remember to set the enabled flag to make the datasource active.
- Most importantly, ensure you have configured at least one datasource instance.
...
...
...
...
...
...
...
...
...
...
The datasource can only use the logged in user's credentials (see Use user credentials below).
...
...
...
...
...
...
...
...
...
...
...
Note |
---|
The target database must already have the same username and password with the required permissions. Contact the database administrator to do this. |
...
...
...
...
Password for connecting to the datasource with the Anonymous Username.
I've ticked Allow Anonymous, and Use User, but I'm not seeing any fields where I can specify which user credentials to use. This option has gone.
...
Select the driver class for the type of database to which the datasource object connects.
Tip |
---|
Not all the driver classes listed are configured with the JDBC drivers; see Driver Classes. |
Advanced
...
A datasource instance must have a name, a URL, and a username and password used to connect to the external datasource. The URL should be in one of the following formats:
...
bgColor | #e6f0ff |
---|---|
titleBGColor | #99c2ff |
title | Example connection strings |
...
...
...
...
MySQL
...
Sql Server
...
jdbc:sqlserver://hostname\myservice;databaseName=phixflow
...
bgColor | #e6f0ff |
---|---|
titleBGColor | #99c2ff |
title | Check Query |
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...