Update database connection to a project (for Oracle environments only)

Available in versions: 2021 R2 and later

Description

For Oracle environments only: Updates the connection to the database for a specific project.

URL

Copy code
/Admin/rest/v1/projects/changeprojectdbconnection

Remarks

None

HTTP Method

POST: Updates the connection to the Oracle database for a project.

Request

Headers:

Content-Type: application/xml

Accept: application/json, application/xml

Cookies:

LWSSO_COOKIE_KEY={LwssoCookie};

Request Body:

An XML describing the project and other optional details.

The fields in the request are:

ElementDescription
SchemaCredentialsDetails
  • ProjectId. The ID of the project for which the Oracle database connection should be tested (it can be retrieved from the Get Projects REST API). The Lab schema is considered as a particular project with ProjectId=1.

  • Password. The password to use to test the connection in plain text. You can provide a Base64 encrypted value for the password if it is prefixed with “{a3f701a2-475d-4fe3-89f3-cc7db85a272c}:” (without the quotes), and then encrypted with the prefix.

Response

Headers:

None

Cookies:

None

HTML Return Code:

One of the HTTP Return Codes.

HTML Body:

No body returned.

See Also

Get Projects
Create a project
Returns or update a project by ID
Get projects by Query
Remove Projects
Test database connection to a project (for Oracle environments only)