topic Re: Does support SingleStore or SingleStore Helios with SSL environment ? in Qlik Replicate

Does support SingleStore or SingleStore Helios with SSL environment ?

khchoy — Thu, 22 Aug 2024 06:21:30 GMT

Hello Team,

Currently, we are having POC with Singlestore Korea for a customer. But SingleStore native pervermance is not good. So SingleStore Korea wil make new SingleStore environment with SSL.

I cheked user guide , MySQL endpoint have several SSL options but Singlestore have not.

So , Does Qlik Replicate support Singlestore with SSL environment ? and SingleStore Helios ?

Regards,

KwangHo

Re: Does support SingleStore or SingleStore Helios with SSL environment ?

DesmondWOO — Thu, 22 Aug 2024 06:41:56 GMT

Hi @khchoy ,

Thank you for reaching out to the Qlik Community.

SingleStore endpoint does not have SSL options like the MySQL endpoint, but you can try to add those SSL parameters in the Additional ODBC connection properties field.

Please let me know if it helps.

Regards,
Desmond

Re: Does support SingleStore or SingleStore Helios with SSL environment ?

khchoy — Thu, 22 Aug 2024 06:47:00 GMT

Thanks Desmond.

Does SingleStore Helios is same with SingleStore ? is it no problem ?

Regards,

KwangHo

Re: Does support SingleStore or SingleStore Helios with SSL environment ?

john_wang — Thu, 22 Aug 2024 07:34:04 GMT

Hello KwangHo, @khchoy

It's been long time! How are you?

Yes, it's same, the only difference is SingleStore Helios running on Cloud.

It's better you can setup an 64-bit ODBC DSN and use the 3rd party ODBC Test Tools/App to troubleshoot the SSL connectivity issue. If the ODBC works then Replicate should work as well.

Hope this helps.

John.