ShipWorks enables e-commerce web sites and businesses to manage and ship orders for multiple sales channels through one simple interface.
This article describes how to use a ShipWorks Data Reader to connect to a third party (Easysoft) ODBC data source.
ODBC provides a uniform, cross-DBMS interface and insulates applications from the database by using middleware known as an ODBC driver to translate the application's (i.e. ShipWorks Data Reader) requests into something that the database understands.
Easysoft provide a number of ODBC connectors that enables client applications such as ShipWorks to access databases and backends such as Oracle, MySQL, SQL Server, PostgreSQL, DB2 and Salesforce.
In addition, Easysoft's ODBC-JDBC Gateway enables an ODBC-compliant application to access a Java database though that database vendor's JDBC driver.
Installing and Licensing the Easysoft ODBC Driver
- Download the Windows ODBC driver for your backend platform
- Install and license the ODBC driver on the machine where the ShipWorks software is installed.
For installation and licensing instructions, refer to the documentation for your Easysoft driver.
—Or, if you want to connect ShipWorks to a Java Database—
Installing and Licensing the ODBC-JDBC Gateway
- Download the Windows ODBC-JDBC Gateway.
- Install and license the ODBC-JDBC Gateway on the Windows machine where ShipWorks is installed.
For installation instructions, see the ODBC-JDBC Gateway documentation.
- Use the ODBC-JDBC Gateway Setup Java Interface dialog box to select the JVM included in the JRE / JDK distribution recommended by your Java database vendor.
Configuring the ODBC Data Source
Before you can use an Easysoft ODBC Driver to connect ShipWorks to an external database, you need to configure an ODBC data source. An ODBC data source stores the connection details for the target database and the ODBC driver that is required to connect to it.
You configure ODBC data sources in ODBC Administrator, which is included with Windows. To start ODBC Administrator, in the Windows Run dialog box, enter:
In ODBC Administrator:
- Choose the System DSN tab.
- Choose the Add button.
- Choose the Easysoft ODBC driver from the list of drivers, and then choose OK.
- Complete the fields in the Easysoft Driver DSN Setup dialog box.
Refer to the documentation for your Easysoft driver for information about the fields you need to complete.
Creating an ODBC Connection in ShipWorks
ShipWorks can connect to an external ODBC data source. The ODBC connection can be used to pull data into ShipWorks or push data from ShipWorks into the ODBC backend.
- Log into ShipWorks as a user who has rights to add and/or edit a store.
- On the Manage tab, choose Stores. Then, choose Add Store.
- Choose the platform you are adding to ShipWorks from the What platform do you sell on? drop-down menu. Choose Next.
- On the Setup Import Data Source screen, choose the Data Source: menu. Choose the Easysoft ODBC data source you want to connect to.
- If the backend requires a user name and password, enter these details when prompted.
- Test the connection and choose Next.
The Easysoft ODBC driver connection is now available for use in ShipWorks.