How to force generated SQL by InfiniteInsight be case sensitive

[Former Member]

Does anyone know how to make the generated SQL by infiniteinsight be case sensitive?

For example, in the screenshot here, all field only first character is upper case, and the rest are lower case. However the generated SQL only keep the first field as original, but the rest are all upper case.

Thanks,

[achab · Accepted solution]

Hi Michael,

As per our offline discussion, this is a known defect of Data Manager (former Explorer) against lower case column names.

We are working on a fix, to be included in the next release of SAP Predictive Analytics.

Since you seem to have control over the table creation script, I would suggest to use upper case names everywhere as a workaround.

If for some reason you cannot do it for the table itself, then you can create a SQL view on top of the table and consume that view in Data Manager.

I will flag the question as "Assumed Answered".

Thanks & regards

Antoine

[achab]

Hi Michael,

As I see that you are an SAP employee, can you please send me an email, let's discuss this offline and we will post the conclusion once we conclude? Thanks & regards

Antoine