ADO.NET Provider for Sage 200

Build 24.0.8963

Create a Data Source

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963