...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
...
How a datasource behaves when you run analysis on the model is affected by:
- the Privilege Allow anonymous updates on datasources. Only a user with this privilege can change the Allow Anonymous Export tick box on the datasource.
- 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.
- 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).
You need 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. |
...
...
...
...
- g 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.
...
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.
...
Required. Select the driver class for the type of database to which the datasource object connects. This should match the type of datasource you are connecting to, e.g. Oracle;
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 |
...
...
...
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
...