Sign inGet started
Docs
Get started

Oracle DB API Authentication

How to authenticate Oracle DB API requests: one Bearer API key plus a connectionId. MindCloud handles Oracle DB's custom auth scheme for you.

Every Oracle DB API request through MindCloud needs two things: a MindCloud API Key and a connectionId for your Oracle DB account. This page covers both, plus exactly how to send them, so you do not need to visit any other page to get authenticated.

Steps to authenticate

  1. Create a MindCloud account at app.mindcloud.co if you do not already have one.
  2. Generate a MindCloud API Key in API Keys. This is the Bearer token you send on every request. Keep it on your server.
  3. Create a Oracle DB connection in Connections. Oracle DB uses its own authentication scheme. You provide whatever it requires when you create the connection — MindCloud handles the provider-specific details for you.
  4. Copy the connection’s connectionId — you will send it on every request alongside your MindCloud API Key.

How requests are authenticated

Authentication has two layers. Your MindCloud API Key authenticates the request to MindCloud, sent as a Bearer token in the Authorization header. The connectionId selects the connected Oracle DB account that should run the action. MindCloud stores and refreshes the Oracle DB credentials behind that connection, so you never send provider tokens with your requests.

Pass connectionId in the query string for GET and DELETE actions, and in the JSON body for POST, PUT, and PATCH actions.

For example, calling with an Oracle DB connection looks like this:

The Authorization: Bearer <your MindCloud API Key> header authenticates you to MindCloud; the connectionId tells MindCloud which Oracle DB account to run the action against. Missing or invalid Authorization returns 401, and a missing or mismatched connectionId returns 400.

Connect Oracle DB Legacy

Ask your database administrator for the Oracle host, port, username, password, and either the SIDA SID is an Oracle database instance identifier used in one legacy connection URL format. or the Service NameA service name is an Oracle database service identifier used in the service-name connection URL format. for the database you want to query.

  1. Get the database connection details

    Confirm the Host, Port, Username, Password, and whether your database uses SIDA SID is an Oracle database instance identifier used in one legacy connection URL format. or Service NameA service name is an Oracle database service identifier used in the service-name connection URL format..

  2. Fill in the connection form

    Enter Host, Port, Username, and Password, then fill in exactly one of SIDA SID is an Oracle database instance identifier used in one legacy connection URL format. or Service NameA service name is an Oracle database service identifier used in the service-name connection URL format..

  3. Save and test the connection

    Run the Test Connection action after the Oracle DB Legacy runner is deployed and allowed through the database network rules.

Keep your key safe

Keep your MindCloud API Key on your server; do not ship it in browser code, mobile apps, public repositories, or logs. Anyone with the key can call the Universal API as your MindCloud account, across every connection you have created.