Microsoft Dynamics GP Connector

Microsoft Dynamics GP is on premises accounting and ERP software for mid sized businesses.

4.8 on G2
Weld · Data Sources
Image not found!
Live
Pick the tables to sync, and they appear here with their status.
Lands insnowflakebigquerydatabricksQueryable over MCP
How it works

Set up in minutes.
No code, no maintenance.

Microsoft Dynamics GP

Microsoft Dynamics GP

Data source

Authenticating...
Ready to connect
Overview

Microsoft Dynamics GP in your warehouse.
Ready for your agents.

Microsoft Dynamics GP is on premises accounting and ERP software for mid sized businesses. Weld's Microsoft Dynamics GP connector is fully managed: it extracts data from Microsoft Dynamics GP, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Weld MCP server

Ask your agent.
It can reach Microsoft Dynamics GP.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It finds the Microsoft Dynamics GP tables Weld has synced and queries your warehouse.

  • DiscoverSynced tables, columns and freshness
  • QuerySQL against your warehouse
  • OperateCheck, rerun and refresh syncs
Claude CodeOpus 5
>

Which Microsoft Dynamics GP tables do we have, and which one is the largest?

Looking up what the Microsoft Dynamics GP connection has synced.

●weld·search_available_references
⎿raw.microsoft_dynamics_gp.*
tables, columns and freshness
●weld·get_reference_schema
⎿columns, types and nullability
●weld·run_query
⎿select count(*) from {{raw.microsoft_dynamics_gp.…}}
submitted
●weld·get_query_status
⎿DONE
●weld·get_query_result
⎿rows returned
✓Answered from Microsoft Dynamics GP data in your warehouse
>Ask about your Microsoft Dynamics GP data
Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Microsoft Dynamics GP connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

POST/elt_syncs
▌
FAQ

Common questions.
About connectors.

Still have a question?
Talk to us

All connector and sync questions

Put your Microsoft Dynamics GP data to work.

Connect Microsoft Dynamics GP, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Image not found!
Source
WeldWeld
MCPAgents