Open Database Connectivity (ODBC) in QAD

Posted on: March 14, 2022 | By: Chloe Cope | ERP Selection, QAD Business Process

QAD’s Open Database Connectivity (ODBC) functionality enables users to connect ad hoc query tools to a practice database and access curating data. It also allows the ability to send commands to communicate with that database. Additionally, it can use Progress ODBC drivers to connect to private, third-party Windows-based applications that use structured query language (SQL) to obtain data. SQL is a standard database interface language used by many application packs, such as Microsoft and Oracle, and many third-party tools that are database neutral.

Benefits of leveraging Progress ODBC:

  • A standard that allows third-party access to databases
  • Allows users to use third-party applications without needing to write their own applications
  • Allows users to use tools to create ad hoc queries using the Progress database
  • Gives users access to a fair number of applications they may not have access to otherwise

The Progress ODBC client is installed on the Windows client. It can then be accessed like any other ODBC client.

Progress ODBC is not a standard step of the QAD install, so users will want to have a consultant or expert install this functionality separately.

Next Steps

If you are interested in learning more about ODBC in QAD and/or maximizing the use of your QAD system, contact us here to find out how we can help you grow your business. You can also email us at info@loganconsulting.com or call (312) 345-8810.



Is Your Accounting Software Hurting Your Business?
Is Your Accounting Software Hurting Your Business?

Free Download:

Is Your Accounting Software Hurting Your Business?

Download the guide ›

24 Questions to Ask Before Implementing Your New ERP System
24 Questions to Ask Before Implementing Your New ERP System

Free Download:

24 Questions to Ask Before Implementing Your New ERP System

Download the guide ›

Top 10 Inventory & Operations Decisions Distributors Are Making Blind
Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Free Download:

Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Download the guide ›

2020 Nucleus Research Report on ERP Technology

Free Download:

2020 Nucleus Research Report on ERP Technology

Download the guide ›