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
+49- Celebrity
If you inspect that in Workbench, directly after reading, do you see data?
+11- Contributor
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?
+49- Celebrity
fmesafe.podpora wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.