Click here to close now.

Welcome!

.NET Authors: Pat Romanski, Andreas Grabner, Elizabeth White, Tad Anderson, Gregor Petri

Related Topics: PowerBuilder, .NET

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
SYS-CON Events announced today that Dyn, the worldwide leader in Internet Performance, will exhibit at 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. Dyn is a cloud-based Internet Performance company. Dyn helps companies monitor, control, and optimize online infrastructure for an exceptional end-user experience. Through a world-class network and unrivaled, objective intelligence into Internet conditions, Dyn ensures traffic gets delivered faster, safer, and more reliably than ever.
Advanced Persistent Threats (APTs) are increasing at an unprecedented rate. The threat landscape of today is drastically different than just a few years ago. Attacks are much more organized and sophisticated. They are harder to detect and even harder to anticipate. In the foreseeable future it's going to get a whole lot harder. Everything you know today will change. Keeping up with this changing landscape is already a daunting task. Your organization needs to use the latest tools, methods and expertise to guard against those threats. But will that be enough? In the foreseeable future attacks w...
HP and Aruba Networks on Monday announced a definitive agreement for HP to acquire Aruba, a provider of next-generation network access solutions for the mobile enterprise, for $24.67 per share in cash. The equity value of the transaction is approximately $3.0 billion, and net of cash and debt approximately $2.7 billion. Both companies' boards of directors have approved the deal. "Enterprises are facing a mobile-first world and are looking for solutions that help them transition legacy investments to the new style of IT," said Meg Whitman, Chairman, President and Chief Executive Officer of HP...
Containers and microservices have become topics of intense interest throughout the cloud developer and enterprise IT communities. Accordingly, attendees at the upcoming 16th Cloud Expo at the Javits Center in New York June 9-11 will find fresh new content in a new track called PaaS | Containers & Microservices Containers are not being considered for the first time by the cloud community, but a current era of re-consideration has pushed them to the top of the cloud agenda. With the launch of Docker's initial release in March of 2013, interest was revved up several notches. Then late last...
The Workspace-as-a-Service (WaaS) market will grow to $6.4B by 2018. In his session at 16th Cloud Expo, Seth Bostock, CEO of IndependenceIT, will begin by walking the audience through the evolution of Workspace as-a-Service, where it is now vs. where it going. To look beyond the desktop we must understand exactly what WaaS is, who the users are, and where it is going in the future. IT departments, ISVs and service providers must look to workflow and automation capabilities to adapt to growing demand and the rapidly changing workspace model.
As organizations shift toward IT-as-a-service models, the need for managing and protecting data residing across physical, virtual, and now cloud environments grows with it. CommVault can ensure protection &E-Discovery of your data – whether in a private cloud, a Service Provider delivered public cloud, or a hybrid cloud environment – across the heterogeneous enterprise. In his session at 16th Cloud Expo, Randy De Meno, Chief Technologist - Windows Products and Microsoft Partnerships, will discuss how to cut costs, scale easily, and unleash insight with CommVault Simpana software, the only si...
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...
Even as cloud and managed services grow increasingly central to business strategy and performance, challenges remain. The biggest sticking point for companies seeking to capitalize on the cloud is data security. Keeping data safe is an issue in any computing environment, and it has been a focus since the earliest days of the cloud revolution. Understandably so: a lot can go wrong when you allow valuable information to live outside the firewall. Recent revelations about government snooping, along with a steady stream of well-publicized data breaches, only add to the uncertainty
The explosion of connected devices / sensors is creating an ever-expanding set of new and valuable data. In parallel the emerging capability of Big Data technologies to store, access, analyze, and react to this data is producing changes in business models under the umbrella of the Internet of Things (IoT). In particular within the Insurance industry, IoT appears positioned to enable deep changes by altering relationships between insurers, distributors, and the insured. In his session at @ThingsExpo, Michael Sick, a Senior Manager and Big Data Architect within Ernst and Young's Financial Servi...
Hadoop as a Service (as offered by handful of niche vendors now) is a cloud computing solution that makes medium and large-scale data processing accessible, easy, fast and inexpensive. In his session at Big Data Expo, Kumar Ramamurthy, Vice President and Chief Technologist, EIM & Big Data, at Virtusa, will discuss how this is achieved by eliminating the operational challenges of running Hadoop, so one can focus on business growth. The fragmented Hadoop distribution world and various PaaS solutions that provide a Hadoop flavor either make choices for customers very flexible in the name of opti...
The explosion of connected devices / sensors is creating an ever-expanding set of new and valuable data. In parallel the emerging capability of Big Data technologies to store, access, analyze, and react to this data is producing changes in business models under the umbrella of the Internet of Things (IoT). In particular within the Insurance industry, IoT appears positioned to enable deep changes by altering relationships between insurers, distributors, and the insured. In his session at @ThingsExpo, Michael Sick, a Senior Manager and Big Data Architect within Ernst and Young's Financial Servi...
PubNub on Monday has announced that it is partnering with IBM to bring its sophisticated real-time data streaming and messaging capabilities to Bluemix, IBM’s cloud development platform. “Today’s app and connected devices require an always-on connection, but building a secure, scalable solution from the ground up is time consuming, resource intensive, and error-prone,” said Todd Greene, CEO of PubNub. “PubNub enables web, mobile and IoT developers building apps on IBM Bluemix to quickly add scalable realtime functionality with minimal effort and cost.”
Sensor-enabled things are becoming more commonplace, precursors to a larger and more complex framework that most consider the ultimate promise of the IoT: things connecting, interacting, sharing, storing, and over time perhaps learning and predicting based on habits, behaviors, location, preferences, purchases and more. In his session at @ThingsExpo, Tom Wesselman, Director of Communications Ecosystem Architecture at Plantronics, will examine the still nascent IoT as it is coalescing, including what it is today, what it might ultimately be, the role of wearable tech, and technology gaps stil...
With several hundred implementations of IoT-enabled solutions in the past 12 months alone, this session will focus on experience over the art of the possible. Many can only imagine the most advanced telematics platform ever deployed, supporting millions of customers, producing tens of thousands events or GBs per trip, and hundreds of TBs per month. With the ability to support a billion sensor events per second, over 30PB of warm data for analytics, and hundreds of PBs for an data analytics archive, in his session at @ThingsExpo, Jim Kaskade, Vice President and General Manager, Big Data & Ana...
In the consumer IoT, everything is new, and the IT world of bits and bytes holds sway. But industrial and commercial realms encompass operational technology (OT) that has been around for 25 or 50 years. This grittier, pre-IP, more hands-on world has much to gain from Industrial IoT (IIoT) applications and principles. But adding sensors and wireless connectivity won’t work in environments that demand unwavering reliability and performance. In his session at @ThingsExpo, Ron Sege, CEO of Echelon, will discuss how as enterprise IT embraces other IoT-related technology trends, enterprises with i...
When it comes to the Internet of Things, hooking up will get you only so far. If you want customers to commit, you need to go beyond simply connecting products. You need to use the devices themselves to transform how you engage with every customer and how you manage the entire product lifecycle. In his session at @ThingsExpo, Sean Lorenz, Technical Product Manager for Xively at LogMeIn, will show how “product relationship management” can help you leverage your connected devices and the data they generate about customer usage and product performance to deliver extremely compelling and reliabl...
The Internet of Things (IoT) is causing data centers to become radically decentralized and atomized within a new paradigm known as “fog computing.” To support IoT applications, such as connected cars and smart grids, data centers' core functions will be decentralized out to the network's edges and endpoints (aka “fogs”). As this trend takes hold, Big Data analytics platforms will focus on high-volume log analysis (aka “logs”) and rely heavily on cognitive-computing algorithms (aka “cogs”) to make sense of it all.
One of the biggest impacts of the Internet of Things is and will continue to be on data; specifically data volume, management and usage. Companies are scrambling to adapt to this new and unpredictable data reality with legacy infrastructure that cannot handle the speed and volume of data. In his session at @ThingsExpo, Don DeLoach, CEO and president of Infobright, will discuss how companies need to rethink their data infrastructure to participate in the IoT, including: Data storage: Understanding the kinds of data: structured, unstructured, big/small? Analytics: What kinds and how responsiv...
Since 2008 and for the first time in history, more than half of humans live in urban areas, urging cities to become “smart.” Today, cities can leverage the wide availability of smartphones combined with new technologies such as Beacons or NFC to connect their urban furniture and environment to create citizen-first services that improve transportation, way-finding and information delivery. In her session at @ThingsExpo, Laetitia Gazel-Anthoine, CEO of Connecthings, will focus on successful use cases.
Sensor-enabled things are becoming more commonplace, precursors to a larger and more complex framework that most consider the ultimate promise of the IoT: things connecting, interacting, sharing, storing, and over time perhaps learning and predicting based on habits, behaviors, location, preferences, purchases and more. In his session at @ThingsExpo, Tom Wesselman, Director of Communications Ecosystem Architecture at Plantronics, will examine the still nascent IoT as it is coalescing, including what it is today, what it might ultimately be, the role of wearable tech, and technology gaps stil...