Ask Your Question

Revision history [back]

Configure 'JDBC Producer' as following, image description

Configure 'JDBC Producer' as following, image description

You need to check few things here:

  1. Does the table 'Project' exist? You should create the table in the mentioned DB before running the pipeline. JDBC will not create it. Also name your table in small letters(change 'Project' to 'project')
  2. Check you JDBC driver matches the server. Use 5.1.x driver.
  3. Try not to set anything in the 'Schema Name' configuration in the JDBC Producer, let this be blank since you are setting schemaname/database in the 'JDBC connection string'.

Refer https://groups.google.com/a/streamsets.com/forum/#!topic/sdc-user/V8dw2VRliiE for more details