Extract Data from the Hosted Database tables

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?

Answers

  • 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.

  • 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