|By Chris Pollach||
|August 20, 2009 07:45 AM EDT||
PowerBuilder 11.5 was released in the third quarter of 2008 and by early 2009 had made its way into many IT development shops. The draw is a significant set of enhancements that move the development experience closer to the nirvana anticipated in the PowerBuilder 12.0 release.
PB 12.0 will complete Sybase's initial four-phase long range plan for PowerBuilder that was laid out in late 2003 (see Figure 1). In the meantime, PB 11.5 raises the bar in major areas such as application functionality, database connectivity, newer MS-Windows operating system compliance, more .NET compatibility, and Federal Desktop Core Configuration compliance.
Once again I was able to join the PowerBuilder beta program for version 11.5, which let me continue my unbroken participation in every PowerBuilder release since version 0.8. The nice thing about the beta programs is that not only do you get to take the new product for a full test drive but you also get to interact with the developers, engineers, and quality assurance people, which often gives you a much closer look at the inner workings of the product.
To top off the beta adventure I also bought a new HP Pavilion 17-inch laptop loaded with Microsoft Windows Vista Home Premium. Instead of reformatting the machine with Windows XP Professional, I decided to take the plunge and use Vista for a more hands-on experience of the controversial operating system. This was a hard decision because Sybase indicated that PowerBuilder 11.5 was being designed and certified only for the Business and Ultimate versions of Vista. However, I checked with Dave Fish who said engineering knew of no reason why PB 11.5 wouldn't work on this version. And after completing the beta program I'm happy to report that I have not only successfully used PB 11.5 on Vista Home Premium but also EAServer 6.2, SQLAnywhere 11, and ASE 15 as well. So to me this is a hidden gem and great selling point for the latest Sybase products running on what I think is the most common OS version shipping today. After this positive experience I'd strongly urge Sybase to list this Windows version on its compatibility list for PB 11.5.
The movement to adopt the .NET Framework as the preferred development platform on Windows technology has grown since I reported on the release of PowerBuilder 11.0. Even Novalys - the makers of Visual Expert for PowerBuilder - which does a yearly PowerBuilder survey, has now published its 2008 results. The poll indicates a strong commitment to moving to .NET, adopting PB 11.x, and embracing the .NET realm as Sybase heads to PB 12 running under the .NET Development Isolated Shell.
You can preview Novalys' results here.
One of the key trends identified is the move to the .NET 2/3 Framework that has now superseded Java in importance for the first time in any survey (see Figure 2).
.NET integration ranked second in enhancement demand.
So I'm quite confident in saying that Sybase's emphasis on .NET interoperability and its direction for PowerBuilder is aligned with the strategic direction developers are requesting.
And now, on to my picks!
Top Feature #1 - DataWindow
Hands down, the DataWindow gets my vote for the top feature in PowerBuilder 11.5. Now there are many enhancements to the DataWindow so I need to be a bit more specific in my description. In this case it's the one-two punch combination of the Gradient and Tooltip features. They not only give your presentation layer a real "wow" factor, but more importantly a vital communication feedback mechanism from the application to the application user is added as the user moves his mouse over any object in the DataWindow (see Figure 3). The graduated coloring allows for a really smooth surface look that definitely complements any XP or Vista themes.
The DataWindow also adds a few other bonus features as well to round-out its PowerPunch feature list.
The next key feature is the RichText Edit Style - a new Edit Mask format that let the application automatically enter a word processing mode when the user tabs into a specific column (see Figure 4). The only restriction is that you need a column length of at least 1,033 characters or more to hold the typed characters plus the rich text mark-up. Once you have columns defined in your schema to hold the large text descriptions - like product notes, employee review text, or customer letter information - build a DataWindow as per normal. Then, for each column that requires the RichText editing feature, locate the Edit tab in the corresponding property pane and change the Style Name to "RichText." You can immediately test the RichText feature in the DW Painter's Preview pane. Just tab over to the column marked RichText and you should see the DW object open a RichText tool bar overtop of the affected column. You may now enter any valid text and mark it up as you see fit - just like the application user will do in production (see Figure 5).
To complete the RichText experience, test out the full lifecycle by pressing the Save and Retrieve command buttons on the DW Painter's toolbar to force the rich text update and select back to the application. I'm sure you'll find everything else in the DW Object like the rich text experience will be as easy as the Web Service, Tree View, or Graphing - child's play compared to what you have to do in other development systems to enable this type of behavior!
To top off the panache of the DataWindow for release 11.5, Sybase has also added features like support for .PNG image types; Transparency for Pictures; and new Events and Methods to control RichText and image behaviors at runtime. This low-level control is always appreciated by the application developer who needs to finesse any object's behavior to get the exact look-and-feel that some users demand.
Top Feature #2 - Graphing
The number two key feature in PowerBuilder 11.5 in my opinion was the introduction of 3D rendering for graph objects (see Figure 6). This includes the Graph Control and the DataWindow graph presentation style. It is accomplished by PowerBuilder tapping into and utilizing Microsoft's DirectX technology feature, and is easily done by the PB developer just by checking the new "Third Render" property found in both the DataWindow and Window Painters.
This 3D rendering using DirectX again really adds some "wow" factor to your applications and I'm sure your application users will like the eye-candy and sharper images and labels. The same ease of graph rendering is also available in the DataWindow Painter. After creating the basic graph from the DW Wizard, activate the 3D Rendering property and watch the magic of the DirectX feature.
Top Feature #3 - DataBase Connectivity
The one thing that has always impressed me about PowerBuilder is its prowess in database connectivity. This is also important in large mission-critical applications that require sub-second response time for key database interactions and support for the rich feature set of the supporting DBMS. PowerBuilder 11.5 is no slouch here and raises the bar in connecting and fully utilizing the new Oracle 11g and Microsoft SQL Server 2008 technology.
For Oracle's release 11g, PB 11.5 adds a new handshake driver labeled just Oracle. The O11g driver is actually set in the Transaction Object in the DBMS property as a plain "ORA" setting (see Figure 7). This may be confusing since in prior releases we had the Oracle release in the setting (i.e., O84, O90, O10, etc). The Oracle 11g driver adds new functionality such as Session and Connection pooling; client result cache; proxy access; OCI security feature, and support for the new XML data type.
In the case of SQL Server 2008, PowerBuilder 11.5 stills uses the same driver handshakes for ODBC, OLE-DB, ADO.NET, and SNC. However, it adds some new options to activate the newer client to access the SQL Server 2008 feature set. In my case, I use the SQL Server Native Client (SNC) driver for SS2005 - so it seemed natural to continue with this mechanism for SS2008. After installing PB 11.5 you can create a new Database Profile using the SNC option to connect to SS2008. The difference in SS2008 is in a new value in the "provider" property. The new setting for the Provider property is SNCCLI10, which uses the latest SNC client (version 10.0), which supports SQL Server 2008. You can still access SQL Server 2005 by choosing the SNCCLI value, which uses the SNC version 9.0 driver (see Figure 8). Like most DBMSes, the newer driver and client can access SS2005 but you have to ensure that you don't use a SS2008 feature. I'd always recommend that you use the corresponding client version to match the DBMS server you're connecting to to avoid any feature misalignment.
Top Feature #4 - SQLAnyWhere 11
For the number four position, I've chosen a non-PowerBuilder feature - the SQLAnywhere (SA) DBMS. This software is often bypassed when evaluating PowerBuilder or considering a DBMS platform but I've developed hundreds of applications using this rich-featured database management system and put them into production without incident. The SQL Anywhere DBMS that ships with PowerBuilder is extremely solid, a great performer, easy to administer, has a small footprint, and above all a low cost of ownership. This makes teaming up a PB application with an SA one of the best combinations to deliver a first-class client/server application.
SA 11 brings some key new features to the PowerBuilder developer. The following is a list of the main features introduced in SQL Anywhere version 11. They are:
- Support for merging tables: Now allows you to merge tables, views, and system procedure results into a table or view.
- Support for login policies: SQL Anywhere now supports login policies, which is a set of options that define rules to be applied when a database connection is established for a user.
- Support for full text search: SQL Anywhere now supports full text search. Full text search can quickly find all instances of a word in a database. It uses a text index instead of scanning table rows.
- Support for regular expressions: SQL Anywhere now provides support for regular expressions using two new search conditions, REGEXP and SIMILAR TO.
- Database option settings are now recorded in the transaction log: The database option settings in effect during a LOAD operation are now recorded in the transaction log, ensuring that there are no inconsistencies in the data.
- Enhancements to the optimizer's use of indexes: Several performance enhancements have been made to the indexing capabilities of SQL Anywhere.
- Support for multiple indexes scan: The optimizer has been enhanced to consider multiple indices (up to four) to retrieve data from a base table based on multiple predicates on that table.
- Support for index-only retrieval: The optimizer has been enhanced to support index-only retrievals. With index-only retrieval, the query is satisfied using data from the indices, without having to access corresponding rows in the tables.
- Enhancements to loading and unloading data: Load data from, and unload data to, files on a client computer The database server already supports reading and writing data residing on the database server computer by means of SQL statements and functions. New features have been implemented to extend this capability to files that reside on the client computer without having to copy client files onto the database server computer. The transfer of data is done efficiently while providing security and access control for data on the client computer.
- Unload data into a variable: The UNLOAD statement has been enhanced to include an INTO VARIABLE clause to let you unload data into a variable.
- Load data from a column in another table: The LOAD TABLE statement has been enhanced to include a USING COLUMN clause that lets you to load data from a column in another table.
- Load data from a value (BLOB): The LOAD TABLE statement has been enhanced to include a USING VALUE clause so you can load data from a value expression, such as the results of a function or a system procedure.
- LOAD TABLE statement recovery and mirroring enhancements: Previously, in a mirrored database configuration, loading data from a file using the LOAD TABLE statement wasn't supported because only the LOAD TABLE statement was recorded in the transaction log, not the data being loaded. The LOAD TABLE statement has been enhanced to include three new logging option clauses: WITH CONTENT LOGGING, WITH ROW LOGGING, and WITH FILE NAME LOGGING.
- Support for immediate materialized views: You can now configure materialized views to be refreshed immediately when data changes in the underlying tables impact data in the materialized view. Views with this refresh type are called immediate views; views that aren't refreshed immediately are now referred to as manual views. Materialized views created before this release are considered manual views, and are the default when creating a new materialized view.
- Support for querying the contents of a file or BLOB string: Using the new OPENSTRING sub-clause of the FROM clause, you can now query data from a file or a BLOB string. The OPENSTRING clause lets you specify the object to be queried, as well as the schema and other parsing information for the data.
- Improved support for compressed indexes: Because of the work to improve support for compressed indices, when you rebuild a database by unloading and reloading it, the rebuilt database may be smaller than the original database. This decrease in database size doesn't indicate a problem or a loss of data.
- Read-only access to databases running on a mirror server: If you're using database mirroring, you can now connect to the database running on the mirror server. This lets you offload potentially resource-heavy reporting operations to the mirror server, while leaving the primary server available.
For my development endeavors I've already found the new Materialized View and Full Text Search to be invaluable in my latest projects.
Top Feature #5 - .NET Target Enhancements
For top feature number five, I'd like to nominate the enhancements to the .NET Target including Code Access Security (CAS), Strong Named Assemblies, Remote deployment to IIs (version 7), and SharedObjects.
The enhanced security features can be seen in the Project object for a .NET target in the Security and Sign tab pages (see Figure 9). The tab pages have been changed to let you publish an executable and grant specific permissions for its execution as well as sign an Assembly and its Manifest. These new options let the developer supply a "key file" to seed the signature identification.
When deploying a Webform application, the PowerBuilder 11.5 developer will now be able to deploy Webform components directly to a remote IIs server running either Vista or Windows 2008 operating systems. This negates the use of creating MSI installation packages, moving them to the remote server and running an MS-Install job on the target server. This should speed up the deployment of an application for System Testing, Prototyping, or Integration Testing. One would assume that production deployment would still use the .MSI method since most organizations don't allow developers access to the production environment.
The last key enhancement allows SharedObjects to be used in Webform and Winform applications. This was easily done in earlier PowerBuilder Win32 applications using the SharedObjectRegister ( ) and SharedObjectGet ( ) methods. I'm pleased to say that there's no change in functionality in the .NET realm. This new .NET Target feature enables your .NET applications to easily become multi-threaded and can certainly give your application a performance boost.
Top Feature #6 - Transaction Object Enhancements
The Transaction Object has been extended in PowerBuilder 11.5 adding two new events - DBError and SQLPreview. The key functionality change is the addition of the SQLPreview, which now allows a Win32 or .NET application to monitor or change all SQL originating in the client application. In previous releases the developer could only use this feature on the DataWindow control or DataStore object. Now the PB developer can capture, change, and monitor "in-line" SQL that appears embedded in the PowerScript language statements.
With this new SQL sensitivity all DML statements can now be acted upon regardless of where they're stored and activated in a PB-based application. This gives the developer unprecedented control over client-to-DBMS server interactions - especially for applications that require complete dynamic control over their SQL generation to get special features-enabled.
PowerBuilder 11.5 represents a significant advancement in functional capabilities such as .NET interaction, IDE productivity enhancements, and database connectivity. Sybase has definitely provided the application developer with key feature advancements that align PowerBuilder with new operating system and DBMS capabilities. I'd consider the "hit" features to be PowerTips in the DataWindow, graduated colors, DirectX graphing, shared objects, PNG image support, Oracle and SQL Server connectivity, rich text columns," and FDCC government standard compliance. Sybase had a few "misses" in not implementing PowerTips on all remaining controls and not supporting DirectX version 10 (the native version installed with Vista). Over all though, I'd rate PB 11.5 a solid nine out of 10 in its update appeal...a must in my opinion for the discerning developer and IT department.
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...
Apr. 1, 2015 09:15 AM EDT Reads: 2,312
The WebRTC Summit 2015 New York, to be held June 9-11, 2015, at the Javits Center in New York, NY, announces that its Call for Papers is open. Topics include all aspects of improving IT delivery by eliminating waste through automated business models leveraging cloud technologies. WebRTC Summit is co-located with 16th International Cloud Expo, @ThingsExpo, Big Data Expo, and DevOps Summit.
Apr. 1, 2015 09:00 AM EDT Reads: 1,742
SYS-CON Events announced today that Litmus Automation 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. Litmus Automation’s vision is to provide a solution for companies that are in a rush to embrace the disruptive Internet of Things technology and leverage it for real business challenges. Litmus Automation simplifies the complexity of connected devices applications with Loop, a secure and scalable cloud platform.
Apr. 1, 2015 09:00 AM EDT Reads: 700
SOA Software has changed its name to Akana. With roots in Web Services and SOA Governance, Akana has established itself as a leader in API Management and is expanding into cloud integration as an alternative to the traditional heavyweight enterprise service bus (ESB). The company recently announced that it achieved more than 90% year-over-year growth. As Akana, the company now addresses the evolution and diversification of SOA, unifying security, management, and DevOps across SOA, APIs, microservices, and more.
Apr. 1, 2015 08:30 AM EDT Reads: 2,124
Wearable technology was dominant at this year’s International Consumer Electronics Show (CES) , and MWC was no exception to this trend. New versions of favorites, such as the Samsung Gear (three new products were released: the Gear 2, the Gear 2 Neo and the Gear Fit), shared the limelight with new wearables like Pebble Time Steel (the new premium version of the company’s previously released smartwatch) and the LG Watch Urbane. The most dramatic difference at MWC was an emphasis on presenting wearables as fashion accessories and moving away from the original clunky technology associated with t...
Mar. 31, 2015 10:00 PM EDT Reads: 1,604
SYS-CON Events announced today that robomq.io will exhibit at SYS-CON's @ThingsExpo, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. robomq.io is an interoperable and composable platform that connects any device to any application. It helps systems integrators and the solution providers build new and innovative products and service for industries requiring monitoring or intelligence from devices and sensors.
Mar. 31, 2015 06:00 PM EDT Reads: 1,604
Internet of Things (IoT) will be a hybrid ecosystem of diverse devices and sensors collaborating with operational and enterprise systems to create the next big application. In their session at @ThingsExpo, Bramh Gupta, founder and CEO of robomq.io, and Fred Yatzeck, principal architect leading product development at robomq.io, will discuss how choosing the right middleware and integration strategy from the get-go will enable IoT solution developers to adapt and grow with the industry, while at the same time reduce Time to Market (TTM) by using plug and play capabilities offered by a robust I...
Mar. 31, 2015 04:00 PM EDT Reads: 653
After making a doctor’s appointment via your mobile device, you receive a calendar invite. The day of your appointment, you get a reminder with the doctor’s location and contact information. As you enter the doctor’s exam room, the medical team is equipped with the latest tablet containing your medical history – he or she makes real time updates to your medical file. At the end of your visit, you receive an electronic prescription to your preferred pharmacy and can schedule your next appointment.
Mar. 31, 2015 03:45 PM EDT Reads: 1,032
SYS-CON Events announced today that Solgenia 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, and the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Solgenia is the global market leader in Cloud Collaboration and Cloud Infrastructure software solutions. Designed to “Bridge the Gap” between Personal and Professional Social, Mobile and Cloud user experiences, our solutions help large and medium-sized organizations dr...
Mar. 31, 2015 03:00 PM EDT Reads: 3,061
While not quite mainstream yet, WebRTC is starting to gain ground with Carriers, Enterprises and Independent Software Vendors (ISV’s) alike. WebRTC makes it easy for developers to add audio and video communications into their applications by using Web browsers as their platform. But like any market, every customer engagement has unique requirements, as well as constraints. And of course, one size does not fit all. In her session at WebRTC Summit, Dr. Natasha Tamaskar, Vice President, Head of Cloud and Mobile Strategy at GENBAND, will explore what is needed to take a real time communications ...
Mar. 31, 2015 02:39 PM EDT Reads: 593
The world's leading Cloud event, Cloud Expo has launched Microservices Journal on the SYS-CON.com portal, featuring over 19,000 original articles, news stories, features, and blog entries. DevOps Journal is focused on this critical enterprise IT topic in the world of cloud computing. Microservices Journal offers top articles, news stories, and blog posts from the world's well-known experts and guarantees better exposure for its authors than any other publication. Follow new article posts on Twitter at @MicroservicesE
Mar. 31, 2015 12:00 PM EDT Reads: 1,577
SYS-CON Events announced today the IoT Bootcamp – Jumpstart Your IoT Strategy, being held June 9–10, 2015, in conjunction with 16th Cloud Expo and Internet of @ThingsExpo at the Javits Center in New York City. This is your chance to jumpstart your IoT strategy. Combined with real-world scenarios and use cases, the IoT Bootcamp is not just based on presentations but includes hands-on demos and walkthroughs. We will introduce you to a variety of Do-It-Yourself IoT platforms including Arduino, Raspberry Pi, BeagleBone, Spark and Intel Edison. You will also get an overview of cloud technologies s...
Mar. 31, 2015 11:00 AM EDT Reads: 2,254
The list of ‘new paradigm’ technologies that now surrounds us appears to be at an all time high. From cloud computing and Big Data analytics to Bring Your Own Device (BYOD) and the Internet of Things (IoT), today we have to deal with what the industry likes to call ‘paradigm shifts’ at every level of IT. This is disruption; of course, we understand that – change is almost always disruptive.
Mar. 30, 2015 04:00 PM EDT Reads: 1,201
SYS-CON Events announced today that SafeLogic has been named “Bag Sponsor” of SYS-CON's 16th International Cloud Expo® New York, which will take place June 9-11, 2015, at the Javits Center in New York City, NY. SafeLogic provides security products for applications in mobile and server/appliance environments. SafeLogic’s flagship product CryptoComply is a FIPS 140-2 validated cryptographic engine designed to secure data on servers, workstations, appliances, mobile devices, and in the Cloud.
Mar. 30, 2015 11:00 AM EDT Reads: 1,560
GENBAND has announced that SageNet is leveraging the Nuvia platform to deliver Unified Communications as a Service (UCaaS) to its large base of retail and enterprise customers. Nuvia’s cloud-based solution provides SageNet’s customers with a full suite of business communications and collaboration tools. Two large national SageNet retail customers have recently signed up to deploy the Nuvia platform and the company will continue to sell the service to new and existing customers. Nuvia’s capabilities include HD voice, video, multimedia messaging, mobility, conferencing, Web collaboration, deskt...
Mar. 30, 2015 01:00 AM EDT Reads: 1,535
SYS-CON Media announced today that @WebRTCSummit Blog, the largest WebRTC resource in the world, has been launched. @WebRTCSummit Blog offers top articles, news stories, and blog posts from the world's well-known experts and guarantees better exposure for its authors than any other publication. @WebRTCSummit Blog can be bookmarked ▸ Here @WebRTCSummit conference site can be bookmarked ▸ Here
Mar. 29, 2015 10:00 PM EDT Reads: 1,887
SYS-CON Events announced today that Cisco, the worldwide leader in IT that transforms how people connect, communicate and collaborate, has been named “Gold 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. Cisco makes amazing things happen by connecting the unconnected. Cisco has shaped the future of the Internet by becoming the worldwide leader in transforming how people connect, communicate and collaborate. Cisco and our partners are building the platform for the Internet of Everything by connecting the...
Mar. 29, 2015 07:00 PM EDT Reads: 5,297
Temasys has announced senior management additions to its team. Joining are David Holloway as Vice President of Commercial and Nadine Yap as Vice President of Product. Over the past 12 months Temasys has doubled in size as it adds new customers and expands the development of its Skylink platform. Skylink leads the charge to move WebRTC, traditionally seen as a desktop, browser based technology, to become a ubiquitous web communications technology on web and mobile, as well as Internet of Things compatible devices.
Mar. 29, 2015 06:00 PM EDT Reads: 1,901
Docker is an excellent platform for organizations interested in running microservices. It offers portability and consistency between development and production environments, quick provisioning times, and a simple way to isolate services. In his session at DevOps Summit at 16th Cloud Expo, Shannon Williams, co-founder of Rancher Labs, will walk through these and other benefits of using Docker to run microservices, and provide an overview of RancherOS, a minimalist distribution of Linux designed expressly to run Docker. He will also discuss Rancher, an orchestration and service discovery platf...
Mar. 29, 2015 04:15 PM EDT Reads: 2,482
SYS-CON Events announced today that Vitria Technology, Inc. will exhibit at SYS-CON’s @ThingsExpo, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. Vitria will showcase the company’s new IoT Analytics Platform through live demonstrations at booth #330. Vitria’s IoT Analytics Platform, fully integrated and powered by an operational intelligence engine, enables customers to rapidly build and operationalize advanced analytics to deliver timely business outcomes for use cases across the industrial, enterprise, and consumer segments.
Mar. 29, 2015 03:30 PM EDT Reads: 2,243