We are proud to share our inclusion in the 2024 Gartner Magic Quadrant for Data Integration Tools. We believe this recognition reflects the differentiated business outcomes CData delivers to our customers.
Get the Report →
Connect to OData Services from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for OData to connect to OData services and execute queries in PowerBuilder.
The CData ODBC Driver for OData can be used from any platform or development technology that supports ODBC, including PowerBuilder. This article shows how to connect to OData services and execute queries from the Database Painter and controls such as the DataWindow.
About OData Data Integration
CData simplifies access and integration of live OData services data. Our customers leverage CData connectivity to:
- Access OData versions 2.0, 3.0, and 4.0, working with legacy services and the latest features and capabilities.
- Leverage advanced query options, including $filter, $select, and $expand, enhancing data retrieval from 3rd party tools.
- Use Server-side execution of aggregation and grouping to minimize data transfer and boost performance.
- Authenticate securely using a variety of schemes, including Azure AD, digest, negotiate, NTLM, OAuth, and more means secure authentication with every connection.
- Use SQL stored procedures to manage OData service entities - listing, creating, and removing associations between entities.
Customers use CData's solutions to regularly integrate their OData services with preferred tools, such as Power BI, MicroStrategy, or Tableau, and to replicate data from OData services to their databases or data warehouses.
Getting Started
Connect to OData as an ODBC Data Source
If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.
The User and Password properties, under the Authentication section, must be set to valid OData user credentials. In addition, you will need to specify a URL to a valid OData server organization root or OData services file.
Create a Profile for the ODBC Driver for OData
Follow the steps below to use the Database Painter tool to create a database profile based on an ODBC DSN (data source name) for OData. In the Database Painter, you can use wizards and the UI to work with OData services.
- In PowerBuilder, click Tools -> Database Painter.
- In the Objects window in the Database Painter, right-click the ODBC node and click New Profile.
- On the Connection tab, enter a name for the profile and select the OData DSN in the Data Source menu.
![]( "The ODBC DSN, required to create the Database Profile. (Salesforce is shown.)")
- To view and modify a table, right-click a table and then click Edit Data -> Grid.
Using OData Services with PowerBuilder Controls
You can use standard PowerBuilder objects to connect to ODBC data sources and execute queries. The following example shows how to retrieve OData services into a DataWindow. You can add the following code to the open method:
SQLCA.DBMS = "ODBC"
SQLCA.DBParm = "ConnectString='DSN=CData OData Source'"
CONNECT USING SQLCA;
dw_orders.SetTransObject(SQLCA);
dw_orders.Retrieve();
Ready to get started?
Download a free trial of the OData ODBC Driver to get started:
Download NowLearn more:
OData ODBC Driver
The OData ODBC Driver is a powerful tool that allows you to connect with live OData Services, directly from any applications that support ODBC connectivity.
Access OData services like you would any standard database - read, write, and update etc. through a standard ODBC Driver interface.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers