You can translate the question and the replies:

Access Live SOAP WSDL Web Service through Excel

Hi, I want to access data from a SOAP Web Service (WSDL) through Excel. I want the process to be standalone/independent from Denodo. By this I mean, even when Denodo Platform is not running behind the scenes, once the excel is loaded with the data source and necessary settings, hitting refresh will update the live data. I need this because the web service loaded excel file will be used by other users who only want the end purpose of having and using the live data in the excel. Can you let me know how I can do this? Thanks!
user
27-07-2017 10:50:32 -0400

2 Answers

Hi, I usually follow these steps to publish the Denodo views in Virtual DataPort admin tool : 1. Open the desired view and I click on “publish” button or Tools>Web services container window 2. I drag and drop the views to be published as SOAP web service with the required settings. 3. Then, I save the SOAP web service. 4. Lastly, I click on the “Export” button and select the option “WSDL” from the drop down. After the WSDL document is exported I use a VBA code to consume the data in an excel file. I would ask you to refer to this external link on [sample VBA code to consume SOAP web service](http://www.automateexcel.com/2004/11/14/excel_vba_consume_web_services/) Besides this, you need to keep in mind that it’s necessary to have the Virtual DataPort Server in running status when you try to pull the data or refresh the data in excel. Therefore it is not possible to have a standalone/independent SOAP service access from Denodo. Hope this helps you!
Denodo Team
28-07-2017 09:29:11 -0400
Hi Denodo Team, I already have the SOAP Web Service (WSDL) for the web platform I need to access. I should ideally be able to write VBA code to access this web service through excel. However, with the variable number of rows and columns, the complete data dump from the web service seems to be complicated to write in code for me. This is where I am looking at Denodo for help. I was wondering if there is a way I can export a database/ODBC driver or any other export format that I can feed to the Excel data source. Again do you think there is an export format that lets Excel get the data from the Denodo export type without Virtual DataPort Server running? Thanks!
user
28-07-2017 09:51:02 -0400
You must sign in to add an answer. If you do not have an account, you can register here