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 host:port, being host 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.
Syntax of the CREATE DATASOURCE ARN statement (Aracne)
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:

Syntax of the ALTER DATASOURCE ARN statement (Aracne)
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.