Creating a datasource in Siren Investigate

To ingest data from an Avatica instance into entity tables you need to create a datasource in Siren Investigate.

Procedure

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

  2. From the dropdown menu, select JDBC as the type of datasource.

  3. Enter a name for the datasource. Ensure that it is a meaningful name, as the datasource will be visible to all the Siren Investigate instances connected to the Elasticsearch cluster, for example, sql-sales.

  4. In the Avatica URL field, specify the URL of your Avatica instance. If you enabled TLS in Avatica, set the URL scheme to https.

  5. Enter the user name and password of your user on the system that Avatica is connected to.

  6. If you enabled TLS in Avatica, you will need to define the following properties in the JDBC properties table:

    • TRUSTSTORE: The path to the keystore that contains the security certificate of your Avatica instance.

    • TRUSTSTORE_PASSWORD: The password of the keystore.

  7. If you enabled TLS in Avatica but the server certificate does not match the name of the machine Avatica is running on, you will also need to add the JDBC property HOSTNAME_VERIFICATION set to NONE to disable the hostname verification.

  8. Click Save in the top right corner.

  9. Click Test Connection. If the settings are correctly configured, you will see a message confirming that the connection has been validated; otherwise, the error from Siren Federate should provide details about what went wrong.

Next steps

Import data by using the Data model app.