April 3, 2018 at 10:23 am
Hello,
Does anyone know if it is possible to use HARMONY web service in SSIS? I have a convoluted C# batch process that I would like to re-write in SSIS, but I am uncertain if SSIS supports this.
Any help would be appreciated.
Thanks
The are no problems, only solutions. --John Lennon
April 3, 2018 at 10:46 am
Lord Slaagh - Tuesday, April 3, 2018 10:23 AMHello,Does anyone know if it is possible to use HARMONY web service in SSIS? I have a convoluted C# batch process that I would like to re-write in SSIS, but I am uncertain if SSIS supports this.
Any help would be appreciated.Thanks
Exactly how do you invoke the HARMONY web service ? If you use C# today to do so, you can do the same in a Script Task within SSIS.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
April 3, 2018 at 10:57 am
"Exactly how do you invoke the HARMONY web service ? If you use C# today to do so, you can do the same in a Script Task within SSIS."
Thank you for this. It makes sense. But what about levels of security? Sometimes SQL can be very stubborn about connecting to outside sources.
The are no problems, only solutions. --John Lennon
April 3, 2018 at 11:06 am
Lord Slaagh - Tuesday, April 3, 2018 10:57 AM"Exactly how do you invoke the HARMONY web service ? If you use C# today to do so, you can do the same in a Script Task within SSIS."Thank you for this. It makes sense. But what about levels of security? Sometimes SQL can be very stubborn about connecting to outside sources.
Well, by default, any SSIS package that runs as a SQL Agent Job will be executed using the SQL Agent's Service account security context. As to security to and from your web service, that might be best placed in the hands of your network or network security folks. There's always multiple ways to skin the cat for those kinds of things. Is the HARMONY web service on-premise or out in the cloud? The latter will introduce potential security issues, and for that you definitely want your network folks involved. If it is indeed in the cloud, how did you handle that connectivity to said web service before, and why would it be different now?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
April 3, 2018 at 11:08 am
Lord Slaagh - Tuesday, April 3, 2018 10:57 AM"Exactly how do you invoke the HARMONY web service ? If you use C# today to do so, you can do the same in a Script Task within SSIS."Thank you for this. It makes sense. But what about levels of security? Sometimes SQL can be very stubborn about connecting to outside sources.
You're not really using 'SQL' when you use SSIS. But your SSIS process will be running in the context of the SQL Agent service user (unless otherwise configured). This is the user which needs the appropriate rights.
You'll have fewer security issues than you would if you were using a CLR.
If you are using any third-party (ie, non-native) DLLs, that will require some additional config effort.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 3, 2018 at 1:21 pm
Thanks guys and it's always nice to see Phil 🙂
The are no problems, only solutions. --John Lennon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply