Insert excerpt |
---|
| _Banners |
---|
| _Banners |
---|
name | analysis |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
_standard_settings | _standard_settings | nopanel | trueDatasource Properties
.Basic Settings object. You will use this name to specify this datasource in other collector and exporter objectstickedtickedURL | Enter the URL to connect to the datasource; see Connection URLs below. This option has gone. How does the datasource know where the database is? |
Allow Anonymous Export | Use this option when a datasource is connected to an exporter that will be run by a task, such as a scheduled task. tickedticked allow anonymous export of data via the datasource. The target database must permit anonymous updates. The 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.
Use User Credentials on Export | Use this option when a datasource is connected to an exporter being run interactively. This may be via an application action or when a user clicks Insert excerpt |
---|
_run_analysis | _run_analysis | nopanel | true |
. Insert excerpt |
---|
_check_box_ticked | _check_box_ticked | nopanel | true |
to connect to the target database using the PhixFlow username and password of the current user. Note |
---|
The target database must already have the same username and password with the required permissions. Contact the database administrator to do this. |
Protect during importtickedtickedto prevent this datasource being updated or deleted during import. When a parent application is deleted by the import, its datasources will also be deleted. This prevents orphaned datasources persisting in PhixFlow.
Driver Class | 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. |
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 URLs Anchor |
---|
url | url | Still needed if URL option has gone away?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:
Panel |
---|
bgColor | #e6f0ff |
---|
titleBGColor | #99c2ff |
---|
title | Example connection strings |
---|
|
| |
---|
Oracle | jdbc:oracle:thin:@hostname:1521:phixflow |
Oracle (> 12c with PDB containers) | jdbc:oracle:thin:@hostname:1521/phixflow |
Sql Server | jdbc:sqlserver://hostname\myservice;databaseName=phixflow |
MySQL | jdbc:mysql://hostname/phixflow |
Big Query | jdbc:bigquery://@hostname:@port;ProjectId=@Project;