Connect SymmetricDS to ParaSQL

Question

We're trying to test loading data from our on-premise SQL Server 2008R2 machine to ParaSQL using SymmetricDS. We have a dedicated server instance with ParaSQL which requires an SSL connection. Certificates are provided by ParaSQL.

Where we're stuck is how to configure SymmetricDS to use secure socket layer for this connection. We can find some info in the documentation on how to generate keys on our end, but nothing on how to connect using provided certificates.

Does anyone here have any experience with that?

Thanks in advance.

score 0 · Answer 1 · answered Oct 04 '15 at 01:20

0

With SymmetricDS there is an SSL connection between the SymmetricDS nodes, and a different one between the JDBC driver and the database itself. The keys you are generating sound like they are for the node-to-node SSL. I believe what you need to do is setup the ParaSQL supplied SSL certificates for the JDBC driver that is making the connection to the database.

answered Oct 04 '15 at 01:20

Robert D

1,878
15
19

Thanks for your answer. Could you clarify a bit more how I could setup certificates for the JDBC driver? Kinda new at all this. – Koen van Wielink Oct 04 '15 at 06:17
Try this: https://dev.mysql.com/doc/connector-j/en/connector-j-reference-using-ssl.html – Robert D Oct 04 '15 at 16:35

Connect SymmetricDS to ParaSQL

1 Answers1