Extract Data from the Hosted Database tables

Joseph Sayah
Joseph Sayah
Ninth Anniversary Participant
edited January 23 in Blackbaud Raiser's Edge NXT®: General Discussions

I need to read data from our hosted Database of Raiser's Edge, specifically from the tables: RE7.dbo.records, RE7.dbo.gift, RE7.dbo.country_codes, RE7.dbo.tableentries , dbo.re7_gifttype_gltype, RE7.dbo.giftsplit, RE7.dbo.fund, RE7.dbo.giftadjustment;
Do you think can Blackbaud provide me with some IP Addresses and ports so that I can connect via ODBC connectivity to extract the requested data from these tables? Or is there any other method?

Tagged:

Answers

  • Crystal Bruce
    Crystal Bruce admin
    Tenth Anniversary Kudos 5 February 2026 Monthly Challenge First Reply

    Hi @Joseph Sayah - I moved this over to Raiser's Edge NXT and I'm going to tag it with RE7. Thanks!

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    Blackbaud will not allow direct access to hosted RE's database table.

  • James Belich
    James Belich
    Kudos 1 First Anniversary Name Dropper Facilitator 1

    This would be incredibly useful but I doubt Blackbaud will ever allow it. It's too bad, as it would be much easier to extract data if we could run custom SQL queries against the database. The Query tool has its uses, but it can be cumbersome for more complex queries.

Categories