Chapter 24 MySQL


MySQL Plugin helps connect your other systems to share data with BigBusiness.


MySQL is the world's most popular open source database--simply the best for access.

Big Business has setup options to share data to with systems that can access MySQL. Your shipping station can get Orders to read shipping addresses and put back tracking.

If you have a web store you administer, you may want Items the instant they change. If your store is B2B, you may want Customers, too. It's up to you, what you can do.

Big Business 14.48 updates MySQL Access to add "non-blocking" options for Azure. Microsoft Azure is a cloud computing platform with option to run MySQL databases.


Big Business lets you access data such as Customer, Items, and Orders, using MySQL. We can connect Shipping for you, or you can get Items for your web store, or send all data to a parent company system like Oracle or for data warehousing. It's up to you.

This chapter provides a quick overview, highlighting recent changes and possible uses. Other chapters detail connecting Shipping or setting up Macs, Windows, using ODBC.


Shipping uses MySQL to connect FedEx and UPS workstations in a dedicated setup.

Shipping shares Orders or Invoices and get back Tracking and Charges, automatically. Additional data needs MySQL Plugin and setup for the additional data that you need.


MySQL can share Items to share realtime data for products and inventory.


MySQL can share Customers to share realtime data for customers.


MySQL can share Vendors to share realtime data for Vendors.


MySQL can share Audit information for creation and modification dates and times.


MySQL can share EDI information for realtime data for Electronic data interchange.


MySQL can share EDI coordination for realtime data for Electronic data interchange.


MySQL on Mac can share data from your Mac server to any other system including your Windows workstations or hosted solutions whether running MySQL or not.


Middleware and Middleware2 are options that allow Big Business to synchronize data through an external data source so it can be more readily accessed.


MySQL on Windows can share data from your Windows server to any other system including your Mac workstations or hosted solutions whether running MySQL or not.


This feature is part of the MySQL Plugin, which is an additional module that enables Big Business to synchronize data with MySQL.

This Solution describes Creating a System DSN for to connect, for example, UPS Worldship, to MySQL using ODBC.


MySQL Plugin is an option that allows Big Business to synchronize data with an external data source (MySQL) where it can be more readily accessed.


MySQL Changes are automatic and update your data in MySQL for realtime uses.

When you upgrade your version of BigBusiness and it changes content, your MySQL is automatically updated to include new fields, new types, and, as always, new data.