Click here to close now.

Welcome!

Microsoft Cloud Authors: Liz McMillan, Elizabeth White, Pat Romanski, Jaynesh Shah, Carmen Gonzalez

Related Topics: PowerBuilder, Microsoft Cloud

PowerBuilder: Article

The PowerBuilder .NET IDE

For the past year plus I've been spending a lot of time working with a web-based BI tool

For the past year plus I've been spending a lot of time working with a web-based BI tool (the development is actually done in a plug-in to Eclipse, but the end users access the results through a browser). The tool reminds me a lot of the DataWindow. You create objects that can either map directly to a database table or are based on textual SQL. Those objects are then combined into a composite object that the user can access to do ad-hoc queries without having to know how the underlying tables are related. The data connection is abstracted from the data access layer, and the reports it generates have an extensive event model that can be coded to respond to a wide variety of system events and user interactions.

That being said, it also reminds me of PowerBuilder and the DataWindow because as powerful as it is, it can also be extremely frustrating to work with. It rewrites the SQL in the composite objects, and sometimes it undoes a rather complicated operation that I didn't need rewritten. At that point I'm left trying to find a way to isolate my complicated operation so that the tool doesn't try to rewrite it for me.

I have been having similar problems with PowerBuidler .NET 12.5 lately. One of the updates in the .NET Framework 4.5 is a native Ribbon control for WPF. There was one in the .NET Framework 4.0, but it looks like it might have been a WPF wrapper around a non-WPF control. I wanted to try out the new control, so I installed the new framework. As soon as I did, I could no longer compile *any* WPF applications. So I uninstalled .NET 4.5, at which point I couldn't even run PowerBuilder .NET any longer. I ended up having to (a) uninstall .NET 4.5, (b) uninstall PowerBuilder 12.5, (c) reinstall PowerBuiler 12.5 and (d) reinstall .NET 4.0. Yes, I had to reinstall the previous version of .NET to completely clean it up.

I'm not sure it's PowerBuilder .NET's fault. I've got a lot of software tools on this machine, including multiple copies of Visual Studio, the Windows SDK, etc. Sybase wasn't able to replicate it with a fairly clean install. I was also setting up a second machine that had MS SQL Server 2012 on it, which also installs a couple of the Visual Studio 2010 shells. Since PowerBuilder.NET needed the Windows SDK, I attempted to install that. However, that wouldn't install until I removed all traces of the Visual Studio 2010 shells that MS SQL Server installed. It seems it's not that uncommon for Microsoft .NET related tools and SDKs to step on each other.

For what it's worth, that particular pain point was enough to finally convince me to start using virtual machines and to put the different development tools (and versions of different development tools) on different virtual machines. Once I got started (I'm using Oracle's VirtualBox, which is free), I'm surprised at how simple it is and wondered why I waited. The only snag so far is that I had to order more memory for my laptop and desktop. And eventually I might need to do hard drive upgrades. But it's better than the nightmare of software conflicts that I had to keep dealing with. If I do run into configuration problems in the future, I can just send tech support the VM image so they can see exactly what I'm dealing with.

That's all well and good, but what's the point you're probably asking. Well, all this pain got me thinking about how much pain we're willing to put up with to continue to use products that we like. There's got to be some point where the pain we experience from the tool not working the way we need it to overrides the benefits, at which point we start looking for some new development tool. With PowerBuilder the pain isn't really new. As long as I've been using the tool, and that's been for just about all the time it's been around, there's always been a point using it when it's a struggle to get it to do something, often times because something's not working the way it's supposed to. At one point somebody commented, and I think there's a lot of truth to it, that using it was like playing soccer in a minefield. The tool was buggy, but the people who had been using it for a while knew what the bugs (mines) were and avoided them, so they were successful using it. People who were new to the tool kept running into the mines, and wondered why the more experienced people even bothered using it.

I think the key for the product at that time, as well as for some of the other tools I've mentioned, is that the pain factor only reared its head after you'd been using it and being productive with it for a while. So you had some feel for what the tool could do and liked it, and you were willing to put up with the pain to continue to achieve the benefits. That's important, because if you start experiencing the pain point sooner than that, you won't get a feel for the advantages that the tool offers and wouldn't be motivated to continue using it.

I also got to thinking that this may be the reason that some people aren't as excited with the PowerBuilder .NET IDE as I am. Of course, I'd already been doing .NET development using Visual Studio for quite some time by the time that PowerBuilder .NET became available, so I was already familiar with the advantages that a .NET development tool offers. But for people who aren't sold on the benefits of .NET just yet, I'm not sure if some of the pain points associated with using that IDE aren't enough to keep people from using it before they get to the point where they realize the benefits. In particular, when I want to have PowerBuilder .NET interact with some .NET classes, I'm often starting with what I know is working C# code. I might even have created a small sample of what I needed to do in C# first. So when I'm working in PowerBuilder.NET, I'm mostly converting the C# code into the syntax that PowerBuilder .NET will accept. People who aren't that experienced with C# - or who aren't starting off with working C# code - face a double burden because they often don't know what the script is supposed to look like yet.

So, I do feel your pain. I know that I can find the .NET IDE a struggle to work with at times, and I imagine it's much more of a struggle for people new to .NET. We need to encourage SAP to work on making PowerBuilder.NET even simpler to use, particularly for people who are new to .NET. Customers will never learn to appreciate what it can do if they have trouble with it when they first start using it. Eventually you hit roadblocks with any tool, but they should come when you're pushing the envelope, not when you've first using it.

More Stories By Bruce Armstrong

Bruce Armstrong is a development lead with Integrated Data Services (www.get-integrated.com). A charter member of TeamSybase, he has been using PowerBuilder since version 1.0.B. He was a contributing author to SYS-CON's PowerBuilder 4.0 Secrets of the Masters and the editor of SAMs' PowerBuilder 9: Advanced Client/Server Development.

Comments (2) View Comments

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


Most Recent Comments
mlibner 04/29/13 10:18:00 AM EDT

I agree completely. I struggled with the same problems until I installed PB.net and Visual Studio on a different VMs. SAP needs to continue developing the tool to reach its full potential. If people will step out of their comfort zone and give PB.net a chance (instead of bashing it) they will see how much easier integrating with other .net developers, vendors, tools, controls etc. it is than Classic. When a hammer is the only tool you have everything tends to look like a nail.

Dimitri Joosten 12/29/12 08:18:00 AM EST

Totally agree on this article! I find myself in solving problems in C# first and then "translate" it into PB script. To me PB.Net is the best PB yet as you can do much more with it once you know how .Net and XAML works.I know for many people it will be a learning curve. I hope SAP comes with improvements on the product soon with new targets like HTML 5 and winRT and an upgrade to .Net 4.5

@ThingsExpo Stories
P2P RTC will impact the landscape of communications, shifting from traditional telephony style communications models to OTT (Over-The-Top) cloud assisted & PaaS (Platform as a Service) communication services. The P2P shift will impact many areas of our lives, from mobile communication, human interactive web services, RTC and telephony infrastructure, user federation, security and privacy implications, business costs, and scalability. In his session at @ThingsExpo, Robin Raymond, Chief Architect at Hookflash, will walk through the shifting landscape of traditional telephone and voice services ...
Explosive growth in connected devices. Enormous amounts of data for collection and analysis. Critical use of data for split-second decision making and actionable information. All three are factors in making the Internet of Things a reality. Yet, any one factor would have an IT organization pondering its infrastructure strategy. How should your organization enhance its IT framework to enable an Internet of Things implementation? In his session at Internet of @ThingsExpo, James Kirkland, Chief Architect for the Internet of Things and Intelligent Systems at Red Hat, described how to revolutioniz...
The world is at a tipping point where the technology, the device and global adoption are converging to such a point that we will see an explosion of a world where smartphone devices not only allow us to talk to each other, but allow for communication between everything – serving as a central hub from which we control our world – MediaTek is at the heart of both driving this and allowing the markets to drive this reality forward themselves. The next wave of consumer gadgets is here – smart, connected, and small. If your ambitions are big, so are ours. In his session at @ThingsExpo, Jack Hu, D...
The security devil is always in the details of the attack: the ones you've endured, the ones you prepare yourself to fend off, and the ones that, you fear, will catch you completely unaware and defenseless. The Internet of Things (IoT) is nothing if not an endless proliferation of details. It's the vision of a world in which continuous Internet connectivity and addressability is embedded into a growing range of human artifacts, into the natural world, and even into our smartphones, appliances, and physical persons. In the IoT vision, every new "thing" - sensor, actuator, data source, data con...
All major researchers estimate there will be tens of billions devices - computers, smartphones, tablets, and sensors - connected to the Internet by 2020. This number will continue to grow at a rapid pace for the next several decades. With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo, June 9-11, 2015, at the Javits Center in New York City. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be
SYS-CON Events announced today that MetraTech, now part of Ericsson, has been named “Silver Sponsor” of SYS-CON's 16th International Cloud Expo®, which will take place on June 9–11, 2015, at the Javits Center in New York, NY. Ericsson is the driving force behind the Networked Society- a world leader in communications infrastructure, software and services. Some 40% of the world’s mobile traffic runs through networks Ericsson has supplied, serving more than 2.5 billion subscribers.
The 4th International Internet of @ThingsExpo, co-located with the 17th International Cloud Expo - to be held November 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA - announces that its Call for Papers is open. The Internet of Things (IoT) is the biggest idea since the creation of the Worldwide Web more than 20 years ago.
SYS-CON Events announced today that O'Reilly Media has been named “Media Sponsor” of SYS-CON's 16th International Cloud Expo®, which will take place on June 9–11, 2015, at the Javits Center in New York City, NY. O'Reilly Media spreads the knowledge of innovators through its books, online services, magazines, and conferences. Since 1978, O'Reilly Media has been a chronicler and catalyst of cutting-edge development, homing in on the technology trends that really matter and spurring their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participa...
We’re entering a new era of computing technology that many are calling the Internet of Things (IoT). Machine to machine, machine to infrastructure, machine to environment, the Internet of Everything, the Internet of Intelligent Things, intelligent systems – call it what you want, but it’s happening, and its potential is huge. IoT is comprised of smart machines interacting and communicating with other machines, objects, environments and infrastructures. As a result, huge volumes of data are being generated, and that data is being processed into useful actions that can “command and control” thi...
There will be 150 billion connected devices by 2020. New digital businesses have already disrupted value chains across every industry. APIs are at the center of the digital business. You need to understand what assets you have that can be exposed digitally, what their digital value chain is, and how to create an effective business model around that value chain to compete in this economy. No enterprise can be complacent and not engage in the digital economy. Learn how to be the disruptor and not the disruptee.
Buzzword alert: Microservices and IoT at a DevOps conference? What could possibly go wrong? In this Power Panel at DevOps Summit, moderated by Jason Bloomberg, the leading expert on architecting agility for the enterprise and president of Intellyx, panelists will peel away the buzz and discuss the important architectural principles behind implementing IoT solutions for the enterprise. As remote IoT devices and sensors become increasingly intelligent, they become part of our distributed cloud environment, and we must architect and code accordingly. At the very least, you'll have no problem fil...
There's Big Data, then there's really Big Data from the Internet of Things. IoT is evolving to include many data possibilities like new types of event, log and network data. The volumes are enormous, generating tens of billions of logs per day, which raise data challenges. Early IoT deployments are relying heavily on both the cloud and managed service providers to navigate these challenges. In her session at Big Data Expo®, Hannah Smalltree, Director at Treasure Data, discussed how IoT, Big Data and deployments are processing massive data volumes from wearables, utilities and other machines...
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo in Silicon Valley. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place Nov 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 17th Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal an...
The worldwide cellular network will be the backbone of the future IoT, and the telecom industry is clamoring to get on board as more than just a data pipe. In his session at @ThingsExpo, Evan McGee, CTO of Ring Plus, Inc., discussed what service operators can offer that would benefit IoT entrepreneurs, inventors, and consumers. Evan McGee is the CTO of RingPlus, a leading innovative U.S. MVNO and wireless enabler. His focus is on combining web technologies with traditional telecom to create a new breed of unified communication that is easily accessible to the general consumer. With over a de...
Disruptive macro trends in technology are impacting and dramatically changing the "art of the possible" relative to supply chain management practices through the innovative use of IoT, cloud, machine learning and Big Data to enable connected ecosystems of engagement. Enterprise informatics can now move beyond point solutions that merely monitor the past and implement integrated enterprise fabrics that enable end-to-end supply chain visibility to improve customer service delivery and optimize supplier management. Learn about enterprise architecture strategies for designing connected systems tha...
From telemedicine to smart cars, digital homes and industrial monitoring, the explosive growth of IoT has created exciting new business opportunities for real time calls and messaging. In his session at @ThingsExpo, Ivelin Ivanov, CEO and Co-Founder of Telestax, shared some of the new revenue sources that IoT created for Restcomm – the open source telephony platform from Telestax. Ivelin Ivanov is a technology entrepreneur who founded Mobicents, an Open Source VoIP Platform, to help create, deploy, and manage applications integrating voice, video and data. He is the co-founder of TeleStax, a...
The Internet of Things (IoT) promises to evolve the way the world does business; however, understanding how to apply it to your company can be a mystery. Most people struggle with understanding the potential business uses or tend to get caught up in the technology, resulting in solutions that fail to meet even minimum business goals. In his session at @ThingsExpo, Jesse Shiah, CEO / President / Co-Founder of AgilePoint Inc., showed what is needed to leverage the IoT to transform your business. He discussed opportunities and challenges ahead for the IoT from a market and technical point of vie...
Grow your business with enterprise wearable apps using SAP Platforms and Google Glass. SAP and Google just launched the SAP and Google Glass Challenge, an opportunity for you to innovate and develop the best Enterprise Wearable App using SAP Platforms and Google Glass and gain valuable market exposure. In his session at @ThingsExpo, Brian McPhail, Senior Director of Business Development, ISVs & Digital Commerce at SAP, outlined the timeline of the SAP Google Glass Challenge and the opportunity for developers, start-ups, and companies of all sizes to engage with SAP today.
Cultural, regulatory, environmental, political and economic (CREPE) conditions over the past decade are creating cross-industry solution spaces that require processes and technologies from both the Internet of Things (IoT), and Data Management and Analytics (DMA). These solution spaces are evolving into Sensor Analytics Ecosystems (SAE) that represent significant new opportunities for organizations of all types. Public Utilities throughout the world, providing electricity, natural gas and water, are pursuing SmartGrid initiatives that represent one of the more mature examples of SAE. We have s...
The Internet of Things will put IT to its ultimate test by creating infinite new opportunities to digitize products and services, generate and analyze new data to improve customer satisfaction, and discover new ways to gain a competitive advantage across nearly every industry. In order to help corporate business units to capitalize on the rapidly evolving IoT opportunities, IT must stand up to a new set of challenges. In his session at @ThingsExpo, Jeff Kaplan, Managing Director of THINKstrategies, will examine why IT must finally fulfill its role in support of its SBUs or face a new round of...