If you have a Sharepoint BLOB file system on your system, this tutorial may help you.
- 3 minutes to read.
Learn how to change the BDC model by submitting the BCS Index connector to the database so that the SharePoint crawler can finally alize data from binary large objects (BLOBs) that reside in a SQL Server database.
Scanning BLOB Data
Business Data Connection (BDC) supports reading services through BLOB data types, which is useful when serving BLOB data from external systems. For this task, you must configure the physical database table to support this method. Then you add the StreamAccessor method to the BDC template file for the BCS Indexing Connector of the third-party content source.
Configuring SQL Server Database Table For BLOB Data
A Microsoft Server SQL database table must have one column indicating either the extension or the MIME type of the BLOB reports. If the database table schema does not contain columns with this information, you must add it to the schema. The following tables contain an example schema for an absolute database table with this column and are therefore examples of values that were stored in the database table.
|data readability datatable = “1”>|
|Display name||nvarchar (50)|
|Content Type||nvarchar (MAX)|
|username||Display name||extension||data||Content Type|
|1||file1||.docx||0x504B …||application / vnd.openxmlformats-officedocument.wordprocessingml.document|
|2||file2||.doc||0xD …||Application / msword|
|3||file3||.txt||OxE …||text / plain|
Modification Of BDC Model Data To Explore BLOB Data
After you have verified that the database table contains our own extension or MIME type information for the new blob data, you can use Microsoft SharePoint Designer to externally create a content model from the table that contains the blob data. Then you can publish all issues. For more ideas, see How To: Create External Content Types and How To: Create External Content TypesAn external content-based tent in a SQL Server table .
After creating the external blob content source, you can edit the BDC template file to enable scanning. You do not make these changes in SharePoint Designer. Therefore, you need to export the bdc template music file and use an XML editor to make these changes manually.
How To Export A BDC Plan File For Non-type BLOB Content
- In SharePoint Designer, click External Content Types in the left navigation pane to view the convenience external types defined in the BDC metadata store of the website service application.
- In the External Content Type list, select the external BLOB content. Then click Export BDC Model on the server ribbon. A
- Enter a designator in the infamous BDC model name text box and click OK.
- Select the location where you want to save the BDC device (.bdcm) and file and click Save.
To Enable Exploration Of The External BLOB Data Type
In an XML editor, open the BDC collation file created in the current section.
Create a new method that returns a BLOB field. You must define a key StreamAccessor method such as this method, as shown in the following example.
The table name in this example is Application.
SELECT data FROM [dbo]. [Application] WHERE [Id] = @Id Text Extension ContentType ContentType
If you find that the MIME type is the same for all blobs, you can replace this code set from the previous example:
with the following line of code:
application / vnd.openxmlformats-officedocument.wordprocessingml.document
Reimport the template file using only the Business Connectivity Services device management user interface.
Create a content source for the external content type.
Start full skaning the entire content source, including
Show connector frame in SharePoint
Speed up your computer's performance now with this simple download.
Exploring Binary Large Objects (BLOBs) in SharePoint.
What’s the difference between blobs and / or file storage? Azure Blob Storage is object storage used for storing unstructured data, whereas Azure File Storage is usually a fully managed distributed file system that is mainly based on the SMB protocol and looks like a hard drive after provisioning, for example.
A blob is a raw music file whose digital storage can be several gigabytes in size. It is compressed into a single file, which then needs to be stored in the database. Since binary data can only be processed by a computer and “consists” of the numbers 0 and 1, it is often necessary to install the appropriate program.