Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I just registered a SQL Server view with ArcSDE through

sdetable -o register [...]. 

I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view?

EDIT

It seems that to register a stored procedure, it is required to have a "stable" database object: the definition of the stored procedure by itself it is just a piece of code that has no sense until it is executed with some input parameters.

Ok, so, if we consider the stored procedure as a "data collection generator", how would you execute this code with the input parameters, catch the tabular data output and register it to ArcSDE? What would you use? Some kind of ArcGIS processing?

Please, could you provide any example or guidelines for this process?

Thanks!

share|improve this question
1  
Does your stored procedure return a table/view? If not, I am not sure what SDE would do with the stored proc. If so, an alternative would be to use your stored proc to refresh/rebuild a table or view. It could potentially called based on a trigger or cron job. –  DavidF Nov 15 '12 at 18:54
1  
I guess I should rephrase that, does it create a named table or view. I think that you pretty much need to have a 'stable' db object, like a table or view to register it. –  DavidF Nov 15 '12 at 19:49
1  
I would guess that it isn't possible. I suggest using the stored proc to create/refresh a table. Call the stored proc via cron. –  DavidF Nov 16 '12 at 4:20
1  
Is it possible to do your calculation in an inline function instead of a stored procedure? –  jrockers Dec 3 '12 at 16:22
1  
Well, the stored procedure does not make "any special calculation" it just builds a dataset in function of some input parameters the user stablishes. Nothing sophisticated, though. The thing is that I need ArcGIS to access that object, but that object does not exist until I establish those input parameters, so... Anyway, I found a "workaround" with publishing all required parameters with views and filtering them later. –  iamgin Dec 3 '12 at 16:42

1 Answer 1

up vote 0 down vote accepted

Well, the stored procedure does not make "any special calculation" it just builds a dataset in function of some input parameters the user stablishes. Nothing sophisticated, though. The thing is that I need ArcGIS to access that object, but that object does not exist until I establish those input parameters, so... Anyway, I found a "workaround" with publishing all required parameters with views and filtering them later

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.