Hi, do you know what the problem could be? I have a backup of the MS database, which I load into FME and write to the postgres DB with Postgres writer, but I have no data in postgres. Maybe a datatype? But FME reports no errors.
Thank you
Page 1 / 1
Does FME read the data from MS-SQL?
Not directly from the database, fme reads the *mdb file
If you inspect that in Workbench, directly after reading, do you see data?
I can see the data from the reader, but it is not functional. I tried to write the data using the INSERT INTO function in pgAdmin and it looks like some kind of coding error. Can I change the encoding in fme before writing?
I can see the data from the reader, but it is not functional. I tried to write the data using the INSERT INTO function in pgAdmin and it looks like some kind of coding error. Can I change the encoding in fme before writing?
How did you set up the process in FME? It could be an encoding issue (in which case you should be able to set that on the writer) but there could be other issues. One potential one is column naming convention differences.