Skip to content
Skills Library
Data & analytics · Planning

datasphere-admin

/datasphere-admin

SAP Datasphere system administration skill for managing spaces, users, roles, security, monitoring, and transport operations. Use when performing administrative tasks including creating/managing spaces, user management, role assignment, system monitoring, capacity planning, or transport package operations.

Licence
MIT
Last repository change
08.05.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
5
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 08.05.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

SAP Datasphere system administration skill for managing spaces, users, roles, security, monitoring, and transport operations. Use when performing administrative tasks including creating/managing spaces, user management, role assignment, system monitoring, capacity planning, or transport package operations.

Original author description

SAP Datasphere system administration skill for managing spaces, users, roles, security, monitoring, and transport operations. Use when performing administrative tasks including creating/managing spaces, user management, role assignment, system monitoring, capacity planning, or transport package operations.

How it works

  1. Navigation Overview
  2. Space Management
  3. Security Administration
  4. System Monitoring
  5. Transport Operations
  6. System Administration
  7. Common Administrative Workflows
  8. MCP Tools Integration
  9. Resources
  10. What's New (2026.05)
Original SKILL.md headings · 294 lines, 1,506 words
SKILL.md preview
---
name: datasphere-admin
description: SAP Datasphere system administration skill for managing spaces, users, roles, security, monitoring, and transport operations. Use when performing administrative tasks including creating/managing spaces, user management, role assignment, system monitoring, capacity planning, or transport package operations.
---

# SAP Datasphere Administrator

Comprehensive administration skill for SAP Datasphere covering space management, security configuration, system monitoring, and transport operations.

## Navigation Overview

SAP Datasphere uses a left-side navigation menu. Administrative functions are located in the lower section:

| Menu Item | Submenu Items | URL Fragment |
|-----------|---------------|--------------|
| Space Management | (direct) | `#/managespaces` |
| Security | Users, Roles, Authorization Overview, Activities | `#/users`, `#/roles` |
| Transport | Packages, Export, Import, Monitor | `#/repository_packages` |
| System Monitor | System Monitor, Capacities | `#/monitoring` |
| System | Configuration, Administration, About | `#/administration` |

## Space Management

**Navigation:** Left Menu → Space Management

### View All Spaces
1. Click **Space Management** in left navigation
2. View space cards showing: Name, Status (Cold/Warm), Disk Storage, Memory Storage
3. Toggle between tile/list view using icons in top-right toolbar

### Create a New Space
1. Navigate to Space Management
2. Click **Create** button (top toolbar) OR click **+** on Spaces card from Home
3. Fill in space details:
   - Business Name (display name)
   - Technical Name (system identifier)
   - Storage allocation (Disk and Memory quotas)
4. Click **Create**

### Edit Space Properties
1. Navigate to Space Management
2. Locate the space card
3. Click **Edit** button on the card
4. Modify: Storage quotas, Members, Properties
5. Save changes

### Space Status Management
- **Lock/Unlock:** Select space → Click Lock/Unlock in toolbar
- **Monitor:** Select space → Click Monitor to view space-specific metrics
- **Delete:** Select space → Click Delete (moves to Recycle Bin)

### Recycle Bin
- Access via left panel in Space Management
- Restore or permanently delete spaces

## Security Administration

**Navigation:** Left Menu → Security → [submenu]

### User Management
**Path:** Security → Users (`#/users`)

#### View Users
1. Navigate to Security → Users
2. Use Filter By panel to filter by: Role Name, Scope Name, License Type
3. Results show: User ID, Display Name, First Name, Last Name, Email, Roles count

#### Add New User
1. Click **+** (Add) button in toolbar
2. Enter user details
3. Assign roles
4. Save

#### Edit User
1. Select user row
2. Click Edit icon
3. Modify user properties and role assignments
4. Save

### Role Management
**Path:** Security → Roles (`#/roles`)

#### Standard Roles
| Role | Description |
|------|-------------|
| Data Warehouse Cloud Space Administrator | Full space privileges |
| Data Warehouse Cloud Integrator | Full data integration privileges |
| Data Warehouse Cloud Modeler | Modeling privileges |
| Data Warehouse Cloud Viewer | View-only access |
| Data Warehouse Cloud Consumer | Data consumption privileges |
| Data Warehouse Cloud Extended Viewer | Extended viewer privileges |
| Data Catalog Administrator | Full catalog privileges |
| Data Catalog User | Read catalog privileges |

#### Scoped Roles
Scoped roles limit permissions to specific spaces. Naming pattern: `Scoped Data Warehouse Cloud [Role Type]`

#### Create Custom Role
1. Navigate to Security → Roles
2. Click **+** button
3. Define role name and description
4. Configure permissions
5. Save

### Authorization Overview
**Path:** Security → Authorization Overview

View consolidated authorization matrix across users, roles, and spaces.

### Activities Log
**Path:** Security → Activities

Monitor user activities and audit trail.

## System Monitoring

**Navigation:** Left Menu → System Monitor → [submenu]

### Dashboard
**Path:** System Monitor → System Monitor (`#/monitoring`)

**Tabs available:**
- Dashboard (default)
- Elastic Compute Nodes
- Task Logs
- Statement Logs
- Object Store

**Dashboard Metrics:**
- Disk Storage Used (pie chart breakdown)
- Disk Used by Spaces for Storage
- Memory Used by Spaces for Storage
- Failed Tasks (Last 24 Hours)
- Out-of-Memory Errors
- Top 5 Out-of-Memory Errors by Space
- Admission Control Events

### Capacities
**Path:** System Monitor → Capacities

View and manage compute capacity allocation.

### Task Logs
1. Navigate to System Monitor → System Monitor
2. Click **Task Logs** tab
3. Filter by: Space, Task Type, Status, Date Range
4. View execution details and errors

### Statement Logs
1. Navigate to System Monitor → System Monitor
2. Click **Statement Logs** tab
3. Analyze SQL statement execution

## Transport Operations

**Navigation:** Left Menu → Transport → [submenu]

### Packages
**Path:** Transport → Packages (`#/repository_packages`)

#### View Packages
1. Navigate to Transport → Packages
2. Filter by Space using dropdown
3. View: Business Name, Technical Name, Space, Created On, Result

#### Create Package
1. Click **+** button
2. Select space and objects to include
3. Define package name
4. Save

### Export
**Path:** Transport → Export

Export packages for deployment to other systems.

### Import
**Path:** Transport → Import

Import packages from other Datasphere instances.

### Transport Monitor
**Path:** Transport → Monitor

Track transport operation status and history.

## System Administration

**Navigation:** Left Menu → System → Administration (`#/administration`)

### Configuration Tabs
| Tab | Purpose |
|-----|---------|
| System Configuration | Session timeout, SAP support access |
| Tenant Links | External system links |
| Data Source Configuration | Data source settings |
| Security | Security policies |
| App Integration | Third-party integrations |
| Notifications | Alert and notification settings |

### System Configuration
1. Navigate to System → Administration
2. On System Configuration tab:
   - Set **Session Timeout** (default: 3600 seconds)
   - Toggle **Allow SAP support user creation**
3. Click Edit to modify, Save to confirm

## Common Administrative Workflows

### Onboard New Team Member
1. Security → Users → Add user
2. Assign appropriate roles (e.g., Data Warehouse Cloud Modeler)
3. Space Management → Edit space → Add member to relevant space(s)
4. Configure scoped roles if needed

### Capacity Planning
1. System Monitor → Dashboard → Review storage metrics
2. System Monitor → Capacities → Assess compute allocation
3. Space Management → Edit spaces to adjust quotas as needed

### Troubleshoot Failed Tasks
1. System Monitor → Task Logs → Filter by Failed status
2. Review error details
3. Check Statement Logs for SQL-level issues
4. Review Out-of-Memory metrics if relevant

## MCP Tools Integration

When the SAP Datasphere MCP Server is connected (via Claude Desktop), the following tools are available for programmatic administration:

### Foundation Tools
| Tool | Description |
|------|-------------|
| `test_connection` | Verify connectivity to Datasphere tenant |
| `get_current_user` | Get current authenticated user info |
| `get_tenant_info` | Get tenant configuration details |
| `list_spaces` | List all available spaces |

### Catalog & Discovery Tools
| Tool | Description |
|------|-------------|
| `list_catalog_assets` | Browse catalog assets |
| `get_asset_details` | Get detailed asset metadata |
| `search_catalog` | Search for assets by criteria |
| `find_assets_by_column` | Find assets containing specific columns |

### Data Quality & Analysis Tools
| Tool | Description |
|------|-------------|
| `smart_query` | Intelligent data querying |
| `query_analytical_data` | Query analytical models |
| `query_relational_entity` | Query relational tables/views |
| `analyze_column_distribution` | Analyze data distribution |

### Database User Management Tools
| Tool | Description |
|------|-------------|
| `list_database_users` | List database users in a space |
| `create_database_user` | Create new database user |
| `get_database_user_details` | Get user configuration |
| `update_database_user` | Modify user settings |
| `delete_database_user` | Remove database user |

### MCP Server Setup
To use MCP tools, configure Claude Desktop (`~/Library/Application Support/Claude/claude_desktop_config.json`):
```json
{
  "mcpServers": {
    "sap-datasphere": {
      "command": "/path/to/start_sap_datasphere_mcp.sh",
      "args": []
    }
  }
}
```

## Resources

See reference files for detailed procedures:
- `references/space-management.md` - Detailed space operations
- `references/security-governance.md` - Security configuration details
- `references/system-monitoring.md` - Monitoring and troubleshooting
- `references/transport.md` - Transport lifecycle management

## What's New (2026.05)

- **Critical Storage Threshold — Automatic Space Locking**: To protect tenant stability, Datasphere will now automatically lock ALL spaces when disk usage reaches a critical threshold. A message appears in the Space Management app and on each space page. To unlock and resume work, you must either increase tenant disk storage or delete unneeded data. This is a critical operational consideration — monitor disk usage proactively and set up alerts before reaching the threshold.
- **Installing Intelligent Applications for Multiple Source Systems**: If your Datasphere is part of a Business Data Cloud formation, you can now install a single intelligent application multiple times for different source systems. Each source system creates (or reuses) its own ingestion space, with source-specific preparation and application spaces identified by an alias.

## What's New (2026.10)

- **Bulk schedule owner reassignment for Task Chains** — you can now assign a single owner to multiple scheduled task chains at once, instead of editing each chain's schedule individually. Use this when:
  - Someone leaves the team and you need to reparent dozens of nightly jobs.
  - You want to consolidate operational responsibility under a single service account.
  - You're handing operations from a build team to a run team after go-live.
  Help link: "Modify the Owner of a Schedule" (`4b660c0395454bd0923f732eef4ee4b2.html`).
- **OData consumption URL reminder**: the legacy prefix `/api/v1/dwc/consumption/` is **deprecated** and will be discontinued in a future release. Audit any homegrown integrations (curl scripts, Postman collections, third-party connectors) and migrate to `/api/v1/datasphere/consumption/...`. The path otherwise is identical.
Files in this package (5)
  • SKILL.md 10 KB
  • references/security-governance.md 4 KB
  • references/space-management.md 4 KB
  • references/system-monitoring.md 4 KB
  • references/transport.md 5 KB

Versions

The database has no other skills named datasphere-admin.

Database snapshot: 13.11.2026 · package version 4c24ffd8efac (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 95sap-datasphere
    SAP Datasphere development skill with 3 specialized agents, 5 slash commands, and validation hooks. Use when building data warehouses on SAP BTP, creating analytic models, configuring data flows and replication flows, setting up connections, managing spaces and users,…
  • 81Transport Manager
    Move objects between Datasphere tenants using transport packages. Use when migrating objects from Dev to QA/Prod, managing versions, handling dependencies, or integrating SAP Content Network packages. Keywords: transport, package, export, import, CSN, JSON, dev qa prod,…
  • 100datasphere-explorer
    SAP Datasphere exploration and discovery assistant. Guides users through understanding their Datasphere landscape — browsing spaces, discovering data assets in the catalog, inspecting table schemas, profiling data quality, tracing lineage, and building queries interactively. Use…
  • 91sap-sac-planning
    SAP Analytics Cloud (SAC) planning guidance for planning models, planning-enabled stories, data actions, multi actions, version management, data locking, calendar/input workflows, allocations, value driver trees, BPC live planning, and Seamless Planning with SAP Datasphere. Use…
  • 90clean-core-data
    Use this skill when the user asks questions about SAP Clean Core Data — including what clean core data is, the five data pillars (data strategy, data governance, data quality, data volume efficiency, data protection), master data management with SAP Master Data Governance, data…
  • 100sac-excel-addin
    Use for SAP Analytics Cloud, add-in for Microsoft Excel (SAC Excel add-in): writing, converting or debugging SAP.* formulas (SAP.GETDATA, SAP.SETDATA, SAP.GETDIMENSIONFILTER, SAP.OVERWRITEDIMENSIONFILTER, SAP.MEMBERPROPERTY, SAP.GETVARIABLES, SAP.TIMEOFFSET,…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.