Siren Platform User Guide

Connecting an external datasource with Siren Federate


Install the Siren platform as described in Installing the Siren Platform.

We support these databases using JDBC drivers:

  • Dremio

  • Impala

  • Microsoft SQL Server 2017

  • MySQL

  • Oracle 12c or later

  • PostgreSQL

  • Presto

  • Spark SQL 2.2 or later

  • Sybase ASE 15.7 or later

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

Configure Siren Federate
  1. Edit elasticsearch.yml and add:

    node.attr.connector.jdbc: true
  2. Copy the JDBC driver to the elasticsearch/plugins/siren-federate folder.

  3. 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 2.2.4 Creating an initial data model). Alternatively, click No, will do later, then click SAVE.2.2.4 Creating an initial data model