topic Re: Import .dat, .key files in Talend Studio

Import .dat, .key files

Anonymous — Wed, 02 Oct 2019 13:17:09 GMT

I am attempting to load data from an older database (APPX) to SQL Server. The files have 2 extensions, .dat and .key. I have tried File delimited and File regex but haven't been able to read the data yet. I have attached 2 files (in .zip file) as an example.

Can anyone suggest a way to open and import these types of files?

Appreciate the help!

Bill

Re: Import .dat, .key files

TRF — Wed, 02 Oct 2019 14:39:14 GMT

APPX has probably a proprietary file format so you cannot get the content using tFileXxxxInput component. Refer to the APPX documentation to get information about the best way to extract information from the database and produce CSV or XLSX files.

Re: Import .dat, .key files

Anonymous — Wed, 02 Oct 2019 18:51:06 GMT

Thanks TRF.

Re: Import .dat, .key files

TRF — Thu, 03 Oct 2019 21:36:47 GMT

You're welcome.
If it help you, thanks to mark your case as solved.