1. Stream Analytics Documentation
  2. Manage
  3. Connections
  4. Create Connections

4.1.1 Create Connections

A connection is a collection of metadata (such as URLs, credentials, etc.,) required to connect to an external system. A connection is the basis for creation of sources (Streams, References, or Geo Fences) and Targets. You can reuse connections to create and access multiple sources, targets, or both, in the same system. For example, different Kafka topics in the same Kafka cluster, or different database tables in the same Oracle database.

GGSA supports the following connection types:
Connection Types Supported Artifacts

ADW or ATP
  • Reference
  • Target

AWS S3
  • Target

Coherence
  • Reference
  • Target

Druid
  • Target

Elasticsearch
  • Target
GoldenGate
  • Stream ( Microservices only)

HBase
  • Target

HDFS
  • Target

Hive
  • Target

Ignite Cache
  • Reference
  • Target

JMS
  • Stream
  • Target

Kafka
  • Stream
  • Target

Microsoft Azure Data Lake-Gen2
  • Target

MongoDB
  • Target

MySQL DB
  • Reference

OCI
  • Target

ONS
  • Target

Oracle AQ
  • Stream

Oracle DB
  • Reference
  • Target

OSS
  • Stream
  • Target

4.1.1.1 Creating a Connection to ADW or ATP

To create a connection to Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP):

  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 Wallet from the drop-down list.

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

    • Wallet Archive > Upload File: Upload the archive wallet file stored in your local machine.

      If you do not have the wallet file, you can download it from the OCI Autonomous Database console.

      After you have successfully uploaded the wallet file, all the database services configured under the wallet's tnsnames.ora will be displayed in the service list. Select one of the services based on your requirements.

    • Username: Enter the database account user name.

    • Password: Enter the password for your database account.

      Note:

      Special characters in the password are treated as wildcard patterns, causing the connection to fail . If your password contains special characters, enclose the password within double quotes (the double quotes with ASCII Value 34).
  6. Click Test Connection, to ensure that you have successfully created a connection.
  7. Click Save.