1. Stream Analytics Documentation
  2. Manage
  3. Connections
  4. Create Connections
  5. Creating a Connection to Oracle Database

4.1.1.19 Creating a Connection to Oracle Database

To create a connection to Oracle Database:

  1. On the Catalog page, click Create New Item.
  2. Hover the mouse over Connection and select Oracle Database from the submenu.
  3. On the Type Properties screen, enter the following details:
    • Name: Enter a unique name for the connection. This is a mandatory field.
    • Display Name: Enter a display name for the connection. If left blank, the Name field value is copied.
    • Description
    • Tags
    • Connection Type: The selected connection is displayed.
  4. Click Next.
  5. On the Connection Details screen, enter the following details:

    • Connect using: Select the database identifiers from the drop-down list.

    • Service name/SID: Enter the name of the Service, SID, or Wallet that you want to connect to.

    • Host name: Enter the host name on which the database is running.

    • Port: Enter the port on which the database is running. It is usually 1521.

    • Username: Enter the database account user name.

    • Password: Enter the password for your database account.

  6. Click Test Connection, to ensure that you have successfully created a connection.
  7. Click Save.