Vertica and OBIEE 12c

mpedroso

I am looking to integrate Vertica with Oracle's report and dashboard platform (OBIEE 12c) in the linux operating system, however, I can not find any material explaining how to integrate this in the current version of OBIEE 12c. Could someone help me?

siddyash

Hello,
Please use the following link to connect OBIEE 12c with Vertica quickly - https://www.vertica.com/kb/Vertica-Integration-with-OBIEE-Connection-Guide/Content/Partner/Vertica-Integration-with-OBIEE-Connection-Guide.htm

In addition, we have published how one can optimal use OBIEE with Vertica with this link (tips and technique) - https://www.vertica.com/kb/Configuring-OBIEE-for-Optimal-Performance-with-Vertica/Content/Partner/Configuring-OBIEE-for-Optimal-Performance-with-Vertica.htm

There is a sample application created using OBIEE with Vertica that we call as "Vertica Quickstarts" and you can find it at this link - https://www.vertica.com/kb/Vertica-QuickStart-for-OBIEE/Content/Partner/Vertica-QuickStart-for-OBIEE.htm

Hope this help.
Thanks.

mpedroso

Hey, thanks for the feedback.

These examples tell you how to integrate Vertica with OBIEE 11G into Windows. I need help integrating them into Linux on OBIEE 12c.

siddyash

Hello,
We have updated the document with Linux setup.
https://www.vertica.com/kb/Vertica-Integration-with-OBIEE-Connection-Guide/Content/Partner/Vertica-Integration-with-OBIEE-Connection-Guide.htm
Please check out and let us know if you still have any question.
Thanks.

mpedroso

Hi Siddyash

I followed the steps of the documentation but my data is being displayed in Mandarin. Can you help me?

siddyash

Hello,
Please try adding a line in ODBC.ini file under the Vertica DSN
locale=en_US

and in Vertica.ini file -
modify the line - DriverManagerEncoding=UTF-8 to DriverManagerEncoding=UTF-16

Let me know how it goes.
Thanks.

mpedroso

Hey Siddyash

I made the change but it did not work. It's still in Mandarin. Do you have any other options for correction?

siddyash

Did you restart the OBIEE services after the changes.
If not, please do that. If there is still a problem then remove the following:
OdbcConformanceLevel=3.0
ODBC64SqlHandleSize=64
ODBC64SqlLenSize=64
RebrandedLib=TRUE
DriverUnicodeType=
LazyLoading=
and restart the OBIEE Services to take effect. (Make sure locale exists in the odbc file).
If still an issue. Open a support ticket with Vertica.
Thanks.

mpedroso

Okay. Thanks.

mpedroso

Did not work. I made the setup using the unixODBC and the data is showing correction in OBIEE, however, when the data volume is too large, I get this error:

siddyash

Hello,
Please can you open a support ticket with Vertica, so that we can get more information. Thanks.