Integrating AXL with SSIS

Version 1
    This document was generated from CDN thread

    Created by: Robbie Biesser on 04-02-2011 10:53:58 AM
    I was wondering if anyone has had any experience with creating a MS SQL SSIS (SQL Server Integration Services) package with AXL.

    The following error is received when using AXLAPI.wsdl: 
    MS SQL Says: Could not read the Web Services Description Language (WSDL) file. The input WSDL file is
    not valid. The following error occurred while reading the file. There is an error in XML
    document (1063, 11)..

    Is there a AXLAPI.wsdl that would work with a MS SQL SSIS package?

    Subject: RE: Integrating AXL with SSIS
    Replied by: Abdul Basit Sheikh on 24-01-2012 05:33:18 AM
    I was wondering if anyone has had any experience with creating a MS SQL SSIS (SQL Server Integration Services) package with AXL.

    The following error is received when using AXLAPI.wsdl: 
    MS SQL Says: Could not read the Web Services Description Language (WSDL) file. The input WSDL file is
    not valid. The following error occurred while reading the file. There is an error in XML
    document (1063, 11)..

    Is there a AXLAPI.wsdl that would work with a MS SQL SSIS package?

     
    Same issue with me, I'm trying to connect to CUCM database most preferably using ODBC. But going through different rescources I found that AXL is the only option avaiable. Can somebody please reply to this post.  

    Subject: RE: New Message from Abdul Basit Sheikh in Administration XML (AXL) - Admin
    Replied by: Walid Azab on 24-01-2012 06:32:40 AM
    Ahmed, generally it is not allowed to access CUCM database directly and even if allowed it is not a good practice to access it directly. You are correct, AXL is the best way to achieve that.

    If you explain more what data you are looking for maybe we can help you more.



    BR

    WA



    From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
    Sent: Tuesday, January 24, 2012 12:33 PM
    To: cdicuser@developer.cisco.com
    Subject: New Message from Abdul Basit Sheikh in Administration XML (AXL) - Administration XML Questions: RE: Integrating AXL with SSIS



    Abdul Basit Sheikh has created a new message in the forum "Administration XML Questions":

    --------------------------------------------------------------

    I was wondering if anyone has had any experience with creating a MS SQL SSIS (SQL Server Integration Services) package with AXL.

    The following error is received when using AXLAPI.wsdl:
    MS SQL Says: Could not read the Web Services Description Language (WSDL) file. The input WSDL file is
    not valid. The following error occurred while reading the file. There is an error in XML
    document (1063, 11)..

    Is there a AXLAPI.wsdl that would work with a MS SQL SSIS package?



    Same issue with me, I'm trying to connect to CUCM database most preferably using ODBC. But going through different rescources I found that AXL is the only option avaiable. Can somebody please reply to this post. 
    --
    To respond to this post, please click the following link:

    <http://developer.cisco.com/web/axl/forums/-/message_boards/view_message/5050159>

    or simply reply to this email.

    Subject: RE: New Message from Abdul Basit Sheikh in Administration XML (AXL) - Admin
    Replied by: Abdul Basit Sheikh on 03-04-2012 09:10:54 AM
    Ahmed, generally it is not allowed to access CUCM database directly and even if allowed it is not a good practice to access it directly. You are correct, AXL is the best way to achieve that.

    If you explain more what data you are looking for maybe we can help you more.
     
    BR

    WA

     
    In my case I am looking for CDRS, specifically the Agent Hangup events
     

    Subject: RE: Integrating AXL with SSIS
    Replied by: Luis Vicente on 07-05-2012 04:14:11 AM
    Hi,

    SSIS has a tool named "Web Service Task" for use webservices but when I tried use with "executeSQLQuery" parameter I had problems because is a complex type param. Finally, I must use another SSIS tool named "Script Task".

    This link could be useful for you, http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/01/28/consuming-web-services-in-ssis-script-task.aspx

    Best regards,
    Luis.