Creating a JDBC Data Source

You can create a JDBC data source to connect from your Java application. Creating a JDBC data source based on the CData JDBC Driver for Sage 200 consists of three basic steps:

• Add the driver JAR file to the classpath. The JAR file is located in the lib subfolder of the installation directory. Note that the .lic file must be located in the same folder as the JAR file.
• Provide the driver class. For example:
  

  cdata.jdbc.sage200.Sage200Driver

• Provide the JDBC URL. For example:
  

  jdbc:sage200:InitiateOAuth=GETANDREFRESH;SubscriptionKey=12345;Schema=StandardUK
  
  or
  
  jdbc:cdata:sage200:InitiateOAuth=GETANDREFRESH;SubscriptionKey=12345;Schema=StandardUK

  The second format above can be used whenever there is a conflict in your application between drivers using the same URL format to ensure you are using the CData driver. The URL must start with either "jdbc:sage200:" or "jdbc:cdata:sage200:" and can include any of the connection properties in name-value pairs separated with semicolons.

Connecting to Sage 200

Before connecting, you must ensure that your account is registered for Sage API access. You can easily do this by following this link: https://developer.columbus.sage.com/docs/services/api/uk/subscribe.
You will need to select a subscription that contains the API of your Sage 200 edition (StandardUK or ProfessionalUK). The Sage 200 Unlimited subscription should contain the APIs of both editions.

To connect to Sage 200, specify the following connection properties:

• Schema: Determines which Sage 200 edition you are connecting to. Specify either StandardUK or ProfessionalUK.
• SubscriptionKey: After subscribing to the API, you can find the subscription key in your profile after logging into Sage 200.

Authenticating to Sage 200

Sage 200 uses the OAuth authentication standard. See Using OAuth Authentication for an authentication guide.