MySQL Access
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.
MySQL Custom
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.
MySQL Shipping
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 on Mac
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.
MySQL Middleware
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
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.
MySQL System DSN
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.
1. Open the Data Sources (ODBC) Control Panel (in Administrative Tools or Performance and Maintenance).
2. On the System DSN tab, click Add.
3. Select ODBC Driver for MySQL and click Finish.
6. Type a name (BB) in the Data Source Name field.
7. For Network Path, type "TCP/IP:" followed by the IP Address of the server.
8. Enter the User Name and Password you assigned to the ODBC Server.
9. Click Test Data Source to test the connection.
10. Click OK to save the ODBC Driver setup.
11. Click OK to save changes to the ODBC Data Source Administrator.
MySQL Connection
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.
Connection Settings for the Middleware Add-On include:
• Host - enter "localhost" or an IP Address
• User - enter a user name with adequate privileges
• Password - enter the user's password
• Database - enter the name of the database you want populated
• Port (optional) - leave blank for default (3306)
• Socket - using "localhost" is faster
MySQL Changes
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.