Install the Siren platform as described in Installing the Siren Platform.
We support these databases using JDBC drivers:
Microsoft SQL Server 2017
Oracle 12c or later
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.
Copy the JDBC driver to the
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.