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  
       
• Note: 
• Multifactor Authentication (MFA) is currently not supported in Crystal Reports 2020 
       
• Known Issue:
• 3418388 - Logon failed on OData connection in Crystal Reports 2020 SP03 and highe

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

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020