Connector guide2-minute read6 MCP toolsEN · DE · IT

How to Connect Sage 100 (DE) to Gemini — via MCP

Sage 100 German Mittelstand ERP over the Sage 100 Web API (OData): addresses, items, sales documents and stock on your own installation. Basic auth. Partner credentials and an activated Web API required.

HCBy HelpCode teamUpdated 2 min read Open-source on GitHub

No credit card · 7-day trial · Self-host alternative available

Sage 100 (DE)

Sage 100 (DE)

Sage 100 German Mittelstand ERP over the Sage 100 Web API (OData): addresses, items, sales documents and stock on your own installation. Basic auth. Partner credentials and an activated Web API required.

tools

6

Region

DE

Category

ERP

Authentication

Basic Auth

Required env vars

SAGE100_URLSAGE100_COMPANYSAGE100_USERNAMESAGE100_PASSWORD
Install in one click on Cloud

7-day free trial · No credit card

  • 7-day free trial
    No credit card required
  • GDPR & SOC 2 ready
    EU data residency, audit logs
  • Open-source on GitHub
    Open source · AGPL-3.0
  • Works with ChatGPT, Claude, Gemini
    Any MCP-compatible client

Skip the install. Get this working in under 2 minutes.

Start a free trial on cloud.anythingmcp.com, add the Sage 100 (DE) in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.

Start free trial

Summary

Sage 100 German Mittelstand ERP over the Sage 100 Web API (OData): addresses, items, sales documents and stock on your own installation. Basic auth. Partner credentials and an activated Web API required.

Try asking

Example prompts for Sage 100 (DE)

Click any prompt to copy it. Paste into Claude, ChatGPT, Cursor, Gemini, Copilot or OpenClaw to run it against this connector.

Sage 100 (DE) · live via MCP
Share
Opus 4.7

Claude is AI and can make mistakes. Please double-check responses.

💡 No install? Use cloud.anythingmcp.com directly. Sign in, click Connectors → Sage 100 (DE), paste your credentials, mint an MCP API key — done. No Docker, no git clone, no local server.

Sage 100 (DE) + Gemini

Sage 100 German Mittelstand ERP over the Sage 100 Web API (OData): addresses, items, sales documents and stock on your own installation. Basic auth. Partner credentials and an activated Web API required.

Prerequisites

See the full setup instructions baked into the connector (visible in the in-app store when you select the connector). The required environment variables for this connector are:

SAGE100_URL, SAGE100_COMPANY, SAGE100_USERNAME, SAGE100_PASSWORD

Step 1 — Get credentials

Partner credentials required, and the Web API is a separate component. Sage 100 (the German product, not Sage 100cloud US) does not expose HTTP out of the box. The Sage 100 Web API / OData service has to be installed and licensed on your application server, and Sage distributes the developer documentation through its partner portal rather than publicly. Talk to your Sage partner before wiring this up.

…(continued in the in-app connector instructions)

Step 2 — Install the adapter

curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d

Step 3 — Add the connector in Gemini

Gemini CLI reads MCP servers from ~/.gemini/settings.json (or %APPDATA%\gemini\settings.json on Windows). Add:

{
  "mcpServers": {
    "anythingmcp": {
      "httpUrl": "https://cloud.anythingmcp.com/mcp",
      "headers": { "Authorization": "Bearer YOUR_MCP_API_KEY" }
    }
  }
}
  1. Get your MCP API key from AnythingMCP → Profile → MCP API Keys → New Key.
  2. Save the file and restart gemini.
  3. Run /mcp inside the Gemini CLI — Sage 100 (DE) should be listed as available.
  4. Vertex AI Studio: pass https://cloud.anythingmcp.com/mcp to the tools array of your request with the same Bearer header.

Available tools

ToolWhat it does
sage_100_get_metadataRead the OData $metadata document: every entity set this installation publishes and the fields on each
sage_100_queryQuery any published entity set with OData
sage_100_get_by_keyRead one record from an entity set by its OData key, with the navigation properties you name expanded
sage_100_list_addressesList addresses (Adressen) — Sage 100's customers and suppliers — with their number, matchcode, name and city
sage_100_list_itemsList items (Artikel) from the article master with their number, description, unit and price
sage_100_list_documentsList sales and purchase documents (Belege) with their type, number, date, address and total

FAQ

Does Gemini 1.5 Pro or 2.x support MCP? Yes — Gemini CLI ≥ 0.4 and Vertex AI tools API both accept MCP httpUrl connectors with Bearer headers.

Next steps

Was this guide helpful?

Your Sage 100 agent is one click away.

Install the connector, paste the key, prompt Gemini. Free for 7 days, no credit card.

Related guides

connectors

How to Connect Sage 100 (DE) to ChatGPT — via MCP

Sage 100 German Mittelstand ERP over the Sage 100 Web API (OData): addresses, items, sales documents and stock on your own installation. Basic auth. Partner credentials and an activated Web API required.

connectors

How to Connect Sage 100 (DE) to Claude — via MCP

Sage 100 German Mittelstand ERP over the Sage 100 Web API (OData): addresses, items, sales documents and stock on your own installation. Basic auth. Partner credentials and an activated Web API required.

connectors

How to Connect Sage 100 (DE) to Cursor — via MCP

Sage 100 German Mittelstand ERP over the Sage 100 Web API (OData): addresses, items, sales documents and stock on your own installation. Basic auth. Partner credentials and an activated Web API required.

connectors

Sage 100 (DE) to MCP — Drive Sage 100 (DE) from any AI Agent

Sage 100 German Mittelstand ERP over the Sage 100 Web API (OData): addresses, items, sales documents and stock on your own installation. Basic auth. Partner credentials and an activated Web API required.

connectors

How to Connect AFAS Profit to Gemini — via MCP

AFAS Profit — Dutch ERP and HR: read any published GetConnector, list what is available, and inspect a connector's metadata. Token auth with AFAS's base64-wrapped XML token.

connectors

How to Connect Aruba Fatturazione Elettronica to Gemini — via MCP

Aruba Fatturazione Elettronica: send and track Italian e-invoices through the Sistema di Interscambio, read received invoices and their SDI notifications. Token auth against Aruba's B2B gateway.