Use data fetcher to query image resource from external data source

Suppose we have a table called “new_emplyee” with following definition which exists in an external database.

We would like to reference the “photo” column in Excel Server’s data fetcher.

1.         Create an external data source in the Management Console.

2.         Register the table “new_employee” from the external data source.

3.         Click on the “Picture” column of the row corresponding to the “photo” table column, and select an appropriate file type for the column. If the expected file type is not included in the dropdown list, then type the file type directly into the cell, (with the maximum length of 8 characters). Please note: the “Picture” column will be disabled unless the actual data type of the field is of the “image” type.

After these steps, the “photo” column can be directly referenced by a data fetcher.