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
Everyone has a plan until they get punched in the mouth. --Mike Tyson
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.
Everyone has a plan until they get punched in the mouth. --Mike Tyson
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
April 3, 2018 at 1:21 pm
Thanks guys and it's always nice to see Phil 🙂
Everyone has a plan until they get punched in the mouth. --Mike Tyson
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply