Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
The data being extracted in my Talend job is not loading to the SQL database server, so I want to see if there is a problem with the logic., please see the attached image. I even successfully retrieved the data from Salesforce and saved it as a csv file. But even though I don't receive any error messages when I try to load it into SQL, it still doesn't write or load properly. I've already given the SQL account I'm using in the SQL Database server the ability to create, insert, and update tables, but it's been ineffective.
Am I overlooking anything here? Please advice. Thank you.
Regards,
Mitz
GG hope this helps.
GG hope this helps.
Thanks @kevin cork . I followed your recommendations above however it's still not writing to the database. I've checked again all the necessary permissions in the server, database, schema and down to the table, still the same. 😟
Hello @kevin cork
I refresh my SQL DB connection (edit connection > retrieve the schema and table) from the Metadata and select the "update or insert" from the action on data then it works.
Thanks much for your help. 😉