The SQL Webstore allows Descartes ShipRush Web to connect to any standard database (such as Access, SQL Server, MySQL, etc.) using simple SQL queries via an ADO data source.
Note: The SQL Webstore requires the use of the Desktop Toolbox, which can be downloaded here. Make sure to sign into your account after installation.
Why Use SQL Webstores?
You want tied to a system not naively supported by Descartes ShipRush
You need to work differently with a system that is supported by Descartes ShipRush
Examples of SQL Webstores
Tie to a custom Access order management database
Use with Great Plains (but put out in the warehouse where Great Plains is not running)
Use packing lists with printed bar coded order number; however, in the warehouse it should drive from the bar code and not from an accounting system
Steps to Use Descartes ShipRush SQL
Review this documentation.
Experiment with the Descartes ShipRush SQL Example Scripts (examples for Solomon, GP, Northwind and ASPDotNetStorefront).
Write the SQL queries to fetch and write the Descartes ShipRush data to your database.
Test the queries in Decartes ShipRush.
Go live.
Needed Parts to Use Descartes ShipRush ADO
-
Database that can be accessed by SQL Queries through an ADO driver (Access, SQL Server, Oracle, MySQL, and most others)
A direct ODBC Connection option does not exist; however, you can connect to a ODBC source using "Microsoft OLE DB Provider for ODBC". Descartes ShipRush is unable to assist with this connection path, but here is a sample connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:Userslalitha.manthenaDesktopNorthwind.mdb';
After order shipped from SRWeb, Shipping Charges updated in Freight column available in database.
Someone to write the SQL Queries. (Descartes ShipRush support is unable to assist with writing queries, beyond providing the documentation available here.)
SQL Webstore (you can develop using the Descartes ShipRush demo, if that is convenient.)
A few hours to put the pieces together.
To set up the SQL Webstore, familiarity with the database and comfort with simple SQL statements is required (but is not needed to use for shipping).
Note: Descartes ShipRush is unable to assist with the building and use of SQL queries but is always happy to assist in issues directly in the software.