Ready to get started?

Learn more about the CData JDBC Driver for Sage 50 UK or download a free trial:

Download Now

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.

      A typical JDBC URL is the following:

      jdbc:sage50uk:URL=http://your-server:5493/sdata/accounts50/GCRM/your-address;User=Manager;
  3. 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.

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.

 
 
ダウンロード