I'm getting started on extracting data from Raiser's Edge with RODBA. The approach is to take the queries defined through the front-end and examine the SQL.

Some of the queries included views with names like tmp14565_286378713_1, that are also refereneced in the TempObjectLog table. These views are created and destroyed when the queries are open. The definition of these views is not available, from the database -- it seems like the source is encrypted or the proper permissions don't exist.

 I'm looking for any information on the views. They do not seem to be needed for all queries. Are they certain constructions or approaches that will prevent them? Is there some way to resolve them to their underlying definition? Any pointers for working with them?

We are developing automated extraction scripts, so having a view generated by the front-end would be a problem.

 Thanks!

Brian Dudley

Brian, 

I'd be interested in hearing any outcomes you have had from this question and/or developments. I'm in the same boat in terms of getting started with RODBA with intent to reproduce some of the queries into web-services. I've been unable to reproduce some of the queries that require the temporary view objects. If possible, contact me here on via e-mail and perhaps we can collaborate?

Brian,

Hope you are doing well. Been fooling around with it for a week: In queries that have views, I am creating them myself in another database to be used in the main sql query. I do not know the rules behind why they are created other than to hide complexity in cross-key statements.

My intent, load permitting, is to just alter the tables with a new temp view during each extraction. Or in the case of ASP work, perhaps schedule a view to be created at a set time.