​​Third-Party Connectors to Universes

The power of the BusinessObjects universe, the powerful semantic layer behind Web Intelligence and other SAP analytics tools, is unquestioned. As SAP BusinessObjects customers look beyond SAP for data visualization tools, a cottage industry of third-party vendors have sprung up to bring the power of the universe to non-SAP tools like Tableau, Qlik, and Microsoft Power BI.

UniverseBridge​ by Analytics8

no physical address listed on web site

Supports Tableau, Qlik, Microsoft Power BI, and ThoughtSpot.
Used by Nissan USA.

LiveConnect by Kobaltek

1-200 North Service Road, Suite 430
Oakville, Ontario L6M2Y1​

Formerly TableauConnect, the product now supports multiple analytics platforms including Tableau, SiSense, Microsoft Power BI, and Qlik.

​​​InfoBurst Tab by InfoSol

2340 W. Parkside Lane
Unit H 106
Phoenix, AZ 85027
623-707-7600 phone
623-707-7601 fax

InfoSol exhibited at the Tableau 2017 conference.

​ToreoData by WCI Consulting

WCI Consulting
8240 Preston Road
Suite 200
Plano, TX 75024

An ODBC connector that supports multiple non-SAP platforms.

This is only a list of available software packages and should not be considered an endorsement, either by me or my employer. Message me privately if you have additions or corrections to the list.

Is your organization using one of these solutions to extend universes to non-SAP tools? Share a comment below describing which tool you’re using, which analytics tools you’re connecting universes to, and any success stories or pitfalls.

Land and Expand

Expanding user adoption by learning from the experts.

Land and Expand binoculars and mapMuch has been made of the “land and expand” sales strategies of data discovery vendors Tableau and Qlik. First, “land” a single license of desktop software in the middle of a data-starved organization like accounting. Then “expand” by selling additional desktop licenses to curious co-workers, eventually spreading to multiple departments then roping in IT to adopt a server or cloud-based solution. Beautiful.

But did you know that it’s possible to use a land and expand strategy with your existing enterprise BI solution?

This article won’t help you decide if your organization should invest in data discovery tools. But I hope it will provide inspiration and ideas for extracting additional value from existing investments. Here are some practical ways that your Business Intelligence Competency Center (BICC) can increase user adoption of existing enterprise business intelligence.

Make it Easy to Get Started

Take a look at the homepages of SAP Lumira, Qlik, and Tableau. Go ahead— take a look. I’ll wait.

Did you see how easy it is to download the software? All three vendors provide a “free download” link in the top right corner of their web sites. You can achieve the same goal by creating or enhancing a BICC portal on your corporate intranet such as Microsoft SharePoint. There are typically two tasks users must accomplish:

  • granting BI platform access to an existing user’s ID
  • installing any client software such as the Web Intelligence Rich Client, Live Office, or Analysis for Microsoft Office

Many organizations have been reluctant to distribute desktop software such as the Web Intelligence Rich Client. But as its name indicates, it is a richer experience (without the annoying Java warnings, too). Whether a software installation is requested by a service ticket or downloaded from a server, be sure to provide easy-to-follow instructions for getting software on your BICC portal.

Give Away Free Samples

The second thing that data discovery vendors do really well is provide sample content. Make sure that all users (for SAP BI, the Everyone group) can access a folder of curated sample content. Ideally, this sample content should use corporate universes but could also use eFashion. Make sure that the samples are generic (don’t reveal sensitive information) and perform quickly by using only small data sets.

Give Away Free Tutorials

Data discovery tools typically feature free tutorials that can be accessed from inside the software itself or from the company web site. But using inexpensive tools such as tools such as Camtasia or ScreenFlow, you can go one step further by creating tutorials that use your organization’s data instead of sample data. SAP has done a fantastic job of describing how to create free tutorials— just look at their Learn BI web site for inspiration.

Your BICC portal should also include one or more pages that list the universes or BEx queries available in the BI platform. In addition to the semantic layer name, include a brief description (cut and paste from the universe parameters), the business user point of contact, the technical point of contact, and directions for requesting access to the information.

Rome wasn’t built in a day and neither was the SAP Learn BI site. Don’t be afraid to start small and build out a larger set of tutorials.

Give Away Free Webinars

In addition to static tutorials, hold repeating monthly or quarterly webinars. Check out this tweet from Qlik.


You should certainly record webinars and post the “best” one to your BICC portal. But I would encourage you to routinely (perhaps quarterly?) give live webinars because it’s a way to make the human connection with your user community. Their questions will provide valuable insight into how you can continuously improve your training materials, universes, and standard reports. Share presentation responsibilities throughout the BICC giving everyone on the team an opportunity to refine their presentation skills, even if they only handle 5 or 10 minutes of a larger presentation.

Be sure to collect data from your attendees such as name, department, job title and email address. Follow up with a quick email thanking them for their participation.

Reach Out to First-Time Casual Users

If you’ve ever downloaded a free version of a data discovery tool, you’ve seen the vendor’s CRM back-end in action. Via automation and an inside sales force, users who have downloaded the software are periodically contacted, asked if they need help, and reminded of free resources. Being able to cross-reference a user ID to an email address or phone number is key here. New users can also be identified by studying access requests submitted to the help desk.

Know Your Influencers

Desktop data discovery tools succeed not only because they create valuable content, but the person using it becomes a passionate evangelist for the product. In most organizations, these folks are known as “power users” and are sometimes noted as such in the BI security structure. However, just being labeled a power user doesn’t necessarily mean that you are one. Look for users that create and share a large amount of content. Because power users tend to push boundaries, it can also be helpful to look at the number and type of service requests users submit to the help desk.

Monitor Key Metrics and Refine Strategy

In all cases, user activity generates data. Data can be refined into key metrics. And key metrics can be monitored to refine BICC strategy. Look for insight from the SAP BusinessObjects auditor database, usage metrics from your BICC portal, usage metrics from a self-service download site or document management system, and help desk tickets. All of these sources are capable of providing data, but most will need additional additional refinement to reveal insights. Try to budget projects around these untapped data sources as part of your BICC’s annual planning.

Does it take too long to gain access to the enterprise BI platform? Does Brenda take too long to approve access requests? Is installing software a help desk fiasco? Address pain points and continually refine your BICC strategy.


Does your organization need a data discovery tool? Maybe.

Does your organization already own a data discovery tool due to the land-and-expand vigilance of their vendors? Highly likely.

Is there still untapped potential in your existing enterprise business intelligence platform? A distinct possibility.

I hope this article has given you some ideas to tap that latent potential.  Some of these topics are explored in my 2010 ASUG SAP BusinessObjects User Conference presentations, KPIs for Business Intelligence.

Bracing For Impact

Watching the data discovery vendors compete with the enterprise BI heavyweights.

Bracing for Impact

Last week, Fredrik Tunvall, an analyst with Ovum, published some analysis entitled Tableau Goes Beyond Visual Discovery. I’d quote from the article, but apparently Ovum doesn’t appreciate that kind of publicity.

No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior permission of the publisher, Ovum (an Informa business).


Mr. Tunvall correctly describes the current BI market as having two “factions”. On one side are the traditional enterprise BI vendors such as IBM (Cognos), Oracle, SAS and SAP (sorry Microstrategy, no mention for you by Tunvall). On the other side are data discovery vendors like Tableau and Qlik. The conventional wisdom is that data discovery vendors like Tableau are going to have to “brace for impact”- to broaden their offerings to compete effectively with the enterprise BI vendors. While I believe that Tableau and Qlik offerings will continue to gain new capabilities- some of which will encroach further into the enterprise BI space- I do not believe that there is a single- nor traditional- path to “enterprise BI nirvana”  for data discovery vendors to follow to grow in size and influence.

The Impact of Data Discovery on the Enterprise BI Market

There are two key messages from data discovery marketing. First, we know that you really love Microsoft Excel. And second, you’re not very fond of your IT department. Even vendors such as SAP have picked up on these two points in their messaging for their own year-old data discovery tool, SAP Lumira (formerly known as SAP Visual Intelligence). Side note- apparently focus groups held a higher opinion of Crystal Reports than BusinessObjects (see ad below)?

SAP Lumira - Love It 600

Data discovery tools are desktop tools, not the web-based tools that IT departments prefer (hence their aversion to deploying existing desktop tools like SAP Web Intelligence Rich Client and Live Office). The main point about data discovery is that Fred in accounting can get the CFO’s corporate card and purchase a single desktop license without IT even knowing about it. Fred first heard about the tool from Susan, an accountant at another local company. The attractiveness of the tool begins long before Fred even launches the program for the first time- it begins with the buying experience. Word spreads at the water cooler that Fred has a cool new tool on his desktop and soon everybody wants their own copy. The data discovery vendors call this their “land and expand” sales strategy (see my related article, Land and Expand). Need to collaborate? Easy, the data discovery vendors also have cloud solutions that can be purchased and deployed, once again without corporate IT. Want to throw a bone to IT? OK, we may have an enterprise product that we can chat about.

While conventional wisdom may show that data discovery vendors need to grow up, or even be acquired by the enterprise vendors, existing users are happy with the status quo. User frustration with the enterprise BI platforms and the IT departments that deploy them is driving the adoption of data discovery tools. But the situation isn’t unique to the BI market.

We’ve already seen a similar scenario play out in the smartphone industry.

The Smartphone Industry

Before 2007, Blackberry was the king of the smartphone market. With it’s physical keyboard, secure messaging, and easy-to-use email, Blackberry was beloved by corporate IT and users alike. When the first Apple iPhone went on sale, it was roundly criticized as unsuitable for the enterprise. Steve Ballmer, president of Microsoft with its competing Windows CE smartphone platform (later abandoned for the similarly named but incompatible Windows Phone) had this to say about the first iPhone.

“It doesn’t appeal to business customers because it doesn’t have a keyboard”

Microsoft CEO Ballmer Laughs at Apple iPhone
Mac Daily News
January 17, 2007

As the iPhone platform matured, Blackberry remained the corporate favorite, but Apple was the upstart preferred by consumers. Today, one of these companies is for sale, the other one is (sometimes) the most valuable company in the world. A recent BusinessWeek interview with senior Apple executives didn’t mention Blackberry. Not once. Instead, Apple CEO Tim Cook indicates that there’s room for the smartphone market for two different strategies- the one favored by Apple and the one favored by mostly makers of Android devices.

“There’s always a large junk part of the market,” he says. “We’re not in the junk business.” The upper end of the industry justifies its higher prices with greater value. “There’s a segment of the market that really wants a product that does a lot for them, and I want to compete like crazy for those customers,” he says. “I’m not going to lose sleep over that other market, because it’s just not who we are. Fortunately, both of these markets are so big, and there’s so many people that care and want a great experience from their phone or their tablet, that Apple can have a really good business.”

Tim Cook, Apple CEO

Apple Chiefs Discuss Strategy, Market Share—and the New iPhones
Bloomberg BusinessWeek
September 19, 2013

Apple became the dominant enterprise smartphone by adopting enterprise-friendly features but by also providing new capabilities never before seen in a mobile phone. An iPhone is a better smartphone, not a better Blackberry.

The Grocery Industry

We’ve also seen upstart companies succeed against established competitors in other non-technology industries such as the grocery industry. In the United States, Target has become an established retailer of groceries against the “establishment”, primarily Kroger and Walmart. While Target has a small number of Super Target stores that compete in size and scale with similar large formats by Kroger and Walmart, Target’s real success has been introducing grocery items to its smaller, traditional department stores (see Target press release Target Completes More Than 100 Store Remodels in March to Expand Fresh Food Selection). These stores only carry 10,000 square feet of groceries compared to the average Kroger store of 67,000 square feet (see Kroger web site). Nobody would suggest that Target is going to eliminate its competitors with a limited selection. But Target has filled its 10,000 square feet with the low-hanging fruit of the grocery industry- milk, bread, and non-perishable items. Target will be successful in increasing the average transaction size and average number of monthly visits from its existing customer base. Over time it will slowly pull away revenue opportunities from its more sizable competitors.

Let’s be clear. Target is not trying to match Wal-Mart in food. Target doesn’t want to be a grocery supercenter… It’s more about convenience than offering a place where a family can do all its weekly grocery shopping, says Howard Davidowitz of Davidowitz & Associates, a retail consulting and investment banking firm in New York.

How Target is gaining on Wal-Mart
MSN Money
November 16, 2011

And consider Whole Foods Market. I was unable to locate statistics about the percentage of their customers that exclusively shop at Whole Foods and forsake the traditional retailers. But notice how Whole Foods Market describes themselves to their shareholders. As you can see from this excerpt from their 2012 annual report, they’re creating a successful business in the grocery industry without following the traditional grocery playbook.

Each of our stores is designed to fit the size and configuration of the particular location and to reflect the community in which it is located. We strive to transform food shopping from a chore into a dynamic experience by building and operating stores with a lively, inspirational atmosphere, mission-oriented décor, well-trained team members, an exciting product mix that emphasizes healthy eating and our high quality standards, ever-changing selections, samples, open kitchens, scratch bakeries, hand-stacked produce, and prepared foods stations. We also incorporate many environmentally sustainable aspects into our store design, and many stores have bicycle parking racks and electric vehicle charging stations. Our stores typically include sit-down eating areas, customer comment boards and customer service booths. In addition, some stores offer special services such as chair massage, personal shopping and home delivery. Others offer sit-down wine bars and tap rooms featuring local and/or craft beer and wine, creating a destination for customer gathering. We believe our stores play a unique role as a third place, besides the home and office, where people can gather, interact and learn while at the same time discovering the many joys of eating and sharing food [emphasis mine].

Whole Foods Market 2012 Annual Report

Also, Whole Foods Market, despite efforts at broadening its target audience, isn’t the supermarket for everybody. By design.

In selecting store locations, we use an internally developed model to analyze potential sites based on various criteria such as education levels, population density and income levels within certain drive times.

Whole Foods Market 2012 Annual Report

Tableau and Qlik do not need to be the “supermarket for everybody” like existing enterprise BI platforms. Like Target and Whole Foods, they can pick and choose where to focus without taking on the heft of the large tool sets of the enterprise BI vendors.


As we see in the example of Apple, sometimes an innovator disrupts a market and either eliminates (Blackberry) or marginalizes (Microsoft) previously established players. In the example of Target and Whole Foods, we see innovators that create a successful business model that bears some similarity to the established players like Kroger and Walmart but is successful because of their unique differences that the established players cannot or will not embrace.

Am I saying that Tableau and Qlik will wane in influence as customers expect them to behave like established players? No. Am I saying that SAP Lumira has no chance of success against Tableau and Qlik? No. Each of these vendors- even the traditional, enterprise BI vendors- must use its unique capabilities to deliver solutions customers want. In some cases, they’ll compete for the same customers. In other cases, they’ll find new customers that cannot be reached with traditional products or traditional sales and marketing techniques.

But I’m definitely not saying that Tableau and Qlik have to abandon their unique culture and product offerings and become like “the other guys”. If you haven’t noticed lately, the established enterprise BI vendors are the ones that have strapped on their crash helmets, not the data discovery vendors.

For Further Reading