James H.

So the owner of the endpoint will provide you with an authorization cert. Then you would just plug that into a SSH Auth account type. It is pretty basic. Am I missing something?

Scott O. -- that makes sense. Just tested it and "well like you said" it installed the libraries. 🙌

Niranjan, It sounds like the limitation on the error might be more a DB2 thing than the driver. It might be worth a ticket to IBM to confirm. As far as a solution, depending on the number of records, you could stream them in 1 by 1 and then you would be able to capture all the ones that failed. Other option is orchestrating the DB2 Bulk load. It seems promising and says it can be triggered by an API call. If it is anything like Redshift it should take all the good records and then log the bad. Hope that helps👍

I haven't used this snap but based on the reply from Patrick, I would try to make a child pipeline and then push your list of documents from the parent to the child one at a time.