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

Does IPCC Express Premium support calling Stored Procedures

Does IPCC express premium version database functionality support getting info from odbc databases by calling stored procedures? The client does not want any custom sql queries having access, we are only allowed to use existing stored procedures.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Member

Re: Does IPCC Express Premium support calling Stored Procedures

Yes, there is a post back in March that outlines what you need to do. I am currently using stored procedures with a customer SQL DB and it works great. I did need to add custom tables that match the stored procedure output though.

http://forums.cisco.com/eforum/servlet/NetProf?page=netprof&type=EmailAFriend&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.1ddd8f26%2F2#selected_message

Mike

2 REPLIES
Community Member

Re: Does IPCC Express Premium support calling Stored Procedures

Yes, there is a post back in March that outlines what you need to do. I am currently using stored procedures with a customer SQL DB and it works great. I did need to add custom tables that match the stored procedure output though.

http://forums.cisco.com/eforum/servlet/NetProf?page=netprof&type=EmailAFriend&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.1ddd8f26%2F2#selected_message

Mike

Community Member

Re: Does IPCC Express Premium support calling Stored Procedures

Hi Mike,

I am trying to get Custom Reports using IPCCX Historical Reporting Tool (4.0). In CRS Historical Report Administrative Guide, it mentioned to create SQL Stored Procedure. My question is that is the Stored Procedure be created in the CRS Script, or in the server. If I have several customers to get the same type of custom report, do each of them need to create a Stored Procedure, or the Stored Procedure need only be created once, and each customer just need to get the data they need.

Thanks.

Wenqian

213
Views
0
Helpful
2
Replies
CreatePlease to create content