Setting Up Remote Data Stores

Only administrators can set up or manage your remote data store settings from your Remote Data Store. For more information on the Remote Data Store page, see Remote Data Store Page.

 

Note: Orbital will not send results that are over 250 Megabytes in size to a remote data store.

Adding a Remote Data Store

Orbital allows you to define a new remote data store that can then be used to store the results of your queries. To add a new remote data store:

  1. Navigate to Administration > Remote Data Store.
  2. Click Add Remote Data Stores.
    • Enter a unique name for the remote data store.
    • Enter the the uniform resource locator (URL) of the remote data store service. This can be Amazon S3, Asure, or Splunk, as well as a custom remote data store service.
    • Enter the authentication token that you will obtain from the remote data store provider you are connecting to. It is optional to enter a token and is only needed if the service requires it.
    • Enter the character string that is provided as the fingerprint for those remote data stores that provide a self-signed certificate. For more information, see Obtaining a SHA-256 Fingerprint. It is optional to enter a fingerprint and is only needed if the service requires it.

    • Select Compact of Expanded for the Result Format. This is used to define the format that the results of the query or script will take when sent to the remote data store being defined.

      For an example of a compact result format , see Compact Formatted Result. For an example of an expanded result format, see Expanded Formatted Result .

      The default is Compact.

      Defining the format of the query or script results is required; however, you can leave the definition to the default value.

  3. Click Save. The data store is added to the list, and can be selected as a destination for results when scheduling a query.

Editing a Remote Data Store

To edit an existing remote data store:

  1. Navigate to Administration > Remote Data Store.
  2. Click the three dots icon at the end of a row you want to edit and select Edit.

    3. The Edit Remote Data Store screen appears, as shown in the figure below.

  3. Modify the desired values in the Edit Remote Data Store screen in accordance with the field definitions above.

  4. Click Save. The modified data store information is saved to the data store's definition.

Deleting a Remote Data Store

To delete an existing remote data store if the associated service is no longer available or if it no longer meets your requirements:

  1. Navigate to Administration > Remote Data Store.

  2. Click the three dots icon at the end of a row you want to delete and select Delete.

  3. Navigate to the Delete prompt at the bottom of the popup, as shown in the figure below.

    4. The Delete Confirmation Data Store screen appears.

  4. Click Delete . It will remove the remote data store definition from Orbital and refresh the remote data store list.

Obtaining a SHA-256 Fingerprint

If the remote data store is self-signed, you will need to obtain a SHA-256 fingerprint. Depending on the web browser that you use, the procedure for obtaining the fingerprint will differ. As an example, if you use Firefox, the procedure could be as follows:

  1. Navigate to the remote data store's service site in your browser.

  2. Click the lock icon, shown in the figure below, located to the left of the URL.

  3. Click Connection secure, shown in the figure below.

  4. Click More information, shown in the figure below.

  5. Click View Certificate, as shown in the figure below.

  6. Scroll down to the Fingerprints section of the Certificate page.

  7. Copy the fingerprint text from the SHA-256 section.

    Paste into the Fingerprint field of the Add/Edit Remote Data Store dialog.

You can also obtain the necessary fingerprint using the command shown below.

> openssl x509 -noout -fingerprint -sha256 -inform pem -in <filename>.crt

For more details about certificates and fingerprint, contact your host administrator.

More Info