Exporting Data - for SQL Data warehouse

RONALD TIMM

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?

Larry Wheeler

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

Thanks for the tip

Joel Waldman

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

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

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

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