CODEWITHSUNDEEP
c#sql-serveroracle-databaserest
Fearghal
Fearghal

Reputation: 11417

SSIS vs Restful Webserviceq

I have a Oracle DB and have been getting data from it to my SQL Server DB via SSIS packages. Essentially i refresh most of my tables data using SSIS every 5 mins.

I also have a RESTful web service running on my IIS web server which my UI consumes.

I am thinking of either integrating the SSIS into my RESTful web services or removing the SSIS and hitting the Oracle db directly from WS to enhance security and simplify the overall architecture of the system

Would i expect to see a large impact to the speed. Is this essentially a bad idea all together or is it the correct thing to do security wise?

Upvotes: 0

Views: 241

Answers (1)

Dominic Cotton
Dominic Cotton

Reputation: 819

Personally i think its a bad idea to join the layers together. You say adding the direct oracle logic would enhance the security - who will benefit here? I suspect it would be easier to administer, having an additional security layer means you could add further security controls if necessary that the source/host system doesn't allow. What if suddenly you are required to talk to SQL Server not oracle? The RESTful service shouldn't care.

I host a lot of my services on a DMZ. I am not allowed to open port 1521 from the DMZ through to the internal network for a whole host of reasons - therefore i have to go via an intermediate solution.

As far as simplifying the whole solution, you also have the issue that if you get a request for a similar call to similar data you will have to replicate the RESTful service and modify - obviously lots of code repeating in there. Suddenly not so simple!

Separation of concerns should be a priority.

Upvotes: 1

Related Questions