SAP Knowledge Base Article - Public

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 :$metadata
      A sample public service root URL :
    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


SAP Crystal Reports 2020