Follow the steps below to create the data source, providing authentication and any necessary connection properties.

Share or Embed the Data Source

You can create shared data sources or create an embedded data source restricted to a single port.

1. Open your report or create a new Report Server project and add a new report by right-clicking the Reports folder in Solution Explorer and clicking Add -> New Item -> Report.
2. If you want to create a shared data source, right-click Shared Data Sources in Solution Explorer and click Add New Data Source. If you want to create an embedded data source, right-click Data Sources in the Report Data view.
3. Enter a name for the data source and in the Type menu select CData Sage200 Report.
4. In the Connection String box, enter the connection string to connect to Sage 200. A typical connection string is below:
   

   InitiateOAuth=GETANDREFRESH;SubscriptionKey=12345;Schema=StandardUK

   See Establishing a Connection for a connection and authentication how-to.