Home Products Downloads Store Support Company and contacts Blog Videos SQL BLOB VIEWER
Products
Support
Get our Products
Copyright © 2005 - 2017 Yohz Software, a division of Yohz Ventures Sdn Bhd.  ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners
Company
We have a fair number of users who use SQL Blob Viewer to extract files from The Raiser’s Edge databases.  This is because the Raiser’s Edge stores binary data and files in OLE Object fields.  Simply extracting the binary data from the database produces an OLE Object container file, which is not usable.  In these situations, SQL Blob Viewer can help you identify and extract the original data from the OLE Object containers easily. In The Raiser’s Edge, you may embed data directly into a field via the use of OLE servers.  These objects may also be created from an existing file.  SQL Blob Viewer can identify the type of data stored in these fields by inspecting the contents.  In the example below, we ran a query in SQL Blob Viewer to select only the OLE Object field.
SQL Blob Viewer then inspects the data and displays the type of document that’s stored in the fields.  You can then export the items, and SQL Blob Viewer will extract just the original data from the OLE containers.
You can of course change the file naming convention to fit your needs.  If instead we had selected the ID column in addition to the data column, we can then name our files using the ID value.
The Raiser’s Edge may also store binary data in packages when there are no registered OLE Server for that specific data type.  For OLE Object packages, SQL Blob Viewer will display the original file name in the results window.
When you now export the items, SQL Blob Viewer will name the exported files using the original file names if you select the Use package file name option.
That’s all there is to it to start extracting OLE Object data from your Raiser’s Edge database.  You don’t need to hire expensive consultants to do the same job (who’s probably using our software anyway), and save hundreds in consulting fees.
In cases where SQL Blob Viewer cannot identify or extract the OLE Object data, it wll be because the registered OLE Server for that particular file type is not supported.  In such cases, we can work with you to add support for that OLE Server type. SQL Blob Viewer offers other benefits to a Raiser’s Edge database administrator too: export millions of items easily with minimum memory requirements schedule tasks to automate the export process export only new items for automated export processes Learn more about SQL Blob Viewer here, or download the free trial now.
How to extract data from The Raiser’s Edge database, or OLE Object fields
DOWNLOAD THE FREE TRIAL
Get started with SQL Blob Viewer Make working with blobs easier - try SQL Blob Viewer free for 14 days
Got a question? If you need help, or have any questions about SQL Blob Viewer, please get in touch. support@yohz.com
identifies images and file types automatically identify images and files stored in OLE Object columns export embedded images to Excel spreadsheets supports Access, Firebird, MySQL, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources
Download trial Buy now, from USD 45

View and export images and

files from your database with

SQL Blob Viewer

See help file Product details FAQ Comparison with SQL Image Viewer Compare editions Blog entries Videos