Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Datasource Properties
Basic Settings object. You will use this name to specify this datasource in other collector and exporter objectstickedtickedThe datasource uses the anonymous username and password configured for the specific instance (see below)
You must have the Allow anonymous updates on datasources privilege to change this option.
Note |
---|
The target database must already have the same username and password with the required permissions. Contact the database administrator to do this. |
When a parent application is deleted by the import, its datasources will also be deleted. This prevents orphaned datasources persisting in PhixFlow.
Required. Select the driver class for the type of database to which the datasource connects.
Tip |
---|
The drop-down list may contain driver classes that are deprecated and do not have the necessary database drivers; see Driver Classes. |
Database Instance
Advanced have these gone away? I don't see an Advanced section? "", e.g. . Setting this field causes PhixFlow to run "" See also database collectors for guidance on writing connections to have certain that are PhixFlow's default external Datasource configuration. The value entered in this field will determine which that this datasource instance Connection URLsA 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:
Oracle
jdbc:oracle:thin:@hostname:1521:phixflow
jdbc:oracle:thin:@hostname:1521/phixflow
SQL Server
jdbc:sqlserver://hostname\myservice;databaseName=phixflow
MySQL
jdbc:mysql://hostname/phixflow