Skip to content
Oracle Autonomous DB Spoke › Integration Hub spokes › Build integrations › Integration Hub › Workflow Data Fabric
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Set up the Oracle Autonomous DB spoke

Integrate the ServiceNow instance and Oracle Autonomous DB by using the credentials to authenticate ServiceNow requests.

Before you begin

  • Request an Integration Hub subscription.
  • Activate and set up the Oracle Cloud IAM Spoke.
  • Activate the Oracle Autonomous DB spoke.
  • Role required: admin.

Create a credential record for the Oracle Cloud IAM spoke

Create a credential record for the Oracle Cloud IAM account. The Oracle Cloud IAM spoke connection and credential alias uses these credentials to authorize actions.

Before you begin

Use the public key from the Java Keystore (JKS) file and generate a fingerprint from your Oracle Cloud account. For more information about fingerprint, see Required Keys and OCIDs.

Role required: admin.

Procedure

  1. Navigate to All > Connections & Credentials > Credentials.

  2. Click New.

    The system displays this message: What type of Credentials would you like to create?

  3. Select OCI SHA256WithRSA Signature.

  4. On the form, fill these values.

    FieldDescription
    NameName to uniquely identify the record. For example, Oracle IAM Cloud Cred.
    Certificate Sys IDSys ID of the OCI Signing Certificate.
    AliasAlias of the KeyStore.
    Alias PasswordAlias password of the KeyStore.
    Key IDKey ID helps identify which key is used when multiple keys are used to sign tokens. The Key ID must be slash (/) separated values of Tenancy OCID, User OCID, and Fingerprint in this format: ocid1.tenancy.oc1..<unique_ID>/ocid1.user.oc1..<unique_ID>/<key_fingerprint>.
    Applies toOption to specify if the credential applies to all MID Servers in the network.
    ActiveOption to actively use the credential record.
    Authentication AlgorithmCustom authentication algorithm for outbound signing requests. Select OCI SHA256RSA Signing Algorithm

  5. Right-click the form header and click Submit.

Create a connection record for the Oracle Cloud IAM spoke

Create a connection record for your Oracle Cloud IAM account. The Oracle Cloud IAM spoke connection and credential aliases use these connections to perform actions in Oracle Cloud IAM.

Before you begin

Role required: admin.

Procedure

  1. Navigate to All > Connections & Credentials > Connections & Credentials Aliases.

  2. Open the alias record for OracleIAM_credentialANDconnecton.

  3. From the Connections tab, click New.

  4. On the form, fill these fields.

    FieldDescription
    NameName to uniquely identify the record. For example, Oracle IAM conn.
    CredentialCredential record created for Oracle Autonomous DB spoke. For example, Oracle IAM Cred.
    Connection aliasAlias record associated with this connection. Search and select sn_oci_iam_spoke.OracleIAM_credentialAN
    HostFully qualified domain name of the target host where the Oracle Cloud IAM server is hosted. For example, database.ap-mumbai-1.oraclecloud.com .
    Connection URLBase URL to connect to Oracle Cloud IAM. For example, https://database.ap-mumbai-1.oraclecloud.com.
    ActiveOption to actively use the connection record.
    DomainDomain that the action runs in.
    Override default portTarget port used by the connection. If blank, the system uses the default port.
    Use MID serverOption to use a MID Servers for this connection. If the check box is selected, define the fields in the Advanced MID Server Configuration related list.

  5. Click Submit.

Create a credential record for the Oracle Autonomous DB spoke

Create a credential record for the Oracle Autonomous DB account. The Oracle Autonomous DB spoke connection and credential alias uses these credentials to authorize actions.

Before you begin

Role required: admin.

Procedure

  1. Navigate to All > Connections & Credentials > Credentials.

  2. Click New.

    The system displays this message: What type of Credentials would you like to create?

  3. Select OCI SHA256WithRSA Signature.

  4. On the form, fill these values.

    FieldDescription
    NameName to uniquely identify the record. For example, Oracle IAM Cloud Cred.
    Certificate Sys IDSys ID of the OCI Signing Certificate.
    AliasAlias of the KeyStore.
    Alias PasswordAlias password of the KeyStore.
    Key IDKey ID (kid) helps identify which key is used when multiple keys are used to sign tokens. The Key ID must be slash (/) separated values of Tenancy OCID, User OCID, and Fingerprint in this format: ocid1.tenancy.oc1..<unique_ID>/ocid1.user.oc1..<unique_ID>/<key_fingerprint>.
    Applies toOption to specify if the credential applies to all MID Servers in the network.
    ActiveOption to actively use the credential record.
    Credential aliasAssociated credential record. If you have already created a credential alias, search and select the record.
    Authentication AlgorithmCustom authentication algorithm for outbound signing requests. Select OCI SHA256RSA Signing Algorithm

  5. Right-click the form header and click Submit.

Create a connection record for the Oracle Autonomous DB spoke

Create a connection record for your Oracle Autonomous DB account. The Oracle Autonomous DB spoke connection and credential aliases use these connections to perform actions in Oracle Autonomous DB.

Before you begin

Role required: admin.

Procedure

  1. Navigate to All > Connections & Credentials > Connections & Credentials Aliases.

  2. Open the alias record for Oracle Autonomous Database.

  3. From the Connections tab, click New.

  4. On the form, fill these fields.

    FieldDescription
    NameName to uniquely identify the record. For example, Oracle Auto DB Connection.
    CredentialCredential record created for Oracle Autonomous DB spoke. For example, Oracle ADB Creds.
    Connection aliasAlias record associated with this connection. Search and select sn_oci_adb_spoke.Oracle_Autonomous_Database
    HostFully qualified domain name of the target host where the Oracle Autonomous DB server is hosted. For example, database.ap-mumbai-1.oraclecloud.com .
    Connection URLBase URL to connect to Oracle Autonomous DB. For example, https://database.ap-mumbai-1.oraclecloud.com.
    ActiveOption to actively use the connection record.
    DomainDomain that the action runs in.
    Override default portTarget port used by the connection. If blank, the system uses the default port.
    Use MID serverOption to use a MID Servers for this connection. If the check box is selected, define the fields in the Advanced MID Server Configuration related list.

  5. Click Submit.