SAP Data services integration with SingleStore

Dears,

We are using SAP Data services to replicate data to SingleStore database. Actually, most of our test is working fine.
But we have found one issue when SAP Data services is trying to make a Delta Load.
When table key is a String the application will use the following syntax

SELECT 1
FROM <TABLE>
WHERE <COLUMN> = N'Literal'

Here our problem is that SAP Data services does not support natively SingleStore but support MySQL 5.x and MySQL 8.x

Do you have an option that can be specified in order to support such syntax?

Regards
Emmanuel

Hi Emmanuel! :wave:
Sounds like an interesting project.
Are you running on the managed or self-hosted service and what version number?

Hi,

Actually, we are making a test on self hosted version and the version is the latest one 7.8.14 using ODBC driver

Regards
emmanuel

1 Like