We would like to extract data from a table having a combination of columns and Blob data to an external database where are all the extracted data is to be put into columns. i.e. there will be no Blob data using BIX component.
My understanding is that this should be feasible and this is how Bix will work.
Just wanted a confirmation on whether this understanding is right. Also, if there are any articles to support this?
Yes, your understanding is correct. BIX is an extraction tool that takes the data from the BLOB and puts the data into normalized tables. You should read the BIX user guide to understand how to use BIX.