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