I have an issue with standard Amazon Simba RedShift connection - calculated fields in universe do not work properly. For example I can't use convertation from String to Interger, from Integer to String. During data extraction I have error messages because of these fields.
I thought it's because of old driver and downloaded newer driver from Amazon site. I created Data Source (ODBC 32 and 64) and used it in Generic ODBC connection. This driver solved issue with calculation fields, but I received new issue - date/timestamp fields doesn't work. With this new connection I always receive NULL instead of date/timestamp values (in IDT fields marked as UNSUPPORTED)
I thought it's because of different connection parameters. So my next step was to edit odbc.sbo file to set the same connection parameters as in amazon.sbo. The difference was in:
<Parameter Name="Qualifiers Available">Yes</Parameter>
<Parameter Name="Owners Available">Yes</Parameter>
<Parameter Name="Array Bind Available">False</Parameter>
Also in original odbc.sbo:
After my changes in odbc.sbo new connection don't have an issues with date/timestamp (locally). But at the same time connection became unsupported for multisource data foundataion. Just because of dbd_wodbc3, dbd_odbc3. This libraries exist on local machine and on server.
I don't have any idea where the error.