Denodo Aracne Data Sources¶
The statement CREATE DATASOURCE ARN creates data sources that point to a Denodo Aracne server.
The following parameters must be specified:
name
: Name to be given to the data source in Virtual DataPort.ARNURI
. Uri of the Aracne search server. The URI format ishost:port
, beinghost
the name of the machine that hosts the search engine. The default port of the Aracne Index Server is 9000.LOGIN
: The user login to access the Denodo Aracne search/index engine server.PASSWORD
: The user password to access the Denodo Aracne search/index engine server.
CREATE [ OR REPLACE ] DATASOURCE ARN <name:identifier>
[ FOLDER = <literal> ]
ARNURI = <literal>
[ LOGIN = <literal> PASSWORD = <literal> [ ENCRYPTED ] ]
[ TRANSFER_RATE_FACTOR = <double> ]
[ DESCRIPTION = <literal> ]
Below is the syntax of the modification statement for an Aracne data source:
ALTER DATASOURCE ARN <name:identifier>
ARNURI = <literal>
[ LOGIN = <literal> PASSWORD = <literal> [ ENCRYPTED ] ]
[ TRANSFER_RATE_FACTOR = <double> ]
[ DESCRIPTION = <literal> ]
Explanation of some of the parameters of these statements:
TRANSFER_RATE_FACTOR
: relative measure of the speed of the network connection between the Denodo server and the data source. Use the default value (e.g. 1 for JDBC databases located on premises) if the data source is accessible through a conventional 100 Mbps LAN. Use higher values for faster networks and lower values for data sources accessible through a WAN.The cost optimizer uses this value when evaluating the cost of an execution plan. The default value is usually correct so you should not specify this parameter unless you have a deep knowledge of the cost optimizer.