We are trying to establish connectivity from OBIEE 11g to MongoDB by creating a data source in Linux. We have created data source in odbc.ini and added library files location in user.sh. But we ODBC driver issues.
tried with default Data Direct drivers and Progress drivers but no luck.
Could some help us what went wrong and steps to validate if configuration .
What is the error that you see when you try to establish a connection?
Can you tell the exact version of driver and the database?
[obiee1171@VTS-OracleLin27 bin]$ ./nqcmd
Oracle BI ODBC Client
Copyright (c) 1997-2013 Oracle Corporation, All rights reserved
Give data source name: MongoDB4
Give user name: cms
[State: IM003] [DataDirect][ODBC lib] Specified driver could not be loaded
Connect open failed
Connection open failed:
Give data source name: ^C
do you really want to exit (y/n):
information from odbc.ini:
Regional = Yes
SSL = No
[ODBC Data Sources]
AnalyticsWeb=Oracle BI Server
Cluster=Oracle BI Server
SSL_Sample=Oracle BI Server
MongoDB4=Oracle BI Server
Please see knowledgebase article at: knowledgebase.progress.com/.../000033527 and make sure your environment is set correctly.
Thanks. We will verify get back to you. Please standby.
Verified all values as per the link provided but no luck. Please advise.
[obiee1171@VTS-OracleLin27 setup]$ echo $LD_LIBRARY_PATH
2. Specified libodbc.so library patch in ODBC.ini
3. Please confirm driver file name tried with libodbc.so but its not working. Please let me know driver file to use.
4. Specified clinet path.
Cann someone help me with this...
In odbc.ini, the driver should be:
Are you sure you want to use the 32-bit, not the 64-bit, mongo driver for your app? For 64-bit, the driver name is ddmongo28.so
Thanks for the update.
Let me change and try.
This driver requires a JVM. Please also verify that you have the path to a libjvm.so on your shared library path in addition to the path to the driver libraries.
Also, some of the properties you listed in the data source(like ServerMachine) are not valid for the Progress MongoDB ODBC driver. There is a sample odbc.ini that gets installed with the product. Please switch to modifying and using(via the ODBCINI env variable) that file.
This Quick Start Guide should help:
Please verify that you can load the driver outside the OBIEE environment and then work on configuring OBIEE for connectivity.
Please keep us posted on your status.
Thank you . I am checking all the specified values and update.
That was good document. Now I am getting different error after setting proper driver. Please advise.
[State: 60] [DataDirect][ODBC 20101 driver][MongoDB]java.lang.NoClassDefFoundError: com/ddtek/mongodbcloud/sql/JniCommunicator
[obiee1171@VTS-OracleLin27 setup]$ ldd /zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/lib/ddmongo28.so
linux-vdso.so.1 => (0x00007fff44417000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f2d24d3a000)
librt.so.1 => /lib64/librt.so.1 (0x00007f2d24b32000)
libddicu28.so => /zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/lib/libddicu28.so (0x00007f2d23c3b000)
libodbcinst.so => /zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/lib/libodbcinst.so (0x00007f2d23a08000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f2d23804000)
libjvm.so => /zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/jre/lib/amd64/server/libjvm.so (0x00007f2d22990000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f2d22689000)
libm.so.6 => /lib64/libm.so.6 (0x00007f2d22405000)
libc.so.6 => /lib64/libc.so.6 (0x00007f2d22071000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f2d21e5a000)
The driver could not locate mongodb.jar? You can either put it under
or specify the yor own full path for mongodb.jar like below in your odbc.ini file:
Hope this helps. Good luck.
Thanks . I am checking will provide an update.
Thanks, Looks like now I am able to connect from Backend using nqcmd.
obiee1171@xxxxxxxxxx bin]$ ./nqcmd
ata type info
[F]oreign keys info
[P]rimary key info
[K]ey statistics info
pecial columns info
Select Option: Q
Give SQL Statement:
But we are getting below error while connecting from BI Answers. Please advise.
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: S0002 code: -5501 message: [DataDirect][ODBC 20101 driver]syntax error or access rule violation: base table or view not found: XXUSERS_ZIP_TERR_V. [nQSError: 16002] Cannot obtain number of columns for the query result. (HY000)
SQL Issued: SELECT 0 s_0, "Zodiac Mongo Test"."Users"."Account Number" s_1, "Zodiac Mongo Test"."Users"."City" s_2 FROM "Zodiac Mongo Test" FETCH FIRST 999999 ROWS ONLY