S
Sreenivasulu Erigineni
Guest
Here you go... If this is not correct can you provide sample statement and see if I can fetch data from setup I did. [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: [T]able info [C]olumn info [D]ata type info [F]oreign keys info [P]rimary key info [K]ey statistics info pecial columns info [Q]uery statement Select Option: Q Give SQL Statement: [T]able info [C]olumn info [D]ata type info [F]oreign keys info [P]rimary key info [K]ey statistics info pecial columns info [Q]uery statement Select Option: Q Give SQL Statement: SELECT 0 s_0, "Devices"."Serial Number" s_1, "Periods"."Zodiac Fiscal Year" s_2 FROM "Zodiac Mongo Test" WHERE ("Periods"."Zodiac Fiscal Year" = '2016') SELECT 0 s_0, "Devices"."Serial Number" s_1, "Periods"."Zodiac Fiscal Year" s_2 FROM "Zodiac Mongo Test" WHERE ("Periods"."Zodiac Fiscal Year" = '2016') 2713MongoDB ODBC driver2726MongoDB ODBC driver.2728 [2713][State: 60] [DataDirect][ODBC 20101 driver]2713MongoDB ODBC driver2726MongoDB ODBC driver. Statement preparation failed Regards, Sreenivasulu.
Continue reading...
Continue reading...