MySQL Specific Configuration Settings
The information below is
for SharePoint Server 2010 (32-Bit). To connect to SharePoint Server 2013
(64-Bit) please use ODBC and the MySQL ODBC Data Provider
In the Layer2 Business Data List Connector the data source must be configured as
follows to connect to MySQL.
Figure 1: Sample connection to
connect SharePoint to MySQL via .Net Framework Data Provider for MySQL
Please note the following about settings, features and possible issues
- You need to have the .Net Framework
Data Provider for MySQL(called Connector/Net) and Windows installed on the
SharePoint servers that will execute the BDLC (that means all WFEs and the
application server running the timer service). You can find the component on the
MySQL Connectors page.
- Install the 32-bit provider. 64-bit does not appear to be supported for this
- Please select the MySQL Data Provider from the list of installed
- You can make use of any connection strings for MySQL as usual, e.g.:
Source=MyServerAddress; Database=MyDB; User Id=myUser;
You will find more information about MySQL
connection strings here.
- Note that you can use integrated authentication for better security. See
the MySQL ConnectionStrings page.
- You can make use of all SQL queries your data provider supports. You can
also use stored procedures that returns records, exec myStoredProcedure().
- You can make use of aliases in query to force auto-mapping in the BDLC, e.g.
select customername as title, to auto-map to a SharePoint title column.
- Bi-directional sync is generally supported. You query must be updatable for
this (note that most joins are not). You will also need write access rights for
Do you have any issues to connect? Please contact [email protected] for next steps.