Connector
Dynamics GP Connector
Read and write Microsoft Dynamics GP (Great Plains) data without writing code, using the same stored procedures GP's own integration tools use.
Rapidi connects to Microsoft Dynamics GP through two connections. The GP SQL connection reads data straight from the GP database, and the GP stored procedure connection inserts and updates data through the stored procedures in that database, the same method GP's own integration tools use. Both run through RapidiConnector on a machine that can reach your SQL Server.
- What it connects to
- Microsoft Dynamics GP (Great Plains), on the Microsoft SQL Server that holds your GP company databases.
- Which way the data moves
- Both ways. Reading goes through GP SQL, inserting and updating through GP stored procedures.
- What you need
- RapidiConnector on a machine that can reach the GP SQL Server, with the MS-SQL client installed.
What does this connector actually do?
| Records it moves | The Salesforce standard template covers customers, opportunities and items. An optional Salesforce app adds sales transaction history and receivables, and an add-on copies open sales orders. |
|---|---|
| Direction | Both ways. The GP SQL connection reads, and the GP stored procedure connection inserts and updates. |
| Versions listed | Reading: Dynamics GP 2010, 2013 and 2015. Writing: Dynamics GP 2009 and 2013. Earlier versions on request. |
| Companies | One connection per GP company database. The Salesforce standard template handles several GP companies and several currencies from the start. |
| How often it runs | On a schedule you set. The shortest interval depends on your plan, from one hour on Entry down to one minute on Unlimited. |
| How it signs in | Windows authentication, using the account RapidiConnector runs under, or a SQL Server user ID and password. |
| Changes inside GP | None for the Salesforce standard template. The matching Salesforce IDs are kept in Rapidi's Link Storage, not in extra GP fields. |
| What you set up once | Install RapidiConnector and the MS-SQL client, then enter the SQL Server name, the company database and the sign-in, press Test and run Read Design. |
Which GP connection does what?
GP support is split across two connections on purpose: one reads straight from the database, the other writes the way GP expects to be written to.
| What you are comparing | GP SQL connection | GP stored procedure connection |
|---|---|---|
| What it does | Reads data from Dynamics GP | Inserts and updates data in Dynamics GP |
| How | Reads the GP database on SQL Server directly | Runs the stored procedures in the GP database, the same method GP's own integration tools use |
| Versions listed | GP 2010, 2013 and 2015 | GP 2009 and 2013 |
| Older versions | Ask us | Ask us |
| Installed on your side | RapidiConnector and the MS-SQL client | RapidiConnector and the MS-SQL client |
The MS-SQL client may already be on the machine, for example if the Dynamics GP client is installed there. RapidiConnector opens its connection outward, towards the Rapidi servers, so nothing on your network has to accept connections in.
Which integrations use this connector?
Rapidi has a standard template for Salesforce and Dynamics GP, with transfers for customers, opportunities and items already set up. It runs on these connectors.
Where do you go next?
Connectors
Every system Rapidi connects to
The full list, A to Z, with versions and how each one connects.
All connectors
Pricing
What Rapidi costs
Four plans, priced per subscription rather than per connector. Adding Dynamics GP does not change the licence.
Plans
Your setup
Ask about your own version
Tell us which Dynamics GP version you run and where it runs, and we will say plainly whether this connector covers it.
Talk to a consultant
Frequently asked questions
Can Rapidi connect to Dynamics GP?
Yes. Dynamics GP is reached through the GP SQL connection for reading and the GP stored procedure connection for inserting and updating, and the transfers are configured rather than written as code.
Can Rapidi write into Dynamics GP, or only read?
Both. Writing goes through the stored procedures in the GP database, which is the same method Dynamics GP's own integration tools use.
Which Dynamics GP versions are supported?
The documentation lists Dynamics GP 2010, 2013 and 2015 for reading, and Dynamics GP 2009 and 2013 for writing. Earlier versions may also be supported, so ask us.
Does anything get installed inside Dynamics GP?
No. RapidiConnector and the MS-SQL client go on a machine that can reach the GP SQL Server. The Salesforce standard template needs no extra fields in GP either, because the matching IDs are kept in Rapidi.
Can it handle several GP companies?
Yes. Each GP company database gets its own connection, and the Salesforce standard template supports several GP companies and several currencies from the start.
How often does the data move?
On a schedule you set. The shortest interval comes from your plan, from one hour on Entry down to one minute on Unlimited.
What does the Dynamics GP connector cost?
Nothing on its own. Rapidi is priced per subscription plan rather than per connector, so adding Dynamics GP does not change the licence.
Is your Dynamics GP on the list?
Tell us the version and which system sits on the other side, and we will tell you plainly what the setup involves.