User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
The upcoming PowerBuilder 2018 will help you move to C# and the cloud with the productivity that is a hallmark of PowerBuilder. Entirely new .NET targets are provided in the native PowerBuilder IDE for rapidly creating, in a test-driven manner, REST Web APIs and .NET assemblies. Coding is in C# and powered by DataWindow technology as well as the full features of the cross-OS .NET Core framework. You’ll be developing high-performance cloud apps faster than in Visual Studio. If you are migrating existing business logic, automated conversion tools further accelerate your project.

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

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.