Using SQL, you can query directly against an external data source to select, update, insert, or delete data from either the local database or the remote data store, including performing joins and filtering tables from both data stores.

While many businesses rely on QuickBooks Desktop for their inventory and accounting needs, only QuickBooks Enterprise allows scanning barcodes to reduce inventory tracked in QuickBooks. Unfortunately, QuickBooks Enterprise starts at $2,000 per year, so for many small businesses, this is simply not an option.