x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 47 subscribers
  • Views 637 views
  • Users 0 members are here
Browse Forums
Announcements
51
topics
34
replies
General Discussion
1k
topics
2k
replies
Michelle Lorber

ODBC Connections and Intergrations with Business Works

SUGGESTED
Posted By

Hi,

We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations.

We have a few questions:

  • Can we use SQL to set up an ODBC connection?
  • How can we obtain any extra licenses or permissions required?
  • Is it possible to use Excel 64 bit for ODBC reporting or is it restricted to 32 bit?

We 'd also like to hear from the community if anyone has experience integrating Business Works with other systems.

Many thanks,
Michelle

  • 0
    SUGGESTED

    Depending on what you are trying to ingrate, Business Works is going to restrict you on what you can bring IN to the program.  Currently, if using Inventory and Order Entry, you can only import in the Sales Order.  Then you can convert the Sales Order to an invoice once it is in the BW program.  Sage BusinessWorks database tables can be accessed from any application that can access ODBC drivers.  Sage BusinessWorks only uses 32 bit drivers.  

    For additional information, please use our Knowledge on the topics you discussed above.  To get to our Knowledge Base you an go to Help, Support and Service on the Web, On line support. (or go to www.sagekb.com ).  In the Knowledge Base, you can search these titles to find the following articles relating to your questions above.

    How to access database tables using ODBC

    How to create ODBC DSN drivers for Sage BusinessWorks

    How to create ODBC DSN drivers for Sage BusinessWorks

    How to query a database using Microsoft Excel

    Cannot see system DSNs

    How to import quotes and sales orders

    If you have further questions on these topics, I would suggest working directly with a support analyst to discuss your specific issue.  Please contact us via chat by going to Help, Live Chat or using this link: Live Chat and we will be able to assist you.  

    Sincerely,

    Coleen

*Community Hub is the new name for Sage City