Siren Platform User Guide

Importing data from an external datasource

You can import data by using the Data Reflections app.

The Data Reflections app allows you to import and map data to Elasticsearch either from JDBC datasources or from Excel or CSV files.

Prerequisites

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

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.

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

    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.