connectivity from OBIEE 11g to MongoDB on linux - Forum - DataDirect Connect - Progress Community

connectivity from OBIEE 11g to MongoDB on linux

 Forum

connectivity from OBIEE 11g to MongoDB on linux

  • Hiello,

    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 .


    Regards,
    Sreenivasulu.

  • Hi Sreenivasulu,

    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?

    Regards,

    Neelima

  • [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

    Give password:

    [0][State: IM003] [DataDirect][ODBC lib] Specified driver could not be loaded

    Connect open failed

    Connection open failed:

    [0][State: IM003] [DataDirect][ODBC lib] Specified driver could not be loaded

    Give data source name: ^C

    do you really want to exit (y/n):

    information from odbc.ini:

    [MongoDB4]

    Driver=/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_32bit/lib/ivmongo28.so

    ServerMachine=vts-oraclelin38.gpc.zodiacmarine.lan

    Port=27017

    ForwardOnlyCursor =Yes

    UID=CMS

    PWD=

    SelectPhysical =Yes

    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.

    1.Verified LD_LIBRARY_PATH:

    [obiee1171@VTS-OracleLin27 setup]$ echo $LD_LIBRARY_PATH

    /zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_32bit/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/server/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/web/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/odbc/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/clients/epm/Essbase/EssbaseRTC/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/lib:/usr/lib:/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_32bit/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/lib:

    2. Specified libodbc.so library patch in ODBC.ini

    [MongoDB4]

    Driver=/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_32bit/lib/libodbc.so

    ServerMachine=vts-oraclelin38.gpc.zodiacmarine.lan

    Port=27017

    ForwardOnlyCursor =Yes

    UID=CMS

    PWD=

    SelectPhysical =Yes

    Regional = Yes

    SSL = No

    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.

    /zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_32bit/lib

    Regards,

    Sreenivasuluuu.

  • Hello...

    Cann someone help me with this...

    Regards,

    Sreenivasulu.

  • In odbc.ini, the driver should be:

     Driver=/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_32bit/lib/ivmongo28.so

    not libodbc.so.

    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

  • Hi,

    Thanks for the update.

    Let me change and try.

    Regards,

    Sreenivasulu.

  • 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:

    documentation.progress.com/.../mongoodbc_unix_quickstart.htm

    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.

  • Hi,

    That was good document. Now I am getting different error after setting proper driver.  Please advise.

    [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

    Give password:

    [0][State: 60] [DataDirect][ODBC 20101 driver][MongoDB]java.lang.NoClassDefFoundError: com/ddtek/mongodbcloud/sql/JniCommunicator

    Connect open failed

    Connection open failed:

    [0][State: 60] [DataDirect][ODBC 20101 driver][MongoDB]java.lang.NoClassDefFoundError: com/ddtek/mongodbcloud/sql/JniCommunicator

    DataSoruce:

    ==========

    [MongoDB4]

    Driver=/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/lib/ddmongo28.so

    Database=CMS

    HostName=11.93.16.217

    PortNumber=27017

    [obiee1171@VTS-OracleLin27 setup]$ echo $LD_LIBRARY_PATH

    /zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/server/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/web/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/odbc/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/clients/epm/Essbase/EssbaseRTC/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/lib:/usr/lib:/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/jre/lib/amd64/server:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/jdk/jre/lib/amd64/server:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/server/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/web/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bifoundation/odbc/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/clients/epm/Essbase/EssbaseRTC/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/bin:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/lib:/usr/lib:/lib:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/jdk/jre/lib/amd64/server:/zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/lib:

    [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)

           /lib64/ld-linux-x86-64.so.2 (0x000000387a000000)

    Regards,

    Sreenivasulu.

  • The driver could not locate mongodb.jar? You can either put it under

     /zodiac/BITEST/OBIAPP_DEV2/MW_HOME/Oracle_BI1/common/ODBC/Progress/DataDirect/ODBC_80_64bit/java/lib

    or specify the yor own full path for mongodb.jar like below in your odbc.ini file:

     JVMClasspath=<YOUR PATH/mongodb.jar>

    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

    -------------------------------------------------------------------------------

             Oracle BI ODBC Client

             Copyright (c) 1997-2013 Oracle Corporation, All rights reserved

    -------------------------------------------------------------------------------

    Give data source name: MongoDB4

    Give user name: cms

    Give password:

    [T]able info

    Coffeeolumn info

    Drinksata type info

    [F]oreign keys info

    [P]rimary key info

    [K]ey statistics info

    Sleeppecial columns info

    [Q]uery statement

    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 Details

    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][20101]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

    Refresh

    Regards,

    Sreenivasulu.