JDBC Producer: Table does not exist or PDB is incorrect [closed]
Hello, I'm pulling data from IBM DB2 using JDBC Consumer and writing to SAP HANA using JDBC Producer but getting error message "Table 'xxxxx' does not exist or PDB is incorrect. Make sure the correct PDB was specified". I have tried lower case, upper case table names and by just pulling one column but it doesn't work. All records are landing in error records output. Appreciate direction. BR//Gaur
How did you configure JDBC Producer ?
Pretty much same as yours. Cant attach a link, just learned I need >10 points for that lol Here are the details: JDBC Connection String: jdbc:sap://$host$:port/$Schemaname$ Schema Name: $Schemaname$ Table Name: Project Column: id SDC Field: /id Data Type: INTEGER
I have updated my answer please check