I am very new, super novice to Talend. So i have this dataframe in .rds format (from R Studio). Instead of directly push the data to SQL server database from R Studio, I want to use Talend Open Studio to push the data. But I dont find any component in Talend that accept rds file but i do found tFileInputExcel. My concern if I convert rds file to excel first it will change the data type. Is there any other possible way to do this without converting it to excel? Or is there a way to load rds file into Talend?
Talend currently have no components to read RData files.
I agree with you that your best option would be to try and use R to export this data to excel / CSV format and import data from those formats. There are Java SDK-s that let you interact with R / RData file formats, and routines allow you to use any of these and write your own java code to process but not sure if those would let you easily transform data.
