InetSoft Webinar: The Virtual Data Warehouse Approach

This is the continuation of the transcript of the DM Radio show "Avoiding Bottlenecks and Hurdles in Data Delivery." InetSoft's Principal Technologist, Byron Igoe, joined industry analysts and other data management software vendors for a discussion about current issues and solutions for information management.

Eric Kavanagh: Our next guest. Segue right into Rich Walker from Denodo Technologies. Hey, welcome back to DM Radio. Rich Walker: Thanks, I appreciate it.

Eric Kavanagh: Oh, you got a little bit of buzz on your line there, probably go back to your headset, and tell you what, we will bring in Ian Pestel in the meantime, hopefully, he is ready. Ian, welcome to DM Radio from way across the pond, right? Ian Pestel: Yes, that’s right. Yes, good afternoon, and thanks for having me on the show.

Eric Kavanagh: Sure. I think you are a little bit softer, probably just because you are a thousands mile away or more. I guess it's further than that.

Ian Pestel: Okay, I will try to speak louder.

Eric Kavanagh: Sure, thanks. So let’s talk about, well, you guys talk about data virtualization. That’s certainly a way to avoid some bottlenecks is to identify certain data sets or data feeds where either they are not that critical or they don’t have to go through the traditional process, the batch ETL process, in order to get where they need to go. But I am guessing that’s something that you often recommend to customers right.


Census data dashboard
demo
View a 2-minute demo of InetSoft's easy, agile, and robust BI software.

Ian Pestel: Yes, absolutely. I mean I think there is a case being made for yeah, being more agile about the way that certain things that data have brought in to build an organization. I mean not everything has to go through the enterprise processes they do have, and the ETL processes to be used considering what we have been talking about. You have seen the data social media generates. Also there is more real time data.

People want to make decisions on that data much more quickly than pushing those through the traditional routes. There is going to be a bottleneck. You can bring sources of data which you currently have inside of your data warehouse through a virtual approach. This allows you to make the use of that real time data and also to make decisions much, much quickly because you can get to that data much more quickly.

Eric Kavanagh: Yeah, and you know data federation is by no means anything new. I think we used to call it enterprise information integration or EII, and I remember in 2005-2006, when you threw out that term, most people would fall asleep.

But it seems to me that we are hearing a lot of more of that, and do you think that’s because processors are a lot faster and more powerful now or is it that message buzzes or is getting a lot better or lot faster? Is it a maturation or an awareness about the use of these technologies? What do you credit to my observation that at least there has been an increase in the use of data federation?

Ian Pestel: I think you are right. There are technological factors involved in that. Networks are faster. So you can move data around much more easily. I think there is also more growing demand for it, and I think the thing is before you could get away without necessarily having to bring in real time data and use it inside your enterprise. A 24-hour delay was acceptable.

But I think the thing is that the businesses are changing, and the demand for information is completely changing, and the need to have information more quickly, to make decisions more quickly. I think people have to look at the billing, you know, also from that point of view as a supplier based on technology, how, do we make sure we can do that in most extreme way as possible.

Well, I think actually the technology itself is mature compared to what we saw in the early days of the EII. A lot of the investments go to research and making sure that we can actually pull out data in a more efficient way and leverage the things like multiple core CPUs and high bandwidth network.

Read why choosing InetSoft's cloud-flexible BI provides advantages over other BI options.

Previous: Dwarfing the Cost of the Original ETL Tool