Store SQL FileTable in to Board

Options
Julio Dominguez
Julio Dominguez Active Partner
Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights Name Dropper First Comment
in Platform

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

image.png

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

See attached the cube dimension

image.png

Accepted Answer

  • Fabio Donatellis
    Fabio Donatellis Employee
    First Anniversary Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights First Answer
    Answer ✓
    Options

    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

Answers

Categories