Exporting Data - for SQL Data warehouse

Options
RONALD TIMM
RONALD TIMM ✭
Tenth Anniversary Facilitator 1 Photogenic
in Blackbaud Raiser's Edge NXT®: General Discussion

Hello - We were working on the possibility of exporting Data, possibly through the API or some other means to dump into a data warehouse to create reports using SQL. Now with the announcement that Crystal support will be going away, we are expediting our efforts. Just curious, has anyone else attempted this?

Tagged:

Comments

  • Larry Wheeler
    Larry Wheeler ✭
    Eighth Anniversary Facilitator 2 Name Dropper

    I haven't been able to do a lot with it yet, but I am using the free monthly backup and pushing it to a sql server so I am able to access it using SSMS.

    Of course, this method will not work for you if you need up to the day accuracy.

  • RONALD TIMM
    RONALD TIMM ✭
    Tenth Anniversary Facilitator 1 Photogenic

    Thanks for the tip

  • Joel Waldman 2
    Joel Waldman 2 ✭
    Fourth Anniversary Facilitator 1 Name Dropper

    The Charity Automator - Data Warehouse (www.esimpleit.com/charity-automator) is a fully managed secure data warehouse for all of your Business Intelligence reporting. The client's data in the warehouse can be updated multiple times per day, ensuring the most up-to-date information. Please contact me for additional information.

  • Rob Wild
    Rob Wild ✭
    Tenth Anniversary Facilitator 1 Name Dropper Photogenic

    Hi Ronald,

    We do this via setting up queries and exports in database view, and using the Queue service to nightly export all the data to the sFTP site, which is then collected automatically by the group that manages the data warehouse.

    We went with this approach, as one of the slices is actions YTD, which towards the end of the year would be pulling >1M records out, whereas exporting this through query's export function takes only a few hours, as opposed to the many hours via the export mechanism, and we didn't want to drown the API.

    Only issue we've experienced is having to regularly supply the data warehouse folks with updated sFTP credentials. We've tried asking for SSH tunnels etc, but those requests were declined.

  • Jim Avery
    Jim Avery ✭
    Third Anniversary First Reply

    Joel, I'd like to hear more… we are a new RE NXT client and are in the middle of implementation when we heard about the reporting changes with Crystal Reports. javery@uu.edy

    Thanks!

  • Sukesh Gill 4
    Sukesh Gill 4 ✭
    Second Anniversary First Reply

    @Ronald Timm You can request a backup of you entire DB nightly, import in SQL server and create reports. Best

Categories