Hi everyone,
Anyone tried pulling data from ultipro reports as a service (WSHttpBinding_IBIDataService) using SSIS.
Please I need assistance on how to create the reference used in the script component.
Thanks
Hi everyone,
Anyone tried pulling data from ultipro reports as a service (WSHttpBinding_IBIDataService) using SSIS.
Please I need assistance on how to create the reference used in the script component.
Thanks
I have not. One possibility is to created a console application that imports the report data into a SQL table. Then call the console application from SSIS. The following link has sample code for creating the console application. Just so you know, I'm still in the process of trying to get the console application to work
Hi @Tobz ,
This tutorial shows how to call a web API from a .NET application, using System.Net.Http.HttpClient.
static async Task RunAsync()
{
// Update port # in the following line.
client.BaseAddress = new Uri("http://localhost:64195/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
...
Please refer to Call a Web API From a .NET Client (C#).
Best Regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
5 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh