Stuck with Stored Procedures

Go down

Stuck with Stored Procedures Empty Stuck with Stored Procedures

Post  grinnell on Wed Nov 18, 2015 5:47 pm

Hello,

I have two data sources which will ONLY allow me to access their data via stored procedures. What's worse, these stored procedures return results based on a single ID passed in rather than as a set. In addition, they do not have any dates or times data was last updated that are exposed to me as a consumer. Therefore, I pretty much have to pass in all my IDs to return every single record they have in order to cross-reference that with my warehouse data to see if I need to update anything. As the data grows on my end this is becoming more and more difficult. I can only assume that others have encountered this issue and if so how did you solve it? Just make more and more calls to the source database via stored procedure?

Thank you kindly for the thoughts.

Mike

grinnell

Posts : 1
Join date : 2015-11-18

Back to top Go down

Stuck with Stored Procedures Empty Re: Stuck with Stored Procedures

Post  ngalemmo on Thu Nov 19, 2015 12:32 am

You basically have the wrong architecture for what you want to do. Other than changing the interface (providing one that returns sets) there isn't much you can do other than what you are doing now. It is not very efficient. See if the data provider is willing to develop new interfaces.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Stuck with Stored Procedures Empty Re: Stuck with Stored Procedures

Post  BoxesAndLines on Thu Nov 19, 2015 8:59 am

Idiomatically speaking, you're preaching to the choir. If sensible people won't do sensible things, then you're stuck doing what you're doing.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Stuck with Stored Procedures Empty Re: Stuck with Stored Procedures

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum