Learn more
 

Ready to get started?

Download a free trial of the Sage 50 UK Driver to get started:

 Download Now

Learn more:

Sage 50 UK Icon Sage 50 UK JDBC Driver

Complete read-write access to Sage 50 UK enables developers to search (Customers, Transactions, Invoices, Sales Receipts, etc.), update items, edit customers, and more, from any Java/J2EE application.

In this article

Related articles

Connect to Sage 50 UK Data in RazorSQL


Connect to Sage 50 UK from wizards and query Sage 50 UK data from the GUI in the RazorSQL database management tool.

The CData JDBC Driver for Sage 50 UK enables standards-based access from third-party tools, from wizards in IDEs to data management and analysis tools. This article shows how to connect to Sage 50 UK using wizards in RazorSQL.

Create a JDBC Data Source for Sage 50 UK Data

  1. Open the RazorSQL application and, in the Connections menu, select Add Connection Profile -> Other -> JDBC.
  2. In the Connection Wizard that appears, set the following properties:
    • Driver Location: Set this property to the path to the lib subfolder in the installation directory.
    • Driver Class: Set the driver class to cdata.jdbc.sage50uk.Sage50UKDriver.
    • Username: Enter the username. (This property can also be set in the JDBC URL.)
    • Password: Enter the password. (This property can also be set in the JDBC URL.)

    • JDBC URL: Enter connection parameters. The JDBC URL begins with jdbc:sage50uk: and is followed by a semicolon-separated list of connection properties.

      Note: Only Sage 50 UK 2012 and above are supported.

      The User and Password properties, under the Connection section, must be set to valid Sage 50 UK user credentials. These values will be the same used to log in to the Sage 50 UK software.

      Additionally, the URL property, under the Connection section, will need to be set to the address of the company dataset desired. To obtain the address, do the following:

      1. If you have not already done so, open the Sage 50 UK software.
      2. Click Tools -> Internet Options.
      3. Select the SData Settings tab.
      4. Click the Details button next to Sage 50 Accounts. A window is displayed containing a list of company names along with the address to their corresponding datasets.
      5. Set the URL property to the value in the address field next to the company desired.

      Built-in Connection String Designer

      For assistance in constructing the JDBC URL, use the connection string designer built into the Sage 50 UK JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

      java -jar cdata.jdbc.sage50uk.jar

      Fill in the connection properties and copy the connection string to the clipboard.

      A typical JDBC URL is the following:

      jdbc:sage50uk:URL=http://your-server:5493/sdata/accounts50/GCRM/your-address;User=Manager;

Query Sage 50 UK Data and Select Tables

After establishing a connection, the wizard will close and the connection will be available in the connections panel. You can then query the tables.