Failed to connect CrateDB 5.5 from NiFi 1.23.2

Hi Team, I failed to create cratedb connection in nifi as the configuration connecting postgres, and I also checked the document
connecting-to-cratedb-from-apache-nifi, but I don’t find useful information for the issue I encounter. Thanks in advanced.

Hi, could you try adding


to the connection string as in the tutorial?

After adding it, the error are as follows.

t-edi-nifi-003:8443 - Failed to establish Database Connection: java.sql.SQLException: Cannot create PoolableConnectionFactory (The server does not support SSL.)

I see, that CrateDB server is not configured for SSL then, that is ok, just revert to the old connection string you were using.
Is /data/nifi/jdbc_drivers/postgresql.jar the latest jar from Download | pgJDBC ?

Yes, the postgresql.jar just link to postgresql-42.7.1.jar.

[root@t-edi-nifi-003 jdbc_drivers]# ll postgresql.jar 
lrwxrwxrwx. 1 root root 21 Dec 20 14:30 postgresql.jar -> postgresql-42.7.1.jar