- Create a new database connection
- resource_admin
Creates a new database connection for the specified team
| Enum Value | Description |
|---|---|
| postgres_basic_auth | Username and password for PostgreSQL database connection |
| mysql_basic_auth | Username and password for MySQL database connection |
The infrastructure orchestrator to associate with this database connection
- postgres_basic_auth
- mysql_basic_auth
- Create PostgreSQL database connection
- Create MySQL database connection
curl -i -X POST \
'https://{org_name}.pam.okta.com/v1/teams/{team_name}/connections/databases' \
-H 'Authorization: Bearer <YOUR_JWT_HERE>' \
-H 'Content-Type: application/json' \
-d '{
"name": "Production PostgreSQL",
"description": "Primary production database",
"auth_type": "postgres_basic_auth",
"auth_details": {
"_type": "postgres_basic_auth",
"username": "admin_user",
"host": "db.example.com",
"port": 5432,
"password_jwe": "eyJhbGciOiJSU0EtT0FFUC0yNTYiLCJlbmMiOiJBMjU2R0NNIn0..."
},
"infrastructure_orchestrator": {
"id": "550e8400-e29b-41d4-a716-446655440000"
}
}'Created
| Enum Value | Description |
|---|---|
| postgres_basic_auth | Username and password for PostgreSQL database connection |
| mysql_basic_auth | Username and password for MySQL database connection |
A UTC timestamp that indicates when the database connection was created
The UUID of the database connection
A UTC timestamp that indicates when the last discovery scan was performed
A UTC timestamp that indicates when the status was last changed
| Enum Value | Description |
|---|---|
| active | The connection is healthy and operational |
| warning | The last management tasks failed with soft errors, such as temporary network or permission issues |
| failed | The connection experienced an unrecoverable error such as invalid credentials or misconfiguration |
| marked_for_deletion | The connection has been marked for deletion and is pending cleanup |
A UTC timestamp that indicates when the database connection was last updated
- postgres_basic_auth
- mysql_basic_auth
- PostgreSQL database connection response
- MySQL database connection response
{ "id": "a747a818-a4c4-4446-8a87-704216495a08", "name": "Production PostgreSQL", "description": "Primary production database", "auth_type": "postgres_basic_auth", "auth_details": { "_type": "postgres_basic_auth", "username": "admin_user", "host": "db.example.com", "port": 5432 }, "status": "active", "last_status_change_at": "2024-01-15T10:30:00Z", "last_discovery_run_at": "2024-01-15T11:00:00Z", "created_at": "2024-01-01T00:00:00Z", "updated_at": "2024-01-15T10:30:00Z", "infrastructure_orchestrator": { "id": "550e8400-e29b-41d4-a716-446655440000", "name": "rg-1" } }