Creating New Apache Solr Connections

Arcadia Data supports Apache Solr data connections.

Availability Note. This feature only works on Arcadia Enterprise. If you are using Arcadia Instant and want to get started with Arcadia Data using this connection, please Contact Us.

Apache Solr data connection allows you to build dashboards that use Solr's search engine. Please note:

Developer Note.

Note the following known issue that affects Apache Solr connections:

CONNECTION: User-Defined Aggregate Expressions Do Not Validate

For more information about Solr connections, capabilities, advantages and limitations, see Support for Apache Solr Connections.

The following steps demonstrate how to create new Apache Solr data connections.

Create New Data Connection Modal Window: Solr
Create a New Apache Solr Data Connection
  1. On the main navigation bar, click Data.

    Click DATA on main navigation bar

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. In the side bar, click New Connection.

    Create New Connection

    The Create New Data Connection modal window appears.

  3. In the Create New Data Connection modal window, under Connection type, select Apache Solr.
  4. Under Connection name, specify the name of the new connection. Here, we use SolrConnection.
  5. Under Hostname or IP address, specify the name of your database host, or its IP address; use localhost when the data source is local.

  6. Under Port #, enter the port number. The default port # for Arcadia Engine connections is 8983.
  7. Under Type, you have a choices are the default Cloud mode and Standalone mode.
  8. The Array Join Char, with default "," (comma), is a delimiter that supports complex type processing in Solr. Arcadia can then read multi-valued fields in Solr and process them.
  9. Under Credentials, complete the following entries.

    • Under Username, enter the username for establishing the connection.

    • Under Password, enter the password for establishing the connection.

  10. At the bottom of the modal, click Test.

    testing connection
    Testing the New Connection

    If the connection is valid, the system returns a 'Connection Verified' message.

  11. Click Save.

    connection verified, connecting
    Connecting a Verified Connection

After this operation succeeds, the new connection name appears on the side navigation bar.

Advanced Options

To select advanced connection options, click the Advanced tab, and make changes to any of the following options:

advanced connection options
Advanced Options
  • Socket Type

    Choose one of the following Socket types:

    • Normal

      Default setting

    • SSL
    • SSL with certificate

      If you select this option, you can use the Allow Common Name - Host Name Mismatch option, which means that the issued SSL certificate name does not have to match the host name of the server. By default, the names must match.

  • Authentication Mode

    Choose one of the Authentication modes:

    • NoSasl
    • Plain
    • LDAP
    • Kerberos

      Kerberos authentication is only available on Linux platforms.

  • Query Timeout

    Specify Query Timeout. The default value is 60 seconds.

  • Session Timeout

    Specify Session Timeout. The default value is 0, which means that sessions do not time out.

  • Socket Timeout

    Specify Socket Timeout. The default value is 60.

  • Impersonation

    Check Impersonation if using this feature to control individual table-level access for a user or a user group.

Parameter Options

  • Click the Parameters tab.

    Parameter tabs, specifying parameter name/value
    Specifying Connection Parameters
  • Click the first row to add a Parameter name/value pair. Type in the parameters and their values.

  • If you want to remove a parameter, click (trash can) icon to remove existing parameters.

Result Cache Options

  • Click the Cache tab.

    Cache tab, specifying Result Cache Enable and Retention Time options
    Specifying Cache
  • Select the Result Cache option to enable periodic cache updates.

  • In the Retention Time field, specify the frequency of cache updates, in seconds.

    For example, the default value of 86400 indicates an update every 24 hours, and a value of 300 initiates a refresh every 5 minutes.