Accelerate your career with the 90 Day Mentoring Challenge → Learn More
Chevron, PWC, Power Apps and Azure AI with Mark Slosberg
Chevron, PWC, Power Apps and Azure AI with Mark Slosberg
Chevron, PWC, Power Apps and Azure AI Mark Slosberg
Choose your favorite podcast player

Chevron, PWC, Power Apps and Azure AI with Mark Slosberg

Chevron, PWC, Power Apps and Azure AI with Mark Slosberg

Chevron, PWC, Power Apps and Azure AI
Mark Slosberg

Send me a Text Message here

FULL SHOW NOTES
https://podcast.nz365guy.com/599 

Ever wondered how a technologist with decades of experience balances a vibrant personal life and a transformative career? Our latest episode features Mark Slosberg, the mastermind behind Hanging Valley Enterprises. With a rich history in the tech world and 42 years of marriage, Mark shares his love for cooking in a kitchen tailored for two type-A chefs, his passion for smoking meats and fish, and his joy in hosting family pizza nights. Outside the kitchen, Mark and his wife are committed hikers and gardeners, transforming their property near Seattle into a low-maintenance haven filled with native plant species.

Mark's professional journey is equally compelling. He recalls advocating for SQL Server 2008 at Chevron and spearheading the Microsoft practice at PwC, which significantly integrated Power BI and early PowerApps adoption. His story doesn't end there; after leaving PwC, Mark took on groundbreaking projects using PowerApps and Azure AI, including a successful application for a major seed distributor. His insights reveal how these tools have revolutionized business processes and data management, providing a unique perspective on the evolution of technology in consulting.

In a detailed case study, Mark illustrates the power of custom solutions in business technology. He recounts developing a seed distribution app for an agriculture firm struggling with an outdated JD Edwards system. By prototyping with Power Apps and Power BI, Mark's team enhanced data access and streamlined sales operations. Furthermore, he shares a transformative experience with a billion-dollar firm, where leveraging SQL Server and standardizing data views turned around an underperforming Cognos implementation. Tune in to learn how integrating Power Apps with JD Edwards using APIs can revolutionize backend operations and ensure long-term system efficiency.

Resources Mentioned
First solution in the Microsoft AppSource online solution catalog - https://appsource.microsoft.com/en-us/product/dynamics-365/hangingvalleyenterprisesllc1645487787841.salesenable  

90 Day Mentoring Challenge  10% off code use MBAP at checkout https://ako.nz365guy.com

Support the show

If you want to get in touch with me, you can message me here on Linkedin.

Thanks for listening 🚀 - Mark Smith

Chapters

00:01 - "Tech Career and Life Outside"

13:21 - Evolution of Tech Tools in Business

21:50 - Business Technology Transformation Through Custom Solutions

28:42 - Power Apps Integration With JD Edwards

Transcript

Mark Smith: Welcome to the Power Platform Show. Thanks for joining me today. I hope today's guest inspires and educates you on the possibilities of the Microsoft Power Platform. Now let's get on with the show. Today's guest is from Bo in Washington, united States. He's a principal owner of Hanging Valley Enterprises. He's spent 42 years successfully convincing, selling, planning and delivering profitable information technology business outcomes. Right now, his core technology is a strategic business and solution architecture and successful use of enterprise class Microsoft Cloud technologies. You can find links to his bio, social media, etc. In the show notes for this episode. Welcome to the show, mark.

Mark Slosberg: Thank you, pleasure to be here.

Mark Smith: Good to have you here today. I always like to start with getting to know you so the audience can feel like they have your sense of place. So tell me a bit about food, family and fun. What you do outside your technology skill set.

Mark Slosberg: You bet? Well, I'm working on my 42nd year of marriage and we always joke when it comes to food. We just finished a remodel where this will be our fourth kitchen that we have designed and implemented. This one is a similar to the last one we did, but we bought a little farmhouse outside of Seattle and spent about six months redoing it, and the real, the real focus on that was we have found ourselves to be two type A cooks, so the trick was to build a kitchen that we could both work in without killing each other. But in terms of food, I always joke that I'm on a seafood diet, meaning I see food and I eat it.

Mark Smith: Nice, nice. Do you have any specialty dishes, though, that you like to cook?

Mark Slosberg: Well, we just had pizza night. That's always a good thing with the kids and we've got grandkids and so everybody gets around and they all pick a pizza and they do their own pizzas and we just sort of supervise at that point. But I'm the smoking king and I'm the short order breakfast thing and my wife builds the dishes that have 27,000 instructions.

Mark Smith: Nice, nice. So when you say the smoking, does that mean that you have like one of those ceramic eggs or a smoker and things like that?

Mark Slosberg: Well, I have two things that I use generally. One is I think it's called smoking it, which is a little box smoker, and I use that primarily for the meats. We just did a smoked turkey breast the other day, but I'll do brisket, then I'll do pastrami and all that. But I really enjoy doing fish and so I have a killer black cod or a sable recipe and I do a lot of salmon, lox and smoked salmon, hot and cold smoked. And there I actually have a cold smoker that I just put on an old Weber and it generates just a bunch of smoke but no heat.

Mark Smith: Nice, nice, very cool. Tell me, tell me about what you do when you're not thinking about technology. So, we try to do a lot of hiking.

Mark Slosberg: We do a lot of gardening. We moved out of Seattle about two years ago after almost 50 years I had been there almost 50 years and so we have this big. It's not so big, it's 0.84 of an acre, but it's just a lot of land. But we've got gardening and we do a lot of both ornamental and food, and then I also enjoy, and what we're trying to do with this one is this property backs up on a little slough. We're out in farm country, there's cows everywhere, and so we're looking to put in natives around the slough and sort of reclaim that. So the goal, though, is to build a landscape that has the least amount of maintenance as possible. Nice, and we're not there now, so we have a long way to go with this new piece.

Mark Smith: It sounds like you and I are on similar journeys. So I've got about an acre and a half of land and it's been farmed for 150 odd years and there's only one original tree on the property from when I purchased it and now there's about 3,000, 4,000 trees that I've planted and I'm on a mission to get the property back into more of a forestry but a food forestry. So I'm using a concept called syntropic forestry, which is kind of, you know, around permaculture, and I want to produce as much food, particularly fruit and as well as vegetables, that are all on the land, right, all on my property, and then I'm totally surrounded by cows, as you say, like I've got farming all around me, except for one thing I'm high, so I look out over the Pacific Ocean, which is nice, yeah.

Mark Slosberg: Well, it's interesting. One of the reasons we moved to where we are is we're two miles north of our son and daughter-in-law's 57-acre organic vegetable farm. That took about 10 years for us to get it organized and in, and I'm glad it's theirs and not mine. But they've got about 45 acres under tillage right now and it's pretty exciting it's been.

Mark Slosberg: really it's been very impressive. As a dad, it makes you proud to see them do this, but it's a lot of work, so anyway, so we're there to close the farm, stand and take care of the kids and do stuff like that. So there's a lot of that. That's outside of whatever I'm working.

Mark Smith: I love it. I love it. Listen. In this show I want to really drill into the wisdom of your tech career. How did you get involved in Microsoft technology?

Mark Slosberg: So it's funny because my career is 45 or so years. I got really started in 1981. And I'm actually a forester by training. That is my college training. But I was really into bio math.

Mark Slosberg: But at 20 or 21, I found myself on Saturdays working at the computer land of Bellevue, washington, which was just down the road from the original Microsoft campus the original Microsoft campus and Microsoft was in fact one of our earliest customers at the time and they were buying Apple IIs to put the Z80 card on. They were selling the Z80 card so they could put microsoft basic on to apple twos, and so we were very involved. But I was kind I evolved into an anti-microsoft for many years. I probably would have been a lot richer if I had just gone with the flow. Yeah. But I actually ended up driving towards the earliest low-code tools like dbase2. And I did my original coding in there and then from there moved on to CPM and then Unix, and so I had a long career in Unix all the way up to about 2002.

Mark Slosberg: And I formed my own firm and we sold SEO Xenix and we sold NCR Towers and we did custom application development and we were probably the first Oracle integrator in the Pacific Northwest and that was back in 1985 through 88. And that's when the joke was. When you were asked what platform does Oracle run best on, the answer was the slide projector. But it was one of the original cross-platform tool sets. That's brilliant and it was. It was brilliant and I did. We started selling larger and larger servers. We did very cost-effective Oracle servers back in those days and at some point in the late mid, early to mid 90s picked up Sun as a Sun microsystem. So I was a diehard Unix Solaris guy and I bought into McNeely's. You know he loved to trash Microsoft back in those days and I loved it.

Mark Slosberg: It was great. But I also knew that you know, it was hard to argue with Microsoft in different areas. They just had achieved such a dominance. So when I sold my firm back in 99 and 2000, I sold it as a Sun reseller and as an Oracle database development team and we were very into Java at that point I had. The stories of me getting into Java are just as much fun as my Microsoft stories. But what happened then was towards the early part of 2000, I started getting after I shut the firm down, we sold it and then I worked for that firm for a while and then gradually we sold off different pieces of it.

Mark Slosberg: So in early 2000s, 2003, 2004, I joined a Canadian consulting firm as a partner and they had a Microsoft practice and they were involved in Dynamics and this was, you know, the earliest Dynamics versions, on-prem. And you know I went to training and I did all kinds of things and I thought this is really clever. And of course Salesforce was coming out at the time with a SaaS version and then Dynamics then at that point was on-prem with a SAS version and then Dynamics then at that point was on-prem and I got very interested in particularly because I'd always been doing these low-code types of things. My deviation with Java was all right, I'm going to drop back to a 3GL and I spent a lot of time doing that.

Mark Slosberg: But I was always more interested in what we called fourth generation languages but are now called low-code it's, you know, very hot, hot, trendy term. So I kind of followed it along and I went through a number of large consulting firms. I went from the Canadian firm to a firm called BearingPoint which had spun out of KPMG, and that was an interesting experience Because when I joined BearingPoint we were 17,500 employees and within two years I was one of the last 300 as they sunk into bankruptcy because we learned that consultants are not very good at running public companies. But while I was doing that, I had jumped into a big project at Chevron and Chevron at the time. So this is 2006 through 2009, roughly, and Chevron was a huge Microsoft consumer.

Mark Slosberg: They had probably one of the largest volume license agreements at the time and we were doing I was actually working with management consultants doing a turnaround for, if you can imagine, there was a division of Chevron that wasn't making quite enough money and you know it was a very interesting story about that and they had hired this group of turnaround specialists to do a turnaround and these guys had been working with sort of lightweight Microsoft technologies Excel they were Excel jockeys and a little access and things like that and they had developed the methodology for turning companies around for driving profitability. That was their specialty and they snagged this job at Chevron before BearingPoint was in trouble or actually BearingPoint was already in trouble but nobody knew about it at the time. That's kind of the way that worked. But what was interesting was I got parachuted in after the guy who did the initial design for the software left to go to Microsoft, as it turns out and he's still there, and so he left me with this design and what they had was they had these small scale tools that suddenly had to be made larger. So where they had done things for five or 10 users, suddenly we had 1,200 users and it was determined to go with SharePoint.

Mark Slosberg: So we went, we did, went with SharePoint and I for me it was really the first experience with enterprise class Microsoft tools and there were a lot of issues. I mean, you know, we all know that oftentimes Microsoft releases stuff that's not quite ready for prime time and makes promises to its customers that are slightly in excess or in advance of what's actually being delivered. But it was a hugely successful project because in 18 months we delivered this tool set that was entirely SQL Server, infopath and SharePoint. That was the only tools that we used and it drove profitability from about $3 million a year for this business unit to $300 million a year. And, interestingly enough, that was sustainable for 10 years because I, after I finished that project, I walked away from Chevron, came back almost 10 years to the day and they were still using this application. It was pretty amazing and it's funny because when we implemented it, chevron had very strict enterprise architecture standards and they were not.

Mark Slosberg: This was 2009, they weren't or 2008,. They had yet to certify SQL Server 2008. They were still certified on the previous version and I had to go to bat and say, look, I'm not going to release this software on the old version of SQL Server because it's going to be obsolete. You guys are going to have to upgrade it and do all this kind of stuff. So I forced it and a few of us were forcing their enterprise architecture team to accept sort of a trial usage of the database. And it's funny because when I came back 10 years later, the only reason they were thinking about changing it is because SQL Server 2008 was finally being obsoleted by Microsoft and they needed to make a change. So it was like, ok, that's what's forcing us, but that gives you a little background on you know.

Mark Slosberg: So at that point I had Microsoft stamped all over my face and, through a number of acquisitions, I ended up being acquired, ultimately by Presswaterhouse Coopers PwC, and that was in 2010. I joined them in January of 2010 and spent almost seven years there as a director and managing director. I was a little old to become a partner when you join the firm in there, so it was a bit of a challenge. But what I started as a profitability analyst you know, specialist, how do you use technology to drive profits, et cetera, et cetera. But I always had Microsoft stamped on my forehead.

Mark Slosberg: And when I joined the Seattle office of PwC, I came to find out that they had a tens of million dollar worth of direct consulting business with Microsoft, particularly in compliance and tax, and not traditional reseller business, but just really classic consulting. Interestingly enough, what we found out was that Microsoft would frequently say to the leadership of PwC. You know we give you a lot of money every year for consulting, traditional consulting. It would sure be nice if you had a Microsoft practice, and at the time they literally had no practice.

Mark Slosberg: Had a Microsoft practice and at the time they literally had no practice. There were thousands, tens of thousands of Excel jockeys and people with SQL Server experience and things like that spread throughout the firm, but they did no traditional Microsoft reseller partner consulting. So I spent pretty much my seven years starting and growing that practice, getting them to finally. You know, at the time Oracle Financials was the darling inside of POBC or SAP. Dynamics was not a tool at all that anybody was interested in. It was treated as a low value tool, and so during the seven years that I was there, we affected that change and so as I left, they had just started a Dynamics FinApps practice and CRM practice. We were doing more and more with sort of evolving from SharePoint.

Mark Slosberg: And that's actually how I got into the Power Platform is that this would have been 2016,. Roughly, and I had spent a lot of time helping convert all of the Excel jockeys at the firm into Power BI, basically getting them up to speed. And we started, of course, with Power Pivot. People probably never even heard of that anymore, but that was the first step in going there and I actually did some interesting consulting inside of Microsoft during their product planning exercises when they were looking for I have to be careful how I say this but the discussion was can we find and build a Tableau killer back in those days? And of course, power BI has emerged as that player. So Power BI emerges very familiar with it. We had done a lot of SharePoint work and I had done way more with InfoPath than I ever cared to admit, and we all knew that there were missing pieces in the stack.

Mark Slosberg: And just as I was leaving in my last four to six months at PwC, they were sort of getting ready to release PowerApps. They just bought ADX Studio. So we had meetings with the guy who had sold ADX Studio. He went from being an important CEO to a product manager inside the firm and we had all these meetings and so I got familiar with the fact that they were trying to get PwC to pick up these tools and become an active reseller or, you know, developer of it. And um, and we, pwc and I parted ways in uh November of um, uh, whatever, that was uh 16. Cause it was the day before my 60th birthday, because of course, partners have to retire at a place like PwC at 16. Now, while I technically wasn't a full partner, I was what they call a non-equity partner.

Mark Slosberg: They're pretty much tired of you by that time. So I walked out the door, sat around for a couple of months just sort of saying oh, this is nice. And got back involved, and because I was down the street from Microsoft and I had met a bunch of these people, I talked to them and started looking at Power Apps right in early 2017, when, frankly, the platform was really soft and squishy and half the stuff didn't work the way it was supposed to and there was no documentation and nobody knew what it was doing. But I was intrigued. I was intrigued by the thing and so I built some sample apps and enjoyed that a lot.

Mark Slosberg: And then I went off to return to Chevron, did a very big. When I returned there, I was doing a big Azure backend AI data thing. But while I was there, I started to see Power Apps starting to show up on the desktop at Chevron and again, thinking back to how far backwards they usually are in their enterprise architecture approvals, I was surprised and I said you know, there must be something to this from an enterprise point of view that's going to make it.

Mark Slosberg: And then I jumped back in and the next thing I knew I had nailed down a job with a big commercial seed distributor to do a Power Apps application that is still running right now and I'm in the process of packaging for release in the AppSource.

Mark Smith: Nice, Nice. So give us a. It's interesting your whole InfoPath experience, your SharePoint experience, because I think InfoPath's biggest shortcoming was that it didn't work on a mobile device.

Mark Slosberg: Well, what I will tell you is this is a little story Someone took the app that we built in InfoPath and showed it to the original InfoPath developer and he about had a heart attack. He said I had never imagined and this forget mobile and stuff. We're back a long time ago. This is, you know, 2009. He says I had never imagined anyone in their right mind to do what, what you guys did with this app, and it was not the right thing to do. But you know, sometimes when you have a budget and you have a timeline, you don't get to choose exactly the perfect architecture.

Mark Smith: It's interesting too that these tools are created and then put out into the wild, into the universe, into the business and organizations, and people pick them up and they just you know, they build things with them and I love that. You know that story there, that what he intended he couldn't believe. You know what people had forward and taken and turned into something else, and I think we see this all the time with the Power Platform. Tell us a bit about the seed application as in what's it designed to do, who's it for and what are your thoughts around it.

Mark Slosberg: Yeah, so it's been fascinating. So, as I mentioned, my son has this farm two miles away. He was working for probably the largest seed distributor in the country top on the global side and it was an interesting firm. He worked for the seed distribution unit, which is about $130 million in revenue so a big company, not teeny, but they were a subsidiary of a bigger billion-dollar firm that does all kinds of other agriculture-related products fertilizers and chemicals and a myriad of products and in fact they have. Of that, billion dollars of revenue is spread across 32 separate subsidiaries.

Mark Slosberg: Wow, okay, those 32 separate subsidiaries were all running on one single instance. And when I say were, they are still and they will be for the foreseeable future, till long after I'm gone is what I predict? Wow, on a single, very large instance of JD Edwards that's 25 years old maybe 28 by this time and it's so old that it predates the purchase by Oracle. And so back in those days when you bought JD Edwards, you could pick which database was going to be on the backend, and of course it was SQL Server. Now, if they had bought it, you know, 10 years later or something after the thing, it would have been an Oracle database, but anyway. So as a result of this, each subsidiary was not allowed to make any customizations whatsoever to the app and, to their credit, they were very disciplined about it and that's the only reason it's running today, 25 or 28 years later, is that they could take all the updates. Whenever JD Edwards sent an update, they could take it and apply it.

Mark Slosberg: Now the problem was that that meant that this distributor did not get any customization whatsoever. Was that? That meant that this distributor did not get any customization whatsoever? And it was a vintage 1985 Java web service application which I knew well because I built a lot of those in the old days Ugly boring web-based interface, not very much fun and very few people actually in the organization could actually use it.

Mark Slosberg: They had some very highly trained but really just you know pretty much data monkeys, unfortunately, that would use the system and the salespeople were out selling all over the country in the wilds, wherever they were. You know they were visiting farms and ranches and things wherever they happened to be, both in the US and in Mexico, and if they had a question about do we have this seed to sell? How much of this seed do we have? How much is it going to be. How quickly can I get it? Can I get more?

Mark Slosberg: All of those types of questions required phone calls, emails, texts, every imaginable communication with a sales coordinator, of which they had a team of 25. There was probably 25 salespeople teamed up with 15 or 20 sales coordinators and it was all manual, every bit of it, and texts were getting lost and emails were getting lost and calls were being missed and it was just painful and it was interesting because they were trying to grow at the time and they brought in a couple of salespeople from another company. They kind of picked them up, as they say, and they all said you know, mr President, I'll spare the names and all you need to buy a CRM system. And they're all telling him you need a CRM system. And that was because, from the old company they were at, they were using something that they called a CRM system.

Mark Slosberg: Now, nobody knew what the actual functionality was, but it was being treated as a CRM system because that's what they said it was. But it was being treated as a CRM system because that's what they said it was. So one day I get a call from the CEO and he knew from my son that I did this kind of work. He says, mark, everybody's telling me I need a CRM system and I don't know what to do. Can you help me? And so I said yeah, and so I took a small entry, sort of discovery project.

Mark Slosberg: I said I'll come in, I'll figure out what's going on. I'll figure out what these people are asking for and see what the requirements are and examine your backend to see what's going on, because some people had said, oh well, you could switch to a new accounting system. Well, that wasn't going to happen, but that's you know. Somebody would say, well, we'll just go buy a new accounting system. And there was a lot of unrealistic conversation, which is pretty much typically what happens and it became very clear very early in the discussion that they did not need a CRM system. They didn't even know what a CRM system did. The notion of an opportunity and turning into a, you know, a prospect turning into a customer and an opportunity turning into a sale that was not what they were tracking. These were established customers. They had different kinds of customers in different parts of the country. None of them would have worked in a standard CRM thing and all the sales guys had their own way of doing things. So the last thing they wanted was something standardized. But what they did need is they needed access, information, access to the central servers, and they needed it at their fingertips, whether that was Now.

Mark Slosberg: Initially they weren't thinking mobile devices, although that very rapidly moved into that form. They were initially thinking laptops that they have out in the wilds, and so I did a little bit of prototyping to see whether I could use a Power App to get to, and, as it turned out, there was two aspects to this project. The first aspect was getting the information out to the salespeople. The other aspect was that they had a controller who was a very good controller who didn't know anything about database systems whatsoever. This just had no idea. And he had gotten all hooked up with Power BI and built this really, really sophisticated, very cool dashboard that everyone was bought into. They said this is incredible.

Mark Slosberg: The only problem was that they were populating the data entirely manually, with stripping out data strips and sticking them in and doing this, and the truth was the dashboard could barely be updated and be ready six weeks after the close of a period. It was just. That was just the reality of it. Now, on top of that, this firm the larger billion dollar firm they'd spent several million probably five to 10, I don't know exactly on Cognos and they had a huge Cognos implementation and the problem there was all the Cognos reports were wrong because nobody had reconciled the data and done data validation and partly because each sub was using. Now, they couldn't customize the software, but they could customize how they use the fields, so that meant any standard reporting couldn't be used across the companies. So they handed me this dashboard and said, oh and, while you're at it, can you hook this up so that it generates a thing? Well, as it turned out, while they'd spent a humongous amount, of money on this Cognos and weren't getting much value.

Mark Slosberg: 

What they were getting and what they did have, was an amazing data replication engine in SQL Server. Everything from the transactionals, the OLTP, was being replicated in a data warehouse every five minutes. So we actually had real-time inventory data or as real-time as was needed Five minutes was fine and so I had total access to this, and they gave me one SQL programmer who sort of knew where the data was at a very, very raw level.

Mark Slosberg: And what we did is we did a two-pronged assignment. The first thing we did was we standardized the views from all of that data, and that was very, very painful. It was not. There was a certain amount of data cleansing, there was a lot of data validation and mostly it was creating views that were correct, that reflected the information as it was supposed to be reflected for the seed company.

Mark Slosberg: And then what I did was I built some screens in Power Apps that would pull this stuff up in real time so that a salesperson could go in and say, hey, do I have this, do I have that? When can I have it? When's it coming in? What does the purchase orders look like? Which warehouse is it sitting in? All those things.

Mark Slosberg: So we had views that put that up and I just displayed them in Power Apps. And that was kind of interesting because I had to work through some design patterns. You start by putting the connectivity directly into Power Apps and that was clearly not performing adequately and the Power Apps were not really designed for that kind of volume of data. But we quickly created a design pattern. I kind of copied one from one of the guys that was out there pitching things and put in a Power Automate flow in between and just use that as the design pattern and just replicated it repeatedly for all the things with the stored procedures. So we did all that. And then I contracted with a Power BI specialist. So I did all of the data cleansing the views and all that, and then I did all the Power Apps development.

Mark Slosberg: And then I got a guy who was a really strong Power BI guy and I said here is this dashboard that they really like that. They don't know how to get populated. And we then together, because we were sitting in this data core, we built all the data flows so that that refreshed once a day or twice a day as necessary. And the CEO still uses that. Every morning he comes in and he gets what did I sell yesterday? What didn't I sell yesterday? All of those questions can be answered how profitable, who's selling, who's not, which of the salespeople are doing it.

Mark Slosberg: We implemented some hierarchical data controls so that the sales guy saw his data, the sales manager saw all the data for his salespeople and then the management layer were able to look across all the sales regions and do that. So we did these in tandem and then, while I was working on the Power Apps, we really started to talk about once we had the basic queries into the JD Edwards instance. Then it became how can we make this whole process efficient, more efficient, and how can we control what gets done and make it more standardized, because the salespeople are all going to sell the way they want to sell, but the backend processes need to be standardized and we went very, very far in terms of pulling all these together and we ended up creating a full-on pending order entry system, integrated with the query, so that salespeople could actually build.

Mark Slosberg: They would typically be called core quotes. It would be a quote that's not a sales order. They didn't like that term, so we called it a pending order. It had all of the same thing like a shopping cart, same kind of concepts in there. So we built shopping carts and all those things and then the real key was to hook it back to JD Edwards and that was a really fun part of the project, because everybody talks about uploading orders through an API but very few people can do it. We dabbled a little bit with some of the early Power Automate tools, but they weren't solid enough. It turns out that Oracle and JD Edwards had a pretty nice API builder orchestrator tool on their side, so they're internal IT guys. We worked together to create a contract and, with using Power BI, automate and Flows, I basically call the API, I drop the JSON record into JD Edwards, they pick it up and they go ahead and process it. I turned this thing over to them about a year and a half two years ago and it's still working.

Mark Smith: Wow, this is amazing, so good. I was thinking about the title for the show, and of course, it's going to be Power Apps over JD Edwards, because it's not something that you commonly hear. When you mentioned JD Edwards, I was like I had to go back to my mind the last time I heard of.

Mark Slosberg: JD Edwards. So, as an aside, there are still 9,000 worldwide implementations of JD Edwards, I believe it. Yeah, and I'm sure Oracle was planning on killing them all and pushing them into Oracle Financials, but that didn't happen.

Mark Smith: Yeah, the other thing I took away from that is the value of keeping a clean core in your systems, because they kept that clean core in JD Edwards and didn't do the modification there. It's enabled them to sweat that asset for a heck of a long time. Obviously we're well over time. I just will still wrap with one final question for you, and that is your observation now of the Power Platform what you can do with Power Apps, Power Automate, Power Pages, which, of course, was originally that ADX Studio product you talked about in its current iteration and form. What's your thoughts around? One, the robustness of it, the enterprise nature of it, the usefulness of it to extract data from anywhere across the organization not really who cares what the backend systems are to build assets that are highly mobile, useful for the use cases of a modern world.

Mark Slosberg: So it's interesting Now that I've done this for really a long time now I'm like I can't even believe how long I've been doing this. You know, early on I cursed every minute that I had to work on it because it didn't. Nobody knew how to do it. There was no documentation on syntax he had there was. The syntax for Power Automate was different than the syntax for Power Apps. And then I had to do all the SQL syntax on the backend and it was a nightmare to do and yet it couldn't be done any other way. You know what I'm saying. In other words, it was a nightmare to do and yet it couldn't be done any other way. You know what I'm saying. In other words, it was a unique, it's a unique set of power all put together, and then you combine that with the data flows and Power BI.

Mark Slosberg: The problem is the early promise of it being something that is appropriate for smaller or middle-sized companies to use is, I think, still elusive out there. You just have to know a lot, and I'm kind of a maniac. I've been trying to teach a few people how to do things and stuff, but part of what I do is because I've done this for 42 years. I have stuff in my head that I can call on, but to think about how you were going to learn this from scratch, I think that's still a challenge. So that's part of it. I think, weirdly, copilot has been just a huge thing because, you know, it allows me not to have to know everything. I can just ask when I know what I want to do, just tell me how to do it kind of thing.

Mark Slosberg: So that part's amazing. I am still struggling, I'm beating, the app is rock solid and I could build rock solid apps and I'm very comfortable and I would swear that to everyone. I'm building a system for my son's farm right now for vegetable production control, and I'm finally forced myself to go and learn model-driven apps and have them, you know, use them in a certain type of application versus Canvas and all that. I am trying to publish right now into AppSource and I'm finding that it's very similar to where it was, you know, three, four, five years ago, where stuff doesn't quite work the way it's supposed to and the documentation's sort of weird and there's a video that sort of does it, but then when it fails, there's no, you know there's, and that's where the challenges are. It's in that part.

Mark Smith: AppSource is changing all the time and it's recently gone through a bunch of changes that make it, dare I say, more confusing at the moment than enlightening. So I totally get what you mean. Thank you, mark, so much for coming on the show. I loved your story. There's other areas I wanted to delve in as you went through, because you know I have a background in some micro systems. I wanted to reminisce a bit about that and the Solaris, and you know I bought a bunch of Solaris machines back in the day for the org I was working for. So but we're out of time. Thank you so much for coming on the show.

Mark Slosberg: All right. Well, it's a pleasure. I look forward to talking to you again sometime.

Mark Smith: Hey, thanks for listening. I'm your host business application MVP Mark Smith, otherwise known as the NZ365 guy. If there's a guest you'd like to see on the show, please message me on LinkedIn. If you want to be a supporter of the show, please check out buymeacoffeecom. Forward slash NZ365guy. Stay safe out there and shoot for the stars.

Mark Slosberg Profile Photo

Mark Slosberg

Mark D. Slosberg has spent 44 years successfully conceiving, selling, planning and delivering profitable information technology, business consulting and independent project development while leading and managing the organizations providing these services.

Current Activities
Currently, he is a leader in transforming businesses and their operations with the successful use of enterprise-class Microsoft cloud technologies with a focus on the Microsoft Power Platform, Azure, Microsoft Office 365 and Dynamics, and along with cloud services from other vendors (AWS, Google, Salesforce, Box, Workday, etc.) to build unique and global online solutions.

While his technical and business skills span a broad array of experiences and technologies, he is generally asked to provide Strategic Business and Solution Architecture consulting to companies across the full spectrum of industries and sizes.

After almost 7 years as a Managing Director at PwC, he restarted Hanging Valley Enterprises, LLC to:
* help individuals and organizations build and leverage skills around the use of readily available cloud technology to enhance business value specifically the Microsoft Power Platform.
* deliver new Power Platform solutions into the marketplace.

His Industry Sector experience includes:
* Financial and Portfolio Management
* Profitability Performance Maximization including Financial Turnarounds
* Tax and Compliance Services
* Product Distribution (specifically Agricultural Products)
* Judicial Case Management, Scheduling and Da… Read More