In theory you can use any JDBC driver in SAP BO. If ignite does not work then Hive+TEZ+LLAP is suitable for interactive queries (e.g. With ORC as the underlying format).
However your use case sounds also like you need another reporting tool, such as SAP Lumira, Tableau, Qlikview etc. > On 13. Aug 2017, at 07:44, ravi <meetraviparamasi...@gmail.com> wrote: > > Hi, > We are using SAP BOXI for report generation based on the schema defined in > Universe using HiveServer2 SQL Dialect to generate HiveQL and Run it on Hive > Server2 or SparKSQL Thrift Server. > To improve the Query response time we are planning to we wanted to keep the > data in Ignite Cache and Run Ignite SQL. So in this context? > 1) Do SAP BO or any other BI tool support Ignite as SQL Engine?. > 2) If not what is the alternate SQL engine(which is close to Ignite SQL > syntax and ANSI-99 complaint) we can make use of it for query generation? > 3) People can generate the report on any fields or combination and there > will be many tables. So configuring indexing or sql field upfront is the > challenging task. > > or > > Make IGFS as secondary file system, change MR engine as ignite and use > existing HiveQL dialect and check the performance improvement?. In this case > Hive on Ignite will it be better than Spark SQL? > > Regards > Ravi > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Apache-Ignite-JDBC-Support-for-SAP-BOXI-or-Other-BI-tools-tp16154.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com.
