Thursday, September 22, 2016

Preparing PowerBuilder applications for submission to the Windows Store using the Desktop App Converter


What the Desktop App Converter does is create a UWP wrapper around a .Net or Win32 application.  It runs the application within an isolated Windows environment so that any elevated privileges only affect the isolated environment and not the host machine.


Wednesday, September 07, 2016

Accessing any database from PowerBuilder 12.6 using OData

OData

One of the new features added to PowerBuilder Native with the 12.6 release was support for accessing SQL databases through OData.  A number of database vendors, particularly SAP and Microsoft provide build in support for exposing their databases via OData.  However, what do you need to do if you want to access other databases such as IBM or Oracle?

There are a number of options.  One is to get something like the Progress DataDirect OData Connector or the CData Could Driver.  Another approach, recommended by IBM and Oracle, is to expose the database through WCF Data Services using Visual Studio.Net.  The problem with that approach is that Microsoft (as it often does) has indicated that WCF Data Services has been deprecated in favor of Web API OData libraries.  So instead, we're going to look at a third option, using platform neutral open-source tools to expose any database through an OData service.