Member Avatar for MktgRob

We are searching for an existing "middle ware" software product that can take data from the Blackbaud Raiser's Edge program and bring that data into Microsoft Dynamics GP. The integration can be brought into the GP General Ledger module or possible the Receivables Management module. Any assistance would be appreciated.

  • 2 Contributors
  • 1 Reply
  • 310 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by zeiddev

Dani AI

Generated

For reference: asked about middleware to move Raiser’s Edge data into Dynamics GP and offered bespoke development. Two practical, proven routes exist: use a purpose-built nonprofit data-posting product (less code, faster ROI) or build a custom bridge that talks to Blackbaud on the read side and GP eConnect/Integration Manager on the write side. (omaticsoftware.com)

How the technical flow usually looks: extract gifts, fund codes, constituent IDs and batch info from Raiser’s Edge NXT (use the SKY/REST API) or from file/ODBC if you run legacy RE; transform/match fund codes to GP accounts and donors to customer records; then post to GP using eConnect XML or Integration Manager destinations (GL batches or Receivables). Keep the original RE gift/constituent IDs on the GP transaction for audit and de-duplication. (learn.microsoft.com)

Product choices to evaluate quickly: Omatic (PostOmatic / Omatic Cloud) is purpose-built for RE -> financial systems and lists MS Dynamics GP specifically; integration platforms like eOne SmartConnect (REST connector) or an iPaaS can call Blackbaud’s API and write via eConnect; ODBC/driver vendors such as CData make RE NXT accessible to tools that need a relational view. For on-prem or hosted RE NXT, avoid unsupported direct write-access to Blackbaud internals and prefer documented APIs or exports. (omaticsoftware.com)

Quick implementation checklist: (1) confirm which Raiser’s Edge product/version is in use, (2) inventory required fields (gifts, splits, fund->GL mapping), (3) pick extraction method (SKY API, CSV export, or ODBC driver), (4) design idempotent posting into GP via eConnect/Integration Manager, (5) test in a sandbox and reconcile batch totals before going live. If little internal dev capacity, start conversations with Omatic or an iPaaS reseller; if your rules are complex, a custom SKY-to-eConnect bridge is the usual bespoke path. (omaticsoftware.com)

Member Avatar for zeiddev

We are searching for an existing "middle ware" software product that can take data from the Blackbaud Raiser's Edge program and bring that data into Microsoft Dynamics GP. The integration can be brought into the GP General Ledger module or possible the Receivables Management module. Any assistance would be appreciated.

I do not have, nor know of software that integrates the two. However, I work with The Raiser's Edge and this is the sort of bespoke customization that I would develop. Feel free to check out my website for more details: http://www.zeidman.info

David

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.