HOME > PRODUCTIVITY PRODUCTS > ODBC

Every day, your computer system generates endless facts and figures about sales, inventory, consumer trends, staff performance, and much more. Translating this valuable information into reports is the first step in the crucial analysis that is managing your business.

ODBC (open database connectivity), a Microsoft® standard, enables you to easily extract, manipulate, and present all of the data that is contained in computer system's files. Using ODBC provides many benefits. Specifically, you will be able to easily report on anything you choose to and you will be able to manipulate data as needed.

Run these reports, for example:

• Show me all inventory items that have had no sales as of the end of a specific period and have an inventory value greater than $1,000.
• Compare customer net sales and gross profit dollars earned by product class for a specific period, or compare it against a previous period.
• Show me all items that have been received during a specific time frame where the average cost has changed more than 2%.
• Create a mailing to all customers who have purchased more than $5,000 in the past month, and merge into Microsoft Word.

The possibilities are endless!

There are several ways to implement ODBC, including using Microsoft Excel (a spreadsheet application), Microsoft Access ( a database tool), or Crystal Reports (a report writing program). In fact, use almost any off-the-shelf software that is Windows-compatible.

ODBC provides endless options for reporting – from complex databases to simple wizard-produced reports, all customized for your specific needs. Take advantage of the flexibility ODBC offers and learn to use your POS data to your company’s best advantage.

For more information about ODBC, please e-mail us or give us a call at 1.800.569.6309.

The difference ODBC makes...