Comprehensive plugin for SAP Datasphere development with 3 specialized agents, 4 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 to SAP and third-party systems, managing spaces and users, implementing data access controls, using the datasphere CLI, creating data products for the marketplace, or monitoring data integration tasks. Covers Data Builder (graphical/SQL views, local/remote tables, transformation flows), Business Builder (business entities, consumption models), analytic models (dimensions, measures, hierarchies), 40+ connection types (SAP S/4HANA, BW/4HANA, HANA Cloud, AWS, Azure, GCP, Kafka, Generic HTTP), real-time replication, task chains, content transport, CLI automation, catalog governance, and data marketplace. Includes 2025 features: Generic HTTP connections, REST API tasks in task chains, SAP Business Data Cloud integration. Keywords: sap datasphere, data warehouse cloud, dwc, data builder, business builder, analytic model, graphical view, sql view, transformation flow, replication flow, data flow, task chain, remote table, local table, sap btp data warehouse, datasphere connection, datasphere space, data access control, elastic compute node, sap analytics cloud integration, datasphere cli, data products, data marketplace, catalog, governance
/plugin marketplace add secondsky/sap-skills/plugin install sap-datasphere@sap-skillsThis skill inherits all available tools. When active, it can use any tool Claude has access to.
README.mdreferences/administration.mdreferences/best-practices-patterns.mdreferences/catalog-governance.mdreferences/cli-commands.mdreferences/connectivity.mdreferences/content-transport.mdreferences/data-access-security.mdreferences/data-acquisition-preparation.mdreferences/data-integration-monitor.mdreferences/data-modeling.mdreferences/data-products-marketplace.mdreferences/graphical-sql-views.mdreferences/mcp-tools-reference.mdreferences/mcp-use-cases.mdreferences/whats-new-2025.mdSAP Datasphere is SAP's cloud-native data warehouse solution on SAP Business Technology Platform (BTP). This skill provides comprehensive guidance for data acquisition, preparation, modeling, administration, and integration.
Use this skill when:
| Component | Purpose | Key Objects |
|---|---|---|
| Data Builder | Data acquisition & preparation | Views, Tables, Flows, Task Chains |
| Business Builder | Semantic layer modeling | Business Entities, Fact Models, Consumption Models |
| Analytic Model | Analytics-ready structures | Dimensions, Facts, Measures, Hierarchies |
| Connections | External data sources | 40+ connection types |
| Spaces | Logical data containers | Storage, Users, Objects |
Views:
Tables:
Flows:
Create views visually by dragging sources and adding transformations.
Supported Operations:
Best Practices:
For detailed graphical view operations, see references/graphical-sql-views.md.
Create views using SQL or SQLScript.
-- Basic SQL View
SELECT
customer_id,
customer_name,
SUM(order_amount) AS total_orders
FROM orders
GROUP BY customer_id, customer_name
SQLScript Support:
For SQL/SQLScript reference, see references/graphical-sql-views.md.
ETL pipelines for data transformation and loading.
Operators:
Execution:
For data flow details, see references/data-acquisition-preparation.md.
Replicate data from source systems to Datasphere or external targets.
Supported Sources:
Supported Targets:
Load Types:
For replication flow configuration, see references/data-acquisition-preparation.md.
Delta-aware transformations with automatic change propagation.
Key Features:
For transformation flow details, see references/data-acquisition-preparation.md.
Orchestrate multiple tasks in sequence or parallel.
Supported Tasks:
Features:
Create analytics-ready semantic models for SAP Analytics Cloud.
Components:
Creating an Analytic Model:
For detailed modeling guidance, see references/data-modeling.md.
Categorize and filter analytical data.
Types:
Features:
Quantifiable values for analysis.
Types:
Aggregation Types:
For measure configuration, see references/data-modeling.md.
Create business-oriented semantic models.
Objects:
For Business Builder details, see references/data-modeling.md.
SAP Datasphere supports 40+ connection types.
SAP Systems:
Cloud Platforms:
Databases:
Streaming:
Other:
For connection configuration, see references/connectivity.md.
| Feature | Description |
|---|---|
| Remote Tables | Virtual data access |
| Data Flows | ETL transformation |
| Replication Flows | Data replication |
| Model Import | BW/4HANA model transfer |
Logical containers for data and objects.
Configuration:
Operations:
For space management, see references/administration.md.
Standard Roles:
Scoped Roles:
Authentication:
For user management, see references/administration.md.
Capabilities:
Database Analysis:
For monitoring details, see references/administration.md.
Operations:
Features:
Options:
For monitoring details, see references/data-integration-monitor.md.
The datasphere CLI enables command-line administration and automation.
Installation:
npm install -g @sap/datasphere-cli
Authentication:
# Interactive login
datasphere config auth login
# Service key (CI/CD)
datasphere config auth login --service-key-path ./key.json
Core Commands:
| Command | Purpose |
|---|---|
datasphere spaces list | List all spaces |
datasphere spaces create | Create a space |
datasphere objects export | Export objects |
datasphere objects import | Import objects |
datasphere tasks run | Execute task chains |
datasphere marketplace list | List marketplace products |
CI/CD Integration:
# Export and import workflow
datasphere objects export --space DEV --output-file package.zip
datasphere objects import --space PROD --input-file package.zip --overwrite
For complete CLI reference, see references/cli-commands.md.
Package curated data for internal or external consumption:
Product Components:
Discover and consume published data products:
For complete marketplace guidance, see references/data-products-marketplace.md.
Centralized discovery and governance:
Create Object → Add Metadata → Link Terms → Quality Check → Approve → Publish
Roles:
For detailed governance guidance, see references/catalog-governance.md.
Implement row-level security.
Types:
Application:
For security configuration, see references/data-access-security.md.
Move content between tenants.
Methods:
Package Contents:
For transport procedures, see references/content-transport.md.
| Error | Cause | Solution |
|---|---|---|
| Deployment failed | Circular dependency | Check object dependencies |
| Connection timeout | Network/firewall | Verify Cloud Connector/IP allowlist |
| Replication stuck | Source lock | Check source system status |
| Out of memory | Large view | Enable persistence or partitioning |
| Permission denied | Missing role | Verify space membership and privileges |
Core Data Builder:
references/data-acquisition-preparation.md - Data flows, replication flows, transformation flows, and table managementreferences/graphical-sql-views.md - Graphical views, SQL views, E-R models, and intelligent lookupsreferences/data-modeling.md - Business Builder entities, analytic models, dimensions, measures, and hierarchiesConnectivity & Integration:
4. references/connectivity.md - All 40+ connection types including SAP systems, cloud providers, and streaming platforms
5. references/data-integration-monitor.md - Task scheduling, monitoring, real-time replication, and delta mechanisms
Administration & Security:
6. references/administration.md - Tenant management, space configuration, user roles, and elastic compute nodes
7. references/data-access-security.md - Row-level security, DAC configurations, and authorization scenarios
8. references/content-transport.md - Package export/import, transport management, and tenant migration
CLI & Automation:
9. references/cli-commands.md - Complete CLI reference, authentication, CI/CD integration patterns
Marketplace & Governance:
10. references/data-products-marketplace.md - Creating and consuming data products, provider workflows, pricing
11. references/catalog-governance.md - Data catalog, glossary, quality rules, lineage, classification
Best Practices & Updates:
12. references/best-practices-patterns.md - Architecture patterns, naming conventions, performance optimization, checklists
13. references/whats-new-2025.md - Q1-Q4 2025 features, Generic HTTP, REST API tasks, deprecations
MCP Integration:
14. references/mcp-tools-reference.md - Complete MCP tool reference, 45 tools across 8 categories, API documentation, authentication patterns
15. references/mcp-use-cases.md - 8 real-world use cases with personas, time savings, and ROI analysis ($159K+/year savings)
This plugin includes 3 specialized agents, 4 slash commands, and validation hooks:
Agents (in agents/):
datasphere-modeler - Data Builder tasks, views, flows, analytic modelsdatasphere-integration-advisor - Connectivity, replication, data integrationdatasphere-admin-helper - Space management, security, monitoringCommands (in commands/):
/datasphere-space-template - Generate space configurations/datasphere-view-template - Generate view templates (graphical/SQL)/datasphere-connection-guide - Step-by-step connection setup/datasphere-cli - CLI command reference and examplesHooks (in hooks/):
This skill integrates with the SAP Datasphere MCP Server (@mariodefe/sap-datasphere-mcp) providing 45 tools for live tenant interaction.
The MCP server enables:
See /datasphere-mcp-tools command for complete tool list.
OAuth 2.0 Client Credentials with automatic token refresh.
Required environment variables:
DATASPHERE_BASE_URLDATASPHERE_CLIENT_IDDATASPHERE_CLIENT_SECRETDATASPHERE_TOKEN_URLplugins/sap-datasphere/
├── .claude-plugin/
│ └── plugin.json
├── .mcp.json # MCP server configuration
├── agents/
│ ├── datasphere-modeler.md
│ ├── datasphere-integration-advisor.md
│ └── datasphere-admin-helper.md
├── commands/
│ ├── datasphere-space-template.md
│ ├── datasphere-view-template.md
│ ├── datasphere-connection-guide.md
│ ├── datasphere-cli.md
│ └── datasphere-mcp-tools.md # MCP tools reference
├── hooks/
│ └── hooks.json
└── skills/
└── sap-datasphere/
├── .claude-plugin/
│ └── plugin.json
├── SKILL.md
├── README.md
└── references/
├── data-acquisition-preparation.md
├── data-modeling.md
├── graphical-sql-views.md
├── connectivity.md
├── administration.md
├── data-integration-monitor.md
├── data-access-security.md
├── content-transport.md
├── cli-commands.md
├── data-products-marketplace.md
├── catalog-governance.md
├── best-practices-patterns.md
├── whats-new-2025.md
└── mcp-tools-reference.md # MCP technical reference
Version: 2.1.0 | Last Verified: 2025-12-28
This skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
This skill should be used when the user asks to "create an agent", "add an agent", "write a subagent", "agent frontmatter", "when to use description", "agent examples", "agent tools", "agent colors", "autonomous agent", or needs guidance on agent structure, system prompts, triggering conditions, or agent development best practices for Claude Code plugins.
This skill should be used when the user asks to "create a hook", "add a PreToolUse/PostToolUse/Stop hook", "validate tool use", "implement prompt-based hooks", "use ${CLAUDE_PLUGIN_ROOT}", "set up event-driven automation", "block dangerous commands", or mentions hook events (PreToolUse, PostToolUse, Stop, SubagentStop, SessionStart, SessionEnd, UserPromptSubmit, PreCompact, Notification). Provides comprehensive guidance for creating and implementing Claude Code plugin hooks with focus on advanced prompt-based hooks API.