Connect to UPS Data in DBArtisan

Use wizards in DBArtisan to configure UPS data as a data source.

The CData ODBC Driver for UPS seamlessly integrates UPS data into database management tools like DBArtisan by enabling you to access UPS data as a database. This article shows how to create an data source for UPS in DBArtisan and execute queries. You can then edit data visually and execute standard SQL.

Integrate UPS Data into DBArtisan Projects

If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.

The driver uses five pieces of information in order to authenticate its actions with the UPS service.

  • Server: This controls the URL where the requests should be sent. Common testing options for this are: https://wwwcie.ups.com/ups.app/xml and https://wwwcie.ups.com/webservices
  • AccessKey: This is an identifier that is required to connect to a UPS Server. This value will be provided to you by UPS after registration.
  • UserId: This value is used for logging into UPS. This value is the one you chose to login with when registering for service with UPS.
  • Password: This value is used for logging into UPS. This value is the one you chose to login with when registering for service with UPS.
  • AccountNumber: This is a valid 6-digit or 10-digit UPS account number.
  • PrintLabelLocation: This property is required if one intends to use the GenerateLabels or GenerateReturnLabels stored procedures. This should be set to the folder location where generated labels should be stored.

You can then follow the steps below to register UPS data as a database instance in your project:

  1. In DBArtisan, click Data Source -> Register Datasource.
  2. Select Generic ODBC.
  3. Enter a name for the data source and select the DSN.
  4. Finish the wizard to connect to UPS data. UPS entities are displayed in the Datasource Explorer.

You can now work with UPS data as you work with any other database. See the driver help documentation for more information on the queries supported by the UPS API.