 Live from Orlando, Florida, it's theCUBE. Covering Pentaho World 2017. Brought to you by Hitachi Ventura. Welcome back to theCUBE's live coverage of Pentaho World. Brought to you, of course, by Hitachi Ventura. I'm your host, Rebecca Knight, along with my co-host, James Kobielus. We have two guests today. We have Michael Becker, a senior chief inspector and Henry Liebrins, the police sergeant of the German federal police, the Bundespolizei. Welcome, gentlemen. Thanks so much for joining us. So do you want to start out by telling us, telling our viewers a little bit about Bundespolizei and what you do there? Okay. The federal German police employs about 41,000 people and as a part of federal German ministry of interior, we have, the police is responsible for many demanding and very a task like air control or air safety, rail, patrol, border control, crime reduction and patrol of the high seas. And besides an internal task, we do many different tasks. We do many international missions, the police missions all over the world and missions in the European Union for neighboring and our job. Our main job is to development, especially police software you couldn't buy or with a standard product. And we develop with our own framework based on LAMP and... Classical open source systems plus open source databases plus PHP. It's a script language on the top. And we built an absolute own framework on this. It's exclusively for us and that's our main job to build applications on this top. And besides our main job, we are responsible for the data warehouse and responsible for data integration technologies and the federal police. You're both within the IT organization of Bundespolizei. We stay in the IT department and belongs to the headquarters. We have in Germany, we have in German police, we have one headquarters, we have 11 district offices, about 80 regional offices and about 160 local offices. All over Germany, is it? So when you're thinking about your software challenges, you have a lot of different obstacles, safety, operational, security, what are some of the things that you're taking into account when you're implementing software? What do you think it could be? Not so easy to... What is your approach? What are the things on your mind that is keeping you up at night? Okay, we have two different ways. The main way is to build software and there we have a special case. It's an intern case and we build software that brings us on the point for this case. The other way is we have a way to product data in these cases and that's the other way. So what can we do with this data? That's the other case around Pentau. So we want to have more benefit with this kind of data. What sort of data-driven application development do you do or do you oversee for Bundespolize? Can you describe some of the applications within their specific functions? One main application is our time planning tool. So all the shifts on the agencies can, is possible to planning. That's in one case that we build on this platform and is exclusively for us. So we had the situation that other police in Germany ask us about, hey, that's a very good solution. Maybe we can take it also for us, but because it's a little bit different to normal situations outside in other companies. Because we have the situation 24 hours, seven days a week, 365 days a year to have, to bring our services. And that's, we have big, many rules about this kind of working. So the officers get some more money in the night or at Saturday and something like this that's not so easy to implement it with normal software. So we were at the case what we do. And then, okay, we do it ourselves. And that is exactly on point. Can you describe the rules? Are you describing rules that are provided from the European Union or from your government in terms of security, privacy, and so forth? Is that what you're describing? Okay, so how have this whole set of rules and policies and mandates shaped your data management strategy within your organization? And then how does the Pentaho set of solutions support those requirements? Okay, I think with Pentaho, I told it yesterday also, it was for us definitely the game changer. That's definitely true. And before, we don't have the chance to build something like this only with two us. But now we have the big Swiss knife. We get the entrance with especially with the kettle solution, it seems like a PDI. Yes, kettle, everything is possible. Oh, kettle, I'm sorry, kettle, yes. It's not possible, it's up to you to build your own Java plug-in or so on. That was the entrance to build a strategy about it. Then at this point, we had the solution to let the data flow wherever you want, no? And so then we start, okay, when we can have data at every time, at every point, so what can we do with that, no? What is the benefit for us? And so we start to come in discussion with our other departments inside. What is your problem? What can we do to help you, no? To get more benefit about it. How much sharing goes on between departments? The sharing? Yes, I mean, in terms of, as you said, how can I help you? Oh, we are doing something over here. I think it's a classical job like other, what's it called, consultant? Yeah, it's a typical consultant job. We do it inside, so we go to the other departments and have this part of discussion and we try to bring it in the right way. What degree of sharing of this sharing is intergovernmental, meaning you're reaching out to your peer agencies within the European Union, maybe through Interpol, to other nations, is any of that going on and is Pentaho playing a role in terms of helping you in that regard? In, what's his name, we have to say. If you don't want to say or can't say. Going up with Pentaho. Yeah, yeah. Actually, I think in German or in European, it's not so big. I don't know why, I can't believe it, but it's also, the big advantage at Pentaho is that you can start it every time. You can start with a community addition. We worked also before two years with the community. With the community. And also well and started in this year with the enterprise and we have only one day for migration from the community server of the new enterprise server and no problems. And I think that is a great, great benefit. You can almost start with a small problem or data integration. And it's fantastic. And in the past, the other big companies, maybe they had a little bit earlier the start. So Pentaho has the goal to come along the other players. That's, I think in Europe or especially in Germany, in the moment can be a good seal. We have in Germany, we have a situation over Pentaho user meeting or Pentaho community meetings that also other agencies come and ask for why Pentaho and... How did you do with it? So is there an ongoing program of working with other federal agencies within Germany to share the best practices you've learned from using data to at least to manage your agency's requirements? I think this... What could they learn from what you've done? This progress is starting now. So the other come to us and we meet together and they want to take a look directly on our screens and want to see some cases we play for them live. And that's a very interesting situation. When they see, hey, you have the same problems as I. And it's interesting. And very important is also that we learned, that we have learned from Pentaho that everything is possible. You need much less time for everything or for every kind of problem. We are very fast. Before we used to Pentaho, we had another BI tool. It's called Excel. We need a name. It's crazy. It's good for statistics but we have no data quality. Right, right. Very, very... Again. Yeah, and it's not possible to work with big data. It's impossible. It was Excel. Our data are actual, daily actual. And before we wait for one month or two months... Before we had exactly one day per month, at this day, the data was correct. Only one day. And the other days, we had to collect the data so it's a whole new world with Pentaho. Great. Henry and Michael, thank you so much for coming on theCUBE. It was great having you on here. Thank you very much. We will have more from theCUBE's live coverage of Pentaho World just after this.