Home

Description

The OData database interface has been removed from the Database painter in PowerBuilder code. This means that developers will no longer be able to access this interface from the Database painter, and instead must use other methods to access OData databases. This removal is likely intended to encourage developers to use more modern methods of accessing databases, such as through web services or through other more modern interfaces.

Key Benefits

• Simplified Database Painter Interface: The OData database interface is removed from the Database painter, allowing for a simpler and easier to use interface.
• Reduced Complexity: By removing the OData interface, the complexity of the Database Painter is reduced, making it easier to use.
• Improved Performance: Removing the OData interface also improves the performance of the Database Painter, allowing for faster query processing.

Non-compliant Code Example

SQLCA.DBMS = "JDBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Driver='cdata.jdbc.odata.ODataDriver',URL='jdbc:odata:URL=http://services.odata.org/V4/Northwind/Northwind.svc;UseIdUrl=True;OData Version=4.0;Data Format=ATOM;";        //Non compliant code
CONNECT USING SQLCA;
dw_master.SetTransObject(SQLCA);
dw_master.Retrieve();

SQLCA.DBMS = "ODT"            //Non compliant code  
SQLCA.DBParm = "ConnectString='URI=http://esx2-appserver/TestDataService/Employee.svc'"    
//connect to the service  
connect using SQLCA;    
dw_master.SetTransObject(SQLCA);
dw_master.Retrieve();