This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to update existing rows in a database table. I can do it by streaming my data out and using the Output Data tool (so I know I have the right permissions, etc), but I can't figure out how to use the Write Data In-DB tool to do the same thing. I don't even see the Update Rows option in the Output Mode dropdown menu (I have updated to version 2019.1). I've checked that the field names, and number of fields all match. What am I missing?
In-DB Tool does not have delta logic capability. You will see by default when you create your connection the output it suggests using Bulk Loaders as this function is not available. I would stream out and perform the delta logic on the PK as you have been.
I’m not sure what you mean by delta logic – the documentation on the Write Data In-DB tool indicates the update rows is possible (and I think it works for SQL in particular) and the query structure examples on the page are similar to what we would write manually. Would changing the write driver help in this case? What determines if “Update Rows” appears or not with this tool?
I am having the same problem. I found the original discussion of this feature and confirmation that it should be present as of 2018.4, but I can't see the 'Update Rows' and 'Delete Rows' options that are supposed to exist..
The only advice I have got is to use the Output Tool to write to the database. This solution works fine (maybe a little slow, but my data sets are relatively small), but I've never got an answer on why the "Write Data In-DB" tool won't do it.