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. And see here for current known issues.

New Member

Creating/viewing SQL Tables on IPCC Express

I'm playing with data reads/writes w/the CRA Script Editor. How can I create/view the SQL Tables using the database on the IPCC server. I've created a data source but do not know the utility to actually create a table.

Please go easy as I am not a SQL person in any way, shape or form.

Thanks

3 REPLIES
Silver

Re: Creating/viewing SQL Tables on IPCC Express

Hi,

Creating table using editor steps is not supported. You have to create the tables externally and access these table data using editor steps. The SQL tab of the DB Read step is used to define the SQL SELECT statement required to retrieve the data that you need from the specified database. Check out the following URL which describes the database steps

http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_1/english/admn_app/step_ref/db.htm

Do let me know if you have further queries.

Regards

Yogi

Silver

Re: Creating/viewing SQL Tables on IPCC Express

In continuation with my last response, accessing views through scripts is not introduced. There is a workaround to access views. Do send me mail and I can provide the details.

New Member

Re: Creating/viewing SQL Tables on IPCC Express

The way to do this is to use either SQL Enterpriste Manager or another MSDE client manager obtainable on the web. I have been able to do this. Thanks for your help

97
Views
0
Helpful
3
Replies
CreatePlease login to create content