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

Find more posts tagged with

Accepted answers

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

All comments

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

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

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!

Quick Links