1. ShipWorks
  2. Community
  3. Feature Requests

SQL Server ODBC Store Connector - A Couple of Suggestions

Follow
Avatar
JI Shipworks

We are using the ODBC connector to interface with a SQL Server based ERP and have a couple of requests:

1.  It would be helpful, at least for us, if the ODBC connector could see and link to views as well as tables in the SQL Server database, so that we could conveniently link to data contained in multiple tables without having to used custom query code to upload and download data.

2.  As a B to B manufacturer/wholesaler, we not infrequently ship COD and Saturday delivery.  Neither of these options can be passed from SQL Server to Shipworks via ODBC.  Both have to be selected manually at the time of shipment.  Also neither is available in the XML for upload back to SQL Server, so the ERP cannot be updated for the COD amount or Saturday delivery option.  Either or both of these would be helpful additions for us.

Thank you.

0

Comments

1 comment

Sort by Date Votes
  • Official comment
    Avatar
    Robert K.

    Hello,

    Thank you for reaching out! I would be happy to provide some insight to your questions.

    • While ShipWorks can only populate a list of tables in the drop down when setting up the download for an ODBC store, a simple custom query can easily be used to select from a view. Depending on the syntax of your database, the query should look similar to this:
    select * from viewname
    • The best way to accomplish pulling information into ShipWorks that doesn't have a field dedicated to it would be to utilize our Custom Fields. The custom fields can be displayed on the main order grid and filtered by as well. Since they can be used in filters, they can be combined with shipping profiles to make rules. As of right now our profiles can be set to automatically apply Saturday delivery for FedEx. While certain options are not available for profiles, the custom fields can still be used for internal reference within ShipWorks for certain circumstances.

    If you have any further questions on these situations I would be more than happy to open a support ticket with you to go more in-depth.

    Thank you and happy shipping,

    Robert K 

    ShipWorks | Technical Support Representative - Tier 2

    One Memorial Drive, 20th Floor, Saint Louis, MO  63102 

    ShipWorks.com | 800.952.7784

    Comment actions Permalink

Didn't find what you were looking for?

New post

Please sign in to leave a comment.