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 is
hostthe 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.