3224719 - How to connect to OData in Crystal Reports?

• Can Crystal Reports connect to OData?
• How to create a report based on an OData source in Crystal Reports? 

• SAP Crystal Reports 2016
• SAP Crystal Reports 2020

• OData connectivity was introduced in Support Pack 02 of Crystal Reports 2020.
  ( There is no OData connection in Crystal Reports 2016 and below. )
                 
• To connect to OData in Crystal Reports 2020 with Support Pack 02, and above:

1. In Crystal Reports 2020, under the File, select "New - Standard Report"

2. In the Report Creation Wizard's Data screen, expand the Create New Connection node.
     
3. Double-click: OData
     
4. Enter the OData service root URL
   
   The service root URL = OData metadata URL without the ending ‘$metadata’ section. For example:
   
   A sample public OData metadata URL : https://services.odata.org/V4/Northwind/Northwind.svc/$metadata
   A sample public service root URL : https://services.odata.org/V4/Northwind/Northwind.svc/
     
5. If required, enter your credentials.
     
6. Click Finish.
       

• For more details on OData connection, see the Crystal Reports 2020 User Guide in the section: Using OData data sources

CR, odata , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To