Prerequisites

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.

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 Siren Investigate

  1. In Siren Investigate, navigate to Management > Datasources.

  2. Select JDBC from the Type box.

  3. Select the Database Type.

  4. Enter a display Name for the data source 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 Management > Virtual 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 the graph browser.

  6. Click SAVE. A dialog is displayed.

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

Add an index

  1. In Siren Investigate, navigate to Management > Indexes and Relations.

  2. Click Add Index Pattern.

  3. Enter the virtual index name in the Index pattern id box.

  4. Click the Save icon.