Configuring GreenPlum-connectivity-4.2.1.0-build-2 with OBIEE

[knappt]

I am using Greenplum version 4.2.1.0 and the GreenPlum connectivity toolkit version 4.2.1.0-build-2 and am unable to connect through the OracleBI ODBC Client nqcmd version: 11.1.1.5.0.110427.0955.000

in which I keep getting the error:

> nqcmd

-------------------------------------------------------------------------------
Oracle BI ODBC Client
Copyright (c) 1997-2011 Oracle Corporation, All rights reserved
-------------------------------------------------------------------------------


Give data source name: PostgreSQL30
Give user name: [redacted]
Give password: [redacted]
[0][State: S1000] [DataDirect][ODBC lib] Unicode converter truncated character
Connect open failed


Connection open failed:
[0][State: S1000] [DataDirect][ODBC lib] Unicode converter truncated character

Here is copy of my .odbc.ini
[PostgreSQL30]
Description=Connect to GreenPlum
Driver=/usr/local/greenplum-connectivity-4.2.1.0-build-2/drivers/odbc/psqlodbc-08.02.0500/unixodbc-2.2.12/psqlodbcw.so
Trace =1
Debug =1
TraceFile =sql.log
Database =[redacted]
Servername =[redacted]
Username =[redacted]
Password =[redacted]
Port =5432
Protocol =8.2-1
ReadOnly =No
RowVersioning =No
ShowSystemTables =Yes
ShowOidColumn =No
FakeOidIndex =No
MaxLongVarcharSize =500
DisallowPremature =No
UseServerSidePrepare =No
useDeclareFetch =1
Fetch =4096

This issue straddles the line between Greenplum and Oracle, but I am hoping someone might have some experience which crosses this line!

[carlo.ascani@2ndquadrant.it]

Hi,

would you please tell me which encoding does the Greenplum database use?

Assuming UTF8, you could try to enable it in nqcmd.

Unfortunately, I do not have nqcmd, but I can read on its documentation that it is possible to enable UTF8 support in nqcmd with the -z option.

Would you please try that and tell me if that helped?
In case it were not, I can try to get a nqcmd copy and perform a test on my own.

Cheers,

[jano]

hi,this because of the wrong setting in the user.sh

bellow is my user.sh($FMW/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/) setting:

#Greenplum
LD_LIBRARY_PATH=/usr/local/greenplum-connectivity-4.2.1.0-build-2/lib:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=/usr/local/greenplum-connectivity-4.2.1.0-build-2/drivers/odbc/psqlodbc-08.02.0400/datadirect-52_64/psqlodbcw.so:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

and the odbc.ini

[Greenplum]
Description = PostgreSQL driver for Greenplum
# the absolute location for ODBC driver to be used
Driver = /usr/local/greenplum-connectivity-4.2.1.0-build-2/drivers/odbc/psqlodbc-08.02.0400/datadirect-52_64/psqlodbcw.so
# tracing is may useful during testing but turned
# after moving to production
Trace = 1
TraceFile = /tmp/odbctraces_dbtm
Debug = 1
DebugFile = /tmp/odbcdebug
# the name of the target database
Database = test
# the host name or IP address, user and password of the target data server
Servername = 192.168.56.101
UserName = gpadmin
Password = admin
# default port number for Greenplum
Port = 5432
ReadOnly = No
RowVersioning = No
# recommended size
MaxLongVarcharSize = 2048
DisallowPremature = No
# provides some efficiency in query reuse
UseServerSidePrepare = Yes
ShowSystemTables = Yes
ShowOidColumn = No
FakeOidIndex = No
# allows for cursor fetch of result sets avoids out of
# memory errors in Cognos BI server
useDeclareFetch = 1
Fetch = 4096
UpdatableCursors = Yes
# required version
Protocol = 7.4
# recommended sizes
CacheSize = 75000
MaxVarcharSize = 1024



this work for me!

But,when I query non-ASCII characters from Answer, it can't display correctly.

So,how to set the client char encoding?