dm-drogerie markt publishes its German online catalogue through a public MCP server: product search and per-product detail covering ingredients, nutrition, allergens, and usage. Connecting it to clariBI lets you pull live catalogue facts into an analysis without an account or a key.
Why connect dm
The dm catalogue is browsable on the web but awkward to query in bulk; pulling 50 products and comparing their dietary or ingredient attributes by hand is slow.
With dm connected, you can ask "Which vegan shampoos does dm list and what do they cost?", "Compare the nutrition facts across these protein bars", or "Which sunscreens are listed as fragrance-free?" and the AI engine reads the public catalogue live.
How the connection works
clariBI talks to dm through its hosted MCP server at https://mcp.dm.de/mcp. Authentication uses no authentication, because this is a public read-only endpoint. No credentials are sent or stored.
sequenceDiagram
actor U as You
participant C as clariBI
participant V as dm
U->>C: Click Authorize with dm
C->>V: Open OAuth authorization
V-->>U: Grant read access?
U->>V: Approve
V-->>C: Authorization code
C->>V: Exchange code for tokens
V-->>C: Access + refresh tokens
C->>C: Encrypt and store credentials
C-->>U: Connection ready
Available tools
clariBI exposes the read-only dm tools that the vendor's MCP server publishes at connection time. Write operations (create, update, delete, send, refund) are filtered out by a name-pattern blocklist before any tool reaches the analysis engine, so connecting dm cannot modify data on the vendor side.
The exact tool inventory depends on the dm features your account has access to. After connecting, try a few natural-language questions to see what dm data clariBI can pull.
Data flow during analysis
When you ask a question that maps to dm, the AI engine routes to the right tool, reads the result, and pairs the answer with a chart you can pin to a dashboard.
sequenceDiagram
actor U as You
participant C as clariBI
participant AI as AI engine
participant V as dm
U->>C: Ask a question about public retail catalogue data
C->>AI: Plan the analysis
AI->>V: Call the right tool
V-->>AI: Tool result
AI->>AI: Summarize and chart
C-->>U: Answer plus visual
Setting up the connection
- Open Data Sources in the clariBI sidebar.
- Click Add data source.
- Open the MCP Servers tab.
- Click the dm card.
- Click Authorize with dm.
- Sign in to dm in the popup window and grant the requested read scopes.
- Back in clariBI, give your data source a name.
- Click Finish.
Permissions and data access
This is a public, read-only MCP endpoint. No credentials are sent or stored: clariBI sends no login, token, or key, and dm asks for none. The connector reads the public product catalogue only (searching products and reading product details); it sees nothing about your dm account, basket, or orders, and cannot place or change anything. Disconnect anytime from Settings → Integrations in clariBI.
Troubleshooting
| Error | Cause | Fix |
|---|---|---|
| "A product is not found by ID" | The DAN or GTIN does not resolve in the dm catalogue, or only the product name was provided. | Search by name first to get the DAN, then request details by that identifier. |
| "No price or stock in the result" | The detail tool returns ingredients, nutrition, and usage, not live pricing or availability. | Use product search for price and listing fields; use product details for ingredient and nutrition facts. |