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

  Chapter 24 MySQL

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 Shipping

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

  MySQL Items

MySQL can share Customers to share realtime data for customers.

  MySQL Customers

MySQL can share Vendors to share realtime data for Vendors.

  MySQL Vendors

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

  MySQL Audit

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

  MySQL EDI

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

  MySQL Sent

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 on Mac

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 Middleware

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 on Windows

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 System DSN

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 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 Connection

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