enable non-RE SQL data to appear in RE Query/Export tools

Options
Gordon Prince
Gordon Prince ✭
Ancient Membership
in Blackbaud Raiser's Edge NXT®: General Discussion

If I create a SQL View in the Raiser's Edge database that selects data from another SQL-Server database, is there a way to make the results of that new View appear in the RE Query/Export tools?

My new View returns the Constituent_ID, so theoretically I should be able to join from my new View to the rest of the RE data.

Anyone have any ideas on whether or not this can be done? And if so, how?

Tagged:

Comments

  • James Andrews
    James Andrews ✭
    Ancient Membership Facilitator 2 Photogenic
    Gordon Prince:

    If I create a SQL View in the Raiser's Edge database that selects data from another SQL-Server database, is there a way to make the results of that new View appear in the RE Query/Export tools?

    My new View returns the Constituent_ID, so theoretically I should be able to join from my new View to the rest of the RE data.

    Anyone have any ideas on whether or not this can be done? And if so, how?

    Not that I know of. You'd have to have an outside program to view data from the two databases.
  • Kirk Schmidt
    Kirk Schmidt ✭
    Ancient Membership First Reply
    James Andrews:
    Not that I know of. You'd have to have an outside program to view data from the two databases.

     If you have RE:VBA you can do it. At one client we used an external database to automatically populate a number of values in an RE record when certain values were present.

Categories