Link to home
Start Free TrialLog in
Avatar of William Peck
William PeckFlag for United States of America

asked on

Can Business Objects connect to Google Big Query BI Engine?

We’re getting Google Big Query, which I know nothing about except this article (What is BigQuery BI Engine?  |  Google Cloud 1). It says "it’s a fast, in-memory analysis service. By using BI Engine you can analyze data stored in BigQuery with sub-second query response time and with high concurrency. BI Engine integrates with familiar Google tools like [Google Data Studio]. The [BI Engine SQL interface] feature also integrates with other popular business intelligence (BI) tools, such as Looker, Tableau, Power BI.

This article says you can connect B.O. to Google BigQuery (Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigQuery 1)

I’m just trying to sort out if BI Englne is a similar tool as Tableau, Looker, Power BI? Or is it more of a SQL tool for queries and such but not the primary end user tool (like PL/SQL Developer)

Anyone have any experience with Google Big Query/BI Engine (and B.O.)?

Looker was ruled out in our procurement package because it was an additional cost to Google Big Query, ( Looker is now part of Google Cloud but still its own entity (like Tableau and Salesforce)

Avatar of Mike McCracken
Mike McCracken

I am a BO developer using WebI, Crystal Reports, BO universes.
I have not heard about Google Big Query as a source but generally if you can use an ODBC connection to it you should be able to place a universe (semantic layer) over it and build reports.

I have no idea what BI Engine is.  The article you linked doesn't really explain it

Avatar of William Peck



thx ... I thought the same thing ... but B.O. isn't listed in their article. makes sense on the ODBC connection, Googel Big Query is a relational d.b.

and yeah, the article is marketing-fuzzy.
I'll keep this open for another day or two.
Found a post on another site where the fellow has successfully connected Business Objects to Google Big Query. Here's an article on ODBC / JDBC drivers.

"Google has collaborated with Magnitude Simba to provide ODBC and JDBC drivers that leverage the power of BigQuery's standard SQL.

The intent of the JDBC and ODBC drivers is to help users leverage the power of BigQuery with existing tooling and infrastructure."
Avatar of William Peck
William Peck
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial