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.
Edit
elasticsearch.yml
and add:node.attr.connector.jdbc: true
Copy the JDBC driver to the
elasticsearch/plugins/siren-federate
folder.Restart the Elasticsearch service.
In Siren Investigate, navigate to Management > Datasources.
Select JDBC from the Type box.
Select the Database Type.
Enter a display Name for the datasource in Siren Investigate.
Enter the database Username and Password.
Click Test connection. If the connection is successful a dialog is displayed.
Click No, will do later then click SAVE.
In Siren Investigate, navigate to Management > Virtual Indices.
Select the Datasource name.
Select the Resource name from the Datasource browser.
Enter a valid lowercase Elasticsearch Virtual index name.
(Optional) Enter a Primary key. This is required if you want to use this Index in the graph browser.
Click SAVE. A dialog is displayed.
Click Yes, take me there, then refer to see Creating a data model. Alternatively, click No, will do later then click SAVE.