Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
- the Privilege Allow anonymous updates on datasources. Only a user with this privilege can change the Allow Anonymous Export tick box.
- the System Configuration option Allow anonymous export by default. When selected, this system option sets Allow Anonymous Export to be ticked by default on new datasources.
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 ...where?.
The datasource can only use the logged in user's credentials (see Use user credentials below). (This statement from the orginal paragraph makes no sense with the sentence above.)
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. |
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 |
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