I'm trying to insert data into an always encrypted column (mssql 2016).
I first use mssql connection but with no success.
I try to use generic jdbc to use the last Microsoft jdbc driver 6.0 but I still have troubles with column type.
Did someone succeed in the type of connection?
This isn't something I've played with myself, but from a quick read of the related Microsoft docs, it appears you should just need to set the following in "Additional JDBC Parameters" on the tMSSqlConnection:
Hope this helps.
OK, so when you say you're having no success, are you getting any actual errors?
There doesn't need to be anything special about the SQL for your INSERTs to work, so I'm expecting the problem to be on the connection side of things.
I understand that column types/sizes are very important when using Always Encrypted columns, and from the error message it appears that there's no size specified for the particular nvarchar field you're trying to insert, so I'm guessing this isn't defined in the schema of your Talend job.
If you add a size of 4000 to this column in your schema, does that help?