Siren Platform User Guide

Importing data from an external datasource

You can import data either by using data reflections or by creating virtual indices.

Prerequisites

Ensure that you have completed the installation as described in Installing Siren Investigate.

Check the list of supported databases at JDBC driver installation and compatibility.

The schema that you want to connect to must be the default schema of the connection user.

Configuring the datasource
  1. To enable JDBC on a node where the Siren Federate plugin is installed, add the following setting to the elasticsearch.yml file:

    node.attr.connector.jdbc: true
  2. Create a directory named jdbc-drivers inside the configuration directory of the node. For example, create the directory in elasticsearch/config or etc/elasticsearch.

  3. Copy the JDBC driver to the jdbc-drivers directory.

  4. Restart the Elasticsearch service.

Connect your database to the Siren platform
  1. In Siren Investigate, navigate to ManagementDatasources.

  2. Select JDBC from the Type box.

  3. Select the Database Type.

  4. Enter a display Name for the datasource in Siren Investigate.

  5. Enter the database Username and Password.

  6. Click Test connection. If the connection is successful, a dialog is displayed. 

  7. Click No, will do later, then click SAVE.

Create a virtual index
  1. In Siren Investigate, navigate to ManagementVirtual Indices.

  2. Select the Datasource name.

  3. Select the Resource name from the Datasource browser.

  4. Enter a valid lowercase Elasticsearch Virtual index name.

  5. (Optional) Enter a Primary key. This is required if you want to use this Index in the graph browser.

  6. Click SAVE. A dialog is displayed.

  7. Click Yes, take me there (see Creating an initial data model). Alternatively, click No, will do later, then click SAVE.