Store a file in a varbinary DB field of sql server

[nivedhitha]

Hi everyone,

I have a table with schema as shown below

I have to save my source file(.xlsx) in the Mapping_Document_File field. Please provide me suggestions as to how to achieve this

[DataTeam1 · Accepted solution]

Here you can see an example how to achieve this

Inserting BLOB or CLOB data into a database

[Anonymous]

Hi,

    While you can load the file to the database, why didn't you question the designer for following this approach? Now, we are having modern cloud storage facilities like S3 where we can store the files in most secured fashion with minimum cost. Ideally it should be the approach instead of pushing the files inside DB.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[nivedhitha]

Hi @DataTeam ,

Thanks for your reply. 

I tried doing it but what gets inserted into the table is a sequence of strings rather than my xlsx file.

The datatype of the field in my SQL Server table is Varbinary.. and if I import the schema in the Dboutput component, the type is object and the datatype is varbinary. so I copied the same schema to the output of tMap and followed the same steps as the link you provided.

And the output is

Attaching the screenshots of tmap and dboutput

Schema as imported by dboutput component

tmap

Please let me know what is the issue here. 

thanks in advance

[nivedhitha]

Hi,

Does someone have any suggestion for me?

Appreciate any inputs.

Thanks

[DataTeam1]

@nivedhitha I promise come back to your issue next week because now I have many other task to do in my work.

Until then maybe @nthampi can help you.

[nivedhitha]

@DataTeam ,

Thank you. Looking forward to your suggestion.

[DataTeam1]

Hi @nivedhitha sorry for my absece.

Write me what do you want to store in database.

I suppose you want to have xml string (content of xml file) instead of xml as binary format.

[nivedhitha]

@DataTeam ,

Thanks for getting back.

Yeah right I want the file itself to be saved onto database. But my routine now just inserts a string.

Any suggestions/corrections?