CONTACT US

568-3-53 (3rd Floor) Kompleks Mutiara 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia 6012-9714904 support@yohz.com https://www.yohz.com

RESOURCES

product blogs video tutorials help files
Copyright © 2005 - 2021 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners
How to extract data from The Raiser’s Edge database, or OLE Object fields - Professional Edition required We have a fair number of users who use SQL Image 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 Image 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 Image 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 Image Viewer to select only the OLE Object field. SQL Image 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 Image 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 Image Viewer will display the original file name in the results window. When you now export the items, SQL Image 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’re probably using our software anyway), and save hundreds in consulting fees. In cases where SQL Image 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 Image 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 Image Viewer here, or download the free trial now.
View and export images and files from your databases using SQL Image Viewer
identifies images and file types automatically identify images and files stored in OLE Object columns export embedded images to Excel spreadsheets supports Access, MySQL, MariaDB, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources
DOWNLOAD NOW
Get started with SQL Image Viewer Work with blobs faster - try SQL Image Viewer free for 14 days
Got a question? If you need help, or have any questions about SQL Image Viewer, please get in touch. support@yohz.com
Download trial Download trial Buy now, from USD 45 Buy now, from USD 45 See help file See help file

CONTACT US

568-3-53 (3rd Floor), Kompleks Mutiara, 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia 6012 9714904 support@yohz.com https://www.yohz.com

RESOURCES

product blogs video tutorials help files
Copyright © 2005 - 2021 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners
View and export images and files from your databases using SQL Image Viewer
identifies images and file types automatically identify images and files stored in OLE Object columns export embedded images to Excel spreadsheets supports Access, MySQL, MariaDB, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources
Download trial Download trial See help file See help file Buy now, from USD 45 Buy now, from USD 45
How to extract data from The Raiser’s Edge database, or OLE Object fields - Professional Edition required We have a fair number of users who use SQL Image 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 Image 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 Image 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 Image Viewer to select only the OLE Object field. SQL Image 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 Image 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 Image Viewer will display the original file name in the results window. When you now export the items, SQL Image 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’re probably using our software anyway), and save hundreds in consulting fees. In cases where SQL Image 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 Image 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 Image Viewer here, or download the free trial now.