datasphere-admin

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:

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

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

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

Catalog & Discovery Tools

Data Quality & Analysis Tools

Database User Management Tools

MCP Server Setup

To use MCP tools, configure Claude Desktop (~/Library/Application Support/Claude/claude_desktop_config.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.