Transcript Document

Solve Your Top Business Problems Today
with
PowerBuilder
Hands On the Challenge
John Strano, Sybase Technology Evangelist
1 – Sybase Confidential
July 18, 2015
Challenge01 & Challenge02
2 – Sybase Confidential
July 18, 2015
Challenge01 & Challenge02
• Thou shalt not rewrite in PowerBuilder.
• HOLD ON! Did you say refactor? Isn’t that a fancy,
marketing type of word for rewrite? I’ve been told
that any rewriting will be done in a new language,
NOT PowerBuilder!
3 – Sybase Confidential
July 18, 2015
Challenge01 & Challenge02
Solution:
• Using PowerBuilder 11.5, you will modify an “old app”
that gets a new ID and the default sales
representative for a newly-inserted customer
according to their state or province of record…all
within the clicked event of a commandbutton.
• You will move that logic to methods of a new NVO
that is then deployed as a .NET Web Service.
4 – Sybase Confidential
July 18, 2015
Challenge01 & Challenge02
Take away message:
• Rewriting in PowerBuilder is ALWAYS the best
investment because it will be the cheapest, fastest
way to solve your business problems.
5 – Sybase Confidential
July 18, 2015
Challenge03
Challenge:
• I need to expose my internal logic to my .NET peers.
• Our PowerBuilder application has some critical
business logic and data that the .NET development
team needs access to.
6 – Sybase Confidential
July 18, 2015
Challenge03
Solution:
• Deploy the NVO as a .NET Assembly.
7 – Sybase Confidential
July 18, 2015
Challenge03
Take away message:
• Assuming that your application was well written and
you’ve encapsulated your business logic, separating it
from the UI, you can easily redeploy this NVO as a
.NET Assembly.
• Rewriting anything, fixing anything, will always be
easiest to do and the most cost effective when done
with PowerBuilder.
8 – Sybase Confidential
July 18, 2015
Challenge04
Challenge:
• Web Services...we need to build ‘em, use ‘em, and
manage them. Can PowerBuilder do this?
9 – Sybase Confidential
July 18, 2015
Challenge04
Solution:
• Create an NVO with 4 methods to SELECT, INSERT, UPDATE,
DELETE a Customer.
• Deploy this NVO as a .NET Web Service.
• Change the detail DataWindow Object in Customer
maintenance to use these Service operations as its data
source.
• Add logic to the INSERT method/operation that calls the NVO
that has been deployed as a .NET Web Service to get the new
Customer’s default sales representative.
10 – Sybase Confidential
July 18, 2015
Challenge04
Take away message:
• PowerBuilder is the easiest way to use Web Services,
whether that means building them, using them,
and/or managing them.
11 – Sybase Confidential
July 18, 2015
Challenge05
• We must, we must, we must increase our ubiquity!
• Or, we need to access our applications from the Web!
• My users want a Web interface for their application,
so management wants a new application written for
the Web.
• Is there anything I can do quickly to get a few pages
up on the Web?
12 – Sybase Confidential
July 18, 2015
Challenge05
Solution:
• PowerBuilder 11.x WebForms.
• From scratch, build a single window with a single
DataWindow that retrieves and updates the
Employee table from the demo database…then
deploy it to the Web…in less than 10 minutes.
13 – Sybase Confidential
July 18, 2015
Challenge05
Take away message:
• It’s always been easy to quickly build a working
prototype and a working application in PowerBuilder
• Now, you can just as easily build a few new Web
pages and access your client/server data sources.
• With PowerBuilder ease and speed, you can quickly
give you users Web access by building new Web
pages in a Win32 environment.
14 – Sybase Confidential
July 18, 2015
Challenge06
Challenge:
• We must move our ENTIRE application to the Web.
• My problem is bigger than just a few pages – I need to
move my entire application to the Web.
• It’s huge and complex, and because it’s written for a
c/s architecture, my management thinks it’s old,
outdated, and needs to be rewritten.
15 – Sybase Confidential
July 18, 2015
Challenge06
Solution:
• Demonstrate deploying your traditional Win32
application using PowerBuilder’s WebForm
deployment capability…along with its extant Web
Service usage.
16 – Sybase Confidential
July 18, 2015
Challenge06
Take away message:
• Your business is run with a solid application that was
designed for a c/s environment, but now it can easily
be moved to the Web, without taking years or
hundreds of thousands of dollars…or more.
• PowerBuilder’s WebForm deployment can Webenable that application.
17 – Sybase Confidential
July 18, 2015
Challenge07
Challenge:
• It is too time consuming, and therefore too expensive,
to keep updating our client desktop application.
• But, we’re not sure the Web is the right way to go as
there are issues moving to the Web, too, such as
managing state, ensuring a specific browser is used,
etc.
18 – Sybase Confidential
July 18, 2015
Challenge07
Solution:
• Deploy your application as a Smart Client!
• You will publish your traditional Win32 application as
a Smart Client .NET WinForm application.
19 – Sybase Confidential
July 18, 2015
Challenge07
Take away message:
• Take advantage of the ubiquity of the Web, but
deliver a fully functional, feature rich GUI.
• Smart Client is smart.
• PowerBuilder does Smart Client.
• Therefore, PowerBuilder is smart.
20 – Sybase Confidential
July 18, 2015
Challenge08
Challenge:
• Update an old, ugly UI. Or, “You can see a
PowerBuilder application coming from a mile away...”
• My existing PowerBuilder application looks old and
dated, sporting a Win95 look and feel, and this is a
huge issue because it only serves to perpetuate the
undercurrent in my company to rewrite this app in C#
or Java (depending upon type of shop).
21 – Sybase Confidential
July 18, 2015
Challenge08
Challenge (cont’d):
• If I could only update this application’s UI quickly and
easily, I could use that to demonstrate PowerBuilder’s
power.
• What should I do?
22 – Sybase Confidential
July 18, 2015
Challenge08
Solution:
• Perform a quick, yet significant update of a portion of
your application using PowerBuilder 11.5
DataWindow enhancements.
• You will optionally publish these visual enhancements
using Smart Client.
23 – Sybase Confidential
July 18, 2015
Challenge08
Take away message:
• PowerBuilder applications can get a facelift in no time
and look modern and up-to-date by simply updating
your version.
• In the future, we’ll be taking you to new heights with
WPF and beyond.
24 – Sybase Confidential
July 18, 2015