Exporting Data - for SQL Data warehouse

RONALD TIMM
RONALD TIMM
Tenth Anniversary Kudos 1 Participant Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions

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 Kudos 2 Name Dropper Facilitator 1

    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 Kudos 1 Participant Facilitator 1

    Thanks for the tip

  • Joel Waldman
    Joel Waldman
    Fourth Anniversary Name Dropper Facilitator 1

    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 Kudos 1 Name Dropper Participant

    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 Facilitator 1

    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
    Sukesh Gill
    Second Anniversary Facilitator 1

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

  • Giovanni Franco
    Giovanni Franco
    Kudos 1 Participant Name Dropper Facilitator 1

    I am in the process to implement a data warehouse in my school. Based on your experience, which one would you think would be the best approach. Dumping data into CSV files via SFTP or via API with Azure Data Factory. I am new on BB and I am trying to figure it out how it works. :) Thx for any update.

Categories