topic Re: binary files in Talend Studio

binary files

Anonymous — Sat, 16 Nov 2024 14:18:36 GMT

I want to use a binary file as an input and then load in a postgreSQL database. The binary file has the following format when converted to ASCII
Name Marc
ID 00000000
Age 30
The type and size in bytes of each field are already specified.
what type of file in the metadata section in the repository do I need to use to specify the schema of the binary file
Thank you for your help

Re: binary files

Anonymous — Tue, 08 Jul 2008 04:21:29 GMT

Hello
See 3403
Best regards

shong

Re: binary files

_AnonymousUser — Tue, 14 Jun 2011 15:17:56 GMT

the link is dead, where was pointing.
I need to migrate binary files (pdfs, txt,...) into a Postgres Database (bytea). How does this work, is it even possible?

Re: binary files

Anonymous — Thu, 01 Sep 2011 13:18:34 GMT

I've the same question. Has someone an idea?
Ragrds,
Billy

Re: binary files

Anonymous — Thu, 01 Sep 2011 15:30:37 GMT

I've the same question. Has someone an idea?
Ragrds,
Billy

Hi Billy
This post is a little old, can you describe your request with more details?
Best regards
Shong

Re: binary files

janhess — Thu, 01 Sep 2011 17:05:35 GMT

I use this routine to put binary images into a MYSql database
package routines;
import java.io.FileInputStream;
import java.io.File;
import java.io.FileNotFoundException;
public class ImageUtil {
public static byte[] getByte(String filepath) {
byte[] b=null;

try {
FileInputStream fis = new FileInputStream(filepath);
b=new byte;
fis.read(b);
} catch (Exception e) {
e.printStackTrace();
}
return b;
}
}
In a tMap I then call it on the output using ImageUtil.getByte(file_path) where file _path is the full file path to your file. The output column is a byte array byte[]

Re: binary files

Anonymous — Fri, 02 Sep 2011 05:23:07 GMT

Hi
If the data is the file path of binary file, janhess's solution is good.
If you are migrate binary file from database to another database, set the type as byte[], db type as Blob or Clob on the schema of input/output db component.
Best regards
Shong