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

extract data from IPCC express

Hi,

Is it possible to extract data from the IPCC SQL database, and to use this data to make some customized reporting?

I have IPCC standard.

Thanks,

Bye,

JH

10 REPLIES
Bronze

Re: extract data from IPCC express

Absolutely. What version of Express are you running?

Silver

Re: extract data from IPCC express

Hi,

IPCC 4.5 standard

Bronze

Re: extract data from IPCC express

Silver

Re: extract data from IPCC express

Thanks Joe,

How do actually connect to the IPCC? It is not SQl, but MSDE. How would you connect to this database?

JH

New Member

Re: extract data from IPCC express

I have the exact same question. Ive already downloaded the schema just need to know how too connect.

Thanks,

SF

New Member

Re: extract data from IPCC express

Hi,

You need IPCC Express Premium to use database connectors in your scripts.

If you only need extracting data to do reporting, the MSDE instance is running under Server_IP\CRSSQL. You can create an ODBC connection to access the database.

You can also use Crystal Reports to integrate the new customized reports with the CRS Historical Reporting Tool.

Regards,

Carlos

Silver

Re: extract data from IPCC express

Thank you all, made it work. I installed enterprise manager on the IPCC created the user I wanted to use to connect. And now we have access and can extract the information we want.

JH

New Member

Re: extract data from IPCC express

can you tell us which enterpise did you install ?

VIP Super Bronze

Re: extract data from IPCC express

IPCC 4.x uses Microsoft SQL 2000 (MSDE) if you haven't purchased the Cisco SKU for full SQL Server.

Silver

Re: extract data from IPCC express

SQL 2000 enterprise manager

JH

264
Views
0
Helpful
10
Replies
CreatePlease to create content