on 02-22-2017 5:07 PM - last edited on 02-03-2024 6:29 PM by postmig_api_4
Hi, everyone.
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:
<Library Platform="MSWindows">dbd_wodbc</Library>
<Library Platform="MSWindows">dbd_odbc</Library>
In amazon.sbo:
<Library Platform="MSWindows">dbd_wodbc3</Library>
<Library Platform="MSWindows">dbd_odbc3</Library>
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.
Hi,
Thank you for this post as it helped me a lot to find out to the solution to my problem exactly the same with Amazon Redshift Database.
I followed your steps compared odbc.sbo file with Amazon.sbo file both Located in Business Objects 4.2 Folder in Computer>C>Program Files X86> SAP Business Objects 4.2>SAP BO XI 4.0>data Access> connection Server >ODBC
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:
<Library Platform="MSWindows">dbd_wodbc</Library>
<Library Platform="MSWindows">dbd_odbc</Library>
In amazon.sbo:
<Library Platform="MSWindows">dbd_wodbc3</Library>
<Library Platform="MSWindows">dbd_odbc3</Library>
All steps same as u did above,
The different thing i did was, I created a new connection with ODBC 3 Driver insted of ODBC driver, and the NULL Date (?) issue at Data foundation was resolved with Multi source DFL.
Below is my odbc.sbo file i modified by comparing my amazon.sbo file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.