Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Historical Reporting Database

Hi

We have a thrid party developer requiring a copy of the HR database to start developing some custom historical reports.  What is the best way to get a copy of this db?

Thanks

2 REPLIES

Re: Historical Reporting Database

Why don't you just use MS SQL Studio/Ent Manager to take an export of the HDS and AW dbs?

david

Bronze

Re: Historical Reporting Database

Is it UCCX or UCCE you are using? If it's UCCX, the DB all the data is stored in is db_cra. If UCCE then you can do either push or pull for the data but if it's UCCX pushing data might be your best option using SQL Server DTS or SSIS packages as long as you have SQL Server on the box due to the limitation of UCCX SQL having to be in Windows Authentication only and not being able to join it to the domain.

Cheers,

Nathan

243
Views
0
Helpful
2
Replies