Configure an Oracle connection

Who can use this feature?

A connection is an authentication mechanism to allow Totango to integrate with another system. Each connector has different requirements for connection. You can reuse connections to support multiple integration jobs. 

Data warehouse integrations are a closed system; you cannot reuse data warehouse connections for other integration families. 

Create an Oracle connection in Totango 

To set up a connection to an Oracle database, you can choose between two types of connections: SID (System Identifier) or Service Name, depending on your database configuration. Both connection types are supported by the connector.

  • SID: Use this option if you are connecting to a specific Oracle database instance. This type of connection is typically used when you know the exact instance you want to interact with.
  • Service Name: This option is useful in environments where multiple databases are managed as a group, and you want to connect to a specific service that can be handled by one or more instances. This is commonly used in larger, more complex database environments.
  1. In Totango, click Settings from the left nav.
  2. Expand Data Management > Customer Data Hub.
  3. From the list of active connectors (left), choose Data Warehouses.
  4. From the list of available connectors, hover over Oracle, and click Connect (or View Integrations).
  5. Choose the connection type for how you want to connect to the Oracle database.
    • SID (System Identifier): The unique name that identifies a specific Oracle database instance.
    • Service Name: An alias for a database that can provide additional services, often used in large environments.

  6. Enter a name and description for the connection. Because you can have multiple connections with a connector (using different authentication profiles), a name and description helps you identify the connection later.
  7. Add the remaining details for the connection:
    • SID/ Service Name: Enter either the SID or the Service Name of the database, depending on the option you selected in the "Connection Type" field.
    • Host name: Host name or IP address of the Oracle database server (e.g., db.example.com or 192.168.1.100).
    • Port: Port that the Oracle database is listening on. Usually the port for Oracle DB is 1521.
    • Username: Username that will be used to connect to the Oracle database.
    • Password: Password of the associated username. Be sure to store your credentials securely.
  8. Click Connect.

You can now set up an integration using the connection.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request