Vertica and OBIEE 12c
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?
0
Comments
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.
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.
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.
Hi Siddyash
I followed the steps of the documentation but my data is being displayed in Mandarin. Can you help me?
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.
Hey Siddyash
I made the change but it did not work. It's still in Mandarin. Do you have any other options for correction?
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.
Okay. Thanks.
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:
Hello,
Please can you open a support ticket with Vertica, so that we can get more information. Thanks.