Apache Ignite JDBC Support for SAP BOXI or Other BI tools

[ravi <me...@gmail.com>]

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.

Re: Apache Ignite JDBC Support for SAP BOXI or Other BI tools

["slava.koptilin" <sl...@gmail.com>]

Hi Ravi,

>  1) Do SAP BO or any other BI tool support Ignite as SQL Engine?. 
Yes, Apache Ignite provides integration with Tableau [1] and Pentaho [2].

As Jörn Franke mentioned above, you can use ODBC [3] or JDBC driver [4] in
order to processing data using standard SQL statements.

[1] https://apacheignite-tools.readme.io/docs/tableau
[2] https://apacheignite-tools.readme.io/docs/pentaho
[3] https://apacheignite.readme.io/docs/odbc-driver
[4] https://apacheignite.readme.io/docs/jdbc-driver

Best regards,
Slava.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Apache-Ignite-JDBC-Support-for-SAP-BOXI-or-Other-BI-tools-tp16154p16162.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Apache Ignite JDBC Support for SAP BOXI or Other BI tools

[Jörn Franke <jo...@gmail.com>]

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 <me...@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.