[cisco-voip] IPCC Express Reporting access

[Matthew Saskin]

One possible way (although labor intensive on your end) would be to 
provide direct ODBC access to the database, however only allow 
permissions to run selects, etc. on views that you create.  This would 
effectively let you filter the data before the client can even query it.

As I said, time consuming on your end...

-matt

Cucumber Green wrote:
> I think you should take a look into the db_cra database. Specifically 
> the table ContactCallDetail.
> If the data of your contact centers is stored in the same database, in 
> the same table, there would be a security concern by giving one of your 
> users access through ODBC, as he/she would be able to look at records of 
> other contact centers.
>  
> I have done custom reports using Crystal Reports (which rely on SQL 
> Server stored procedures), never used ODBC to extract the data directly.
> 
> */Ed Leatherman <ealeatherman at gmail.com>/* wrote:
> 
>     Curious how people handle reporting with IPCC Express.. we run a
>     number of smaller call centers off of our IPCC Express system. Up
>     till now we've just been generating reports using the historical
>     reporting tool, but there are some units now that would like the
>     reports to either be in a different format or totally different
>     reports altogether than what we can get from the canned tool.
> 
>     Do most people use Crystal to accomplish this? Anyone provided an
>     ODBC connection to more database savvy users? My database knowledge
>     is pretty limited and I know zilch about crystal, trying to figure
>     out the best way (security and performance wise) to handle it and
>     still provide the info these folks are asking for. They already
>     understand they will be doing anything special with reporting
>     after-hours.
> 
>     -- 
>     Ed Leatherman
>     Senior Voice Engineer
>     West Virginia University
>     Telecommunications and Network Operations
>     _______________________________________________
>     cisco-voip mailing list
>     cisco-voip at puck.nether.net
>     https://puck.nether.net/mailman/listinfo/cisco-voip
> 
> 
> ------------------------------------------------------------------------
> Luggage? GPS? Comic books?
> Check out fitting gifts for grads 
> <http://us.rd.yahoo.com/evt=48249/*http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz> 
> at Yahoo! Search.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip