SAP Sybase Products

• PowerDesigner
• PowerBuilder
• SQL Anywhere

SAP PowerDesigner 16.6

SAP PowerDesigner: Enterprise Architecture tools for digital transformation success

SAP PowerDesigner is a graphical enterprise modeling solution supporting standard methodologies and notations and providing automated code-reverse engineering and generation through customisable templates. PowerDesigner provides powerful reporting capabilities, is highly extensible, and offers a scalable enterprise repository solution with strong security and versioning capabilities to aid multi-user development.

• PowerDesigner New Features
• PowerDesigner Core Features
• PowerDesigner Getting Started Guide
• Data Modeling with PowerDesigner

Functional Capabilities

Technical Capabilities

PowerDesigner, is the only modelling and metadata management tool that supports data, information and enterprise architecture with unique Link and Sync technology. PowerDesigner brings powerful impact analysis and design-time change management techniques to your enterprise.

The following three PowerDesigner editions are available (Note: The Previous Edition of PowerDesigner InformationArchitecture has been split into PowerDesigner BusinessAnalyst and PowerDesigner DataArchitect):

• SAP PowerDesigner BusinessAnalyst, Edge Edition
• SAP PowerDesigner DataArchitect, Edge Edition
• SAP PowerDesigner EnterpriseArchitect, Edge Edition

Each Edition has the following components

For further information call MicroWay on 1300 553 313 or email

SAP PowerBuilder 12.6

• SAP PowerBuilder 12.5 DataSheet
• SAP PowerBuilder 12.5 User Guide
• SAP PowerBuilder 12.6 New Features

Rely on most powerful business application development tool

SAP PowerBuilder is the most productive tool for building data driven business applications. Its patented DataWindow technology delivers unparalleled productivity for accessing, manipulating, and sharing complex data in your applications, with just a few lines of script. The reporting tool InfoMaker is also included.

Create high-performance, data-driven business applications faster than ever before, with SAP Sybase PowerBuilder. This cost-effective application development tool offers an award-winning, intuitive user interface – and can help you dramatically simplify complex data access, manipulation, and presentation.

• Accelerate application development with an award-winning, intuitive user interface 
• Turn complex data access, manipulation, and presentation into an easy, nearly codeless, experience 
• Minimise development cost and risk while incorporating new and emerging technologies 
• Use your relational database management system (RDBMS) of choice
• Communicate via Web Services, produce .NET assemblies, and deploy to multiple platforms
• Future-proof critical enterprise applications by leveraging existing skill-sets

PowerBuilder is an object-centric graphical application development environment. Using PowerBuilder, you can easily develop many types of applications and components. PowerBuilder provides all the tools you need to build enterprise systems, such as order entry, accounting, and manufacturing systems.

Two-tier applications

PowerBuilder applications can be traditional graphical client/server two-tier applications that access server databases. A traditional client/server application is a collection of windows that contain controls that users can interact with. You can use standard controls—such as buttons, check boxes, drop-down lists, and edit controls—as well as special PowerBuilder controls that make your applications easy to develop and easy to use.

Multitier applications

You can also build multitier applications with PowerBuilder. A multitier application usually has a client application that requests services from a server application or component. For example, your client application could request services from a PowerBuilder component on an application server. The server component often requests services from a server database and/or other server components.

Web applications

PowerBuilder applications can also be Web based. You can create a new Web-based application for the Internet or Intranet, or adapt or extend an existing PowerBuilder application for the Web.

What PowerBuilder is

PowerBuilder is an enterprise development tool that allows you to build many types of applications and components. It is one of a group of Sybase products that together provide the tools to develop client/server, multitier, and Internet applications.

What's in a PowerBuilder application?

A PowerBuilder client application can contain:

• A user interface Menus, windows, and window controls that users interact with to direct an application.
• Application processing logic Event and function scripts in which you code business rules, validation rules, and other application processing. PowerBuilder allows you to code application processing logic as part of the user interface or in separate modules called custom class user objects.

What is a PowerBuilder component?

In a multitier application, modules containing application processing logic (that you deploy to a server) are called components. You can design, build, and deploy custom class user objects as application server components.

PowerBuilder applications are event driven

In a client application, users control what happens by the actions they take. For example, when a user clicks a button, chooses an item from a menu, or enters data into a text box, one or more events are triggered. You write scripts that specify the processing that should happen when events are triggered.

Windows, controls, and other application components you create with PowerBuilder each have a set of predefined events. For example, each button has a Clicked event associated with it and each text box has a Modified event. Most of the time, the predefined events are all you need. However, in some situations, you may want to define your own events.

PowerScript language

You write scripts using PowerScript, the PowerBuilder language. Scripts consist of PowerScript commands, functions, and statements that perform processing in response to an event.

For example, the script for a button's Clicked event might retrieve and display information from the database; the script for a text box's Modified event might evaluate the data and perform processing based on the data.

The execution of an event script can also cause other events to be triggered. For example, the script for a Clicked event in a button might open another window, triggering the Open event in that window.

PowerScript functions

PowerScript provides a rich assortment of built-in functions that can act on the various components of your application. For example, there is a function to open a window, a function to close a window, a function to enable a button, a function to update the database, and so on.

You can also build your own functions to define processing unique to your application.

Object-oriented programming with PowerBuilder

Each menu or window you create with PowerBuilder is a self-contained module called an object. The basic building blocks of a PowerBuilder application are the objects you create. Each object contains the particular characteristics and behaviors (properties, events, and functions) that are appropriate to it. By taking advantage of object-oriented programming techniques such as encapsulation, inheritance, and polymorphism, you can get the most out of each object you create, making your work more reusable, extensible, and powerful.

.NET applications

If you are using the Enterprise edition of PowerBuilder, you can develop applications and components for the .NET environment. These include Web Forms applications that you deploy to IIS servers using ASP.NET and Windows Forms applications that you can deploy with smart client functionality. You can also convert nonvisual custom class objects directly into .NET assemblies and you can deploy them as .NET Web services.

For information about .NET targets, see Deploying Applications and Components to .NET.

Multitier applications

PowerBuilder lets you build applications that run in a distributed computing environment. A multitier application lets you:

• Centralise business logic on servers, such as EAServer, JBoss, WebLogic, WebSphere, or COM+
• Partition application functions between the client and the server, thereby reducing the client workload
• Build scalable applications that are easy to maintain

For information about multitier applications, see the sections on distributed application techniques in Application Techniques.

Database connectivity

PowerBuilder provides easy access to corporate information stored in a wide variety of databases. Data can be accessed through the PowerBuilder ODBC or JDBC interfaces, through a middle-tier data access server like the Sybase DirectCONNECT server, or through a native or direct connection to a database.

For further information call MicroWay on 1300 553 313 or email

SAP SQL Anywhere 17

• SQL Anywhere 17 Fact Sheet
• SQL Anywhere Supported Operating Systems

Deliver mission-critical services to Internet of Things systems and data-intensive apps

SAP SQL Anywhere solutions provide data management, synchronisation, and data exchange technologies that enable developers to rapidly design, build, and deploy database-powered applications for mobile and remote environments where there is limited or no IT support. Database management software keeps data synchronised with thousands of mobile devices or remote offices, so that all business users can access vital data – anytime, anywhere.

With the latest release of SAP SQL Anywhere, companies can securely capture, access, and feed data, including IoT data, back into the SAP HANA platform from remote workplaces with low bandwidth or intermittent connections, such as retail stores, restaurants, and satellite offices within large enterprises. 

Companies can benefit from:

• Optimised performance on a wide variety of IoT platforms plus monitoring and diagnostic capabilities designed to support new IoT application scenarios
   
• Smart, secure synchronisation for cloud and on-premise systems with improved data protection encryption and data isolation
   
• Always-on, always-available operations with significantly reduced downtime resulting from database maintenance and application upgrades

SQL Anywhere offers:

• Embeddability

  SQL Anywhere can be easily embedded inside other applications. It combines high performance with a very small memory footprint. SQL Anywhere contains a range of features to enable self-management and maintenance in frontline environments, including features that enable optimisation of computer resources, self-tuning for improved performance, and simplification of remote installation and support.

• Interoperability

  SQL Anywhere is available on many platforms, including Windows, Linux, Oracle Solaris, HP-UX, IBM AIX, and Mac OS X. Unique to SQL Anywhere, its database files can be copied between platforms. In addition, SQL Anywhere provides support for many smartphones using its UltraLite database technology for small devices. SQL Anywhere includes support for many common database interfaces, including ODBC, JDBC, ADO.NET, JavaScript, PHP, and Perl. Many popular application development tools can be used, including: Microsoft Visual Studio, SAP PowerBuilder, Eclipse, and various web tools. Stored procedures can be written in C/C++, Java, .NET, or Perl.

• Performance out of the box

  SQL Anywhere is designed to deliver outstanding performance without ongoing tuning and administration. Features such as dynamic cache sizing, automatic generation of statistics, a sophisticated query optimiser, parallel query processing, and materialised views mean that SQL Anywhere is ideal for environments that demand high performance but have no on-site database administrator. By offering, On-Line Analytical Processing (OLAP) SQL Anywhere offers the ability to perform complex data analysis within a single SQL statement, increasing the value of the results, while improving performance by decreasing the number of database queries.

• Mobility

  SQL Anywhere provides enterprise-caliber databases that operate on frontline systems and devices whether connectivity with enterprise systems is available or not. Its synchronisation technologies ensure data can be exchanged efficiently over wireless and wired networks with backend databases, application servers, and messaging systems.

• Data encryption and security

  SQL Anywhere provides full end-to-end data security with 128-bit strong encryption of database tables, files, and communications streams between the application and the database, and the MobiLink synchronisation stream. SQL Anywhere can audit data access, offers built-in user authentication, and can integrate with third-party authentication systems. SQL Anywhere also offers a FIPS-certified version of encryption via a separately licensed component.

For further information call MicroWay on 1300 553 313 or email

For more information please contact the MicroWay sales team:
Head Office MicroWay Pty Ltd PO Box 84, Braeside, Victoria, 3195, Australia Ph: 1300 553 313 Fax: 1300 132 709 email: sales@microway.com.au ABN: 56 129 024 825	Sydney Sales Office MicroWay Pty Ltd PO Box 1733, Crows Nest, NSW 1585, Australia Tel: 1300 553 313 Fax: 1300 132 709 email: sales@microway.com.au ABN: 56 129 024 825	New Zealand Sales Office MicroWay Pty Ltd (NZ) PO Box 912026 Victoria Street West Auckland 1142, New Zealand Tel: 0800 450 168 email: sales@microway.co.nz
International: call +61 3 9580 1333, fax +61 3 9580 8995