SOAP Data Source?

[Nicholas]

Hello,

I'm trying to identify if it's possible to make a connection to Marketo, which has a SOAP Web Service Endpoint.  I've seen some references to Cognos Mashup and Cognos Virtual View Manager, or setting up an ODBC source with the SOAP Endpoint (using proprietary licenses), but I don't have access to those.

Has anyone been successful using a SOAP data source, or made a connection using some other means?  Setting up some kind of SSIS package isn't out of the question I don't think.

Regards,
Nicholas

[bdbits]

I have never tried connecting to SOAP in an FM package. But I think there might be performance implications. A better solution might be to ETL the data into a traditional database and point the package there. Just my thoughts about it.

[Nicholas]

Yes, that's the avenue I was thinking as well with creation of SSIS packages. They could load the data to a standard SQL database I have full access to.  Unfortunately that means there is more to maintain from my end and duplication of data in two databases (granted I don't have full access to one).