Store SQL FileTable in to Board

Julio Dominguez

Good morning:

I saved a PDF in a SQL FileTable. Now I would like to read and write it from SQL to Board but I can't get it.

I tried to upload the SQL FileTable mapping the differents fields but none of them succeeded.

Could you confirm me if it is possible to send PDFs stored in a SQL FileTable to Board?

As an example see attached

If not, is there any way to read PDF from SQL with Board?

See attached the cube dimension

Fabio Donatellis

Hi @Julio Dominguez

Board and SQL use a different data format to manage this data, therefore you will not be able to directly import this type of data.
In SQL the pdf is saved in binary format in a field with VarBinary format.
In Board the blob cube is able to store physical files with a specific extension.

Therefore you will need to convert the binary string to a readable format before importing the file into the Board database.

Regards

Fabio

Willians Santana

Hi, @Julio Dominguez ,

I hope you are having a great day!

Board 12 has the following Data Source types:

https://www.boardmanual.com/2021/summer/administration/3-administration/Data_sources.htm?rhsearch=data%20sources&rhhlterm=data%20sources%20source

Which includes:

• SQL (which can be OLE-DB or ODBC)

Please send me an e-mail to wsantana@board.com so we can schedule a remote session and review your use case.

I am all ears for you.

Best Regards,

Willians

Julio Dominguez

Thank you for the answer @Fabio Donatellis

Wich type of transformation we need to execute to make it readable?

Could you provide us an example of Var Binary transformation?

Regards!