Author Archives: Gadi Yedwab

About Gadi Yedwab

Gadi Yedwab is the founder and CEO of Explore Analytics. Prior to founding Explore Analytics, Gadi served as VP of Product Development at ServiceNow, a leading provider of cloud-based services that automate enterprise IT operations. Prior to ServiceNow, Gadi Yedwab held executive positions at Quest Software and Brio Technology (which was acquired by Hyperion and then by Oracle). You can reach Gadi on twitter at @GYedwab or using the Feedback Form.

BI Nirvana with Cloud Data-Access Middleware

Posted on by

“Nirvana” means no more suffering. Those of us who dedicate their career to delivering BI solutions are intimately aware of the pain involved, because before you can even begin to analyze and visualize your data, you need to get access to it, and in a usable form. The good news is that with the move to the cloud, much suffering is finally being alleviated.

Let’s review some of the Impediments to data access:

  • Data needs cleaning, organizing, and cataloging before it can be usable by BI tools
  • Data is locked in systems and applications that lack standards-based data access APIs
  • Security prevents easy online access to the data that users need
  • “Big Data” are datasets that grow so large that they become impractical for traditional BI tools

In short, the systems that hold the data are not designed for BI access. To help with these problems, additional systems are introduced. Data warehousing is the process of taking data from existing systems and staging it in a usable form for query and analysis. For “big data”, large computing clusters use MapReduce to perform analysis.

Nirvana would have been achieved if all data were brought into a data warehouse and made available to all users who need it. But reality is the opposite. Systems holding data are ever more diverse and distributed with no one warehouse to consolidate the data.

Middleware

Data-access middleware connects BI tools with systems that hold data by providing two important facilities:

  • Standard language and API. Typically SQL and JDBC or ODBC API
  • Broad data-source coverage. Including connectivity to databases, data warehouses, applications, and other systems, many of which do not provide a SQL interface

Traditionally, implementing data-access middleware means more software to install, potentially on many desktops, and a constant need to upgrade the middleware to keep up with version changes and new data sources.

Cloud-based Middleware

The reason that I’m so excited about cloud-based middleware is that it solves the issue of software installation and upgrade and when coupled with cloud-based BI tools for analysis and visualization can finally deliver nirvana.

DataDirect Cloud and Explore Analytics

Explore Analytics is the product that I’ve been working on for the last couple of year. It is a cloud-based (SaaS) BI tool for data analysis and visualization. There’s no software to install and all you need is a browser or a mobile browser. The product implements several strategies for data access. The user can import data from spreadsheet, access SaaS applications and cloud databases directly, and access on-premise databases using an agent.

I recently integrated Explore Analytics with DataDirect Cloud, a new product by Progress Software, and I started to feel the nirvana that I’m talking about. DataDirect Cloud brings the strength of DataDirect to the cloud. In doing so, it delivers the benefits that I mentioned before – standard SQL access and broad data-source coverage – but it doesn’t stop there. It goes much further towards nirvana:

  • Setup is incredibly easy. With a single JDBC driver, Explore Analytics gains access to all the types of data sources that DataDirect Cloud supports. Better yet, for the user this is completely transparent, and there’s nothing to install!
  • DataDirect Cloud delivers painless access to SaaS applications such as Salesforce.com, Microsoft Dynamics CRM, and Oracle RightNow (the list of SaaS applications is rapidly growing.)
  • Neither the user, nor Explore analytics, needs to upgrade drivers to keep up with API changes of SaaS applications. DataDirect Cloud takes care of all that.
  • DataDirect has drivers for Big Data and NoSQL. Once delivered in DataDirect Cloud they become immediately available to Explore Analytics customers.
  • Service is by subscription, similar to Explore Analytics.

I tested access to my Salesforce.com developer account by using Explore Analytics via DataDirect Cloud and created the following chart showing US sales opportunities by state and type. The size of each pie represents the total opportunity amount for the state, and it’s broken down by the type of opportunity. It was all done in a few minutes without installing any software or writing any code.

In conclusion, cloud BI tools coupled with cloud middleware can finally deliver data-access nirvana and lead to true self-service. For example, a Salesforce.com customer can perform advance analysis and visualization of their pipeline and sales forecast without installing any software, simply by subscribing to DataDirect Cloud and Explore Analytics. Now that easy!

 

Cloud-Based BI for On-Premise Data

Posted on by

The title of this article is no oxymoron. Why should cloud-based Business Intelligence (Cloud BI) solutions be limited to cloud-based data only? In fact you should expect your Cloud BI solutions to work well with all your data including on-premise data.

Wait a moment, you’d say, my on-premise data sits behind firewalls and is not accessible from the cloud! Nor should it be accessible from the cloud lest data security be compromised!

Oh, but I insist:

  • Cloud BI can be implemented without poking any holes in your network firewalls
  • There’s no need to copy on-premise data to the cloud
  • Cloud BI is more secure than client-server solutions that keep potentially sensitive data on portable computers
  • Cloud BI is centrally managed, allowing you to easily cut access and control the load on your data source

Let me explain:

No Holes in your Firewall

The key to cloud-based access to on-premise data is a data-access agent. For example, the Explore Analytics Agent resides in your private network and communicates with the cloud-based Explore Analytics over HTTPS. The connection is initiated by the agent and there’s no port that accepts any connections from the outside. While the agent initiates the connection, user queries are processed instantly supporting interactive data exploration and live reports. And you have precise control over which data the agent can access.

No Need to Copy Data

Queries are performed on-premise and results are streamed back to the user. Copying data to the cloud is not necessary.

Don’t Keep Sensitive Data on Portable Computers

Your users use laptops and tablets. These devices are easily lost or stolen, potentially leaving you to deliver the bad news to your customers that their data might have been compromised. A SaaS web-based solution that can be accessed from anywhere using nothing more than a browser is thus more secure, because it eliminates the need to keep data on users’ laptops or tablets. You can easily change a password to cut off access from a lost device. Explore Analytics is specifically designed for self-service BI, replacing the need to use Excel spreadsheets.

Centrally Managed

With centralized data access, you can easily limit the number of concurrent queries, or limit the amount of data that you allow users to fetch in a single query. Since data is filtered and aggregated at the source, there’s never a need to fetch more than a few thousand rows. When users leave your company, off-boarding is easy. Moreover, if you need to temporarily cut off all data access to your data, then Cloud BI makes it a cinch.

Conclusion

Using Cloud BI solutions can greatly reduce costs and improve your users’ experience, and can be accomplished without sacrificing data security. The availability, confidentiality, and integrity of your data can be controlled at the level required by your business and the sensitivity of your data.

About Explore Analytics

Explore Analytics is a self-service SaaS BI tool for data analysis, visualization, and reporting. For more information, see the Explore Analytics website.