Oracle Database – Anodot

This article describes the main steps required to create the Oracle Database data source and stream query.

Creating an Oracle Database data source

In the Navigation Panel, go to Integrations > Catalog.
Use the Search box OR click the Databases filter to locate the data source.
Hover over the Oracle Database tile, and click Start. The Oracle dialog is displayed, as shown below.
Note: If the data source has already been used, a dialog is displayed in which you can select from one of the listed sources. Alternatively, create a new source by clicking Add a new source.
Enter your Host .
Either enter your Oracle port number or SSL port [or leave the default port numbers. (1521/2484]
Enter a Service ID (SID).
Enter a user account name.
Enter a password.
Select/clear the Use SSL checkbox. By default is is selected.
Add an Anodot server IP to your firewall's allowlist. See Allowlist Anodot Servers.
Click CONTINUE to open the Stream Query window.

Note: To create an Oracle Database stream query, see Creating a Stream Query from a Database