Keep your Sharepoint in sync. Download and try today.
MySQL Integration with SharePoint, Office 365 and 100 more
MySQL data can be integrated and synchronized codeless with various external systems, on premises or in the cloud, using the Layer2 Cloud Connector. You will find a selection of supported systems and applications here.
In the Layer2 Cloud Connector the data source or destination entity must be configured as follows to connect to MySQL.
Fig. MySQL example connection in the Layer2 Cloud Connector.
MySQL Specific Configuration Settings
Please note the following about settings, features and possible issues.
- You need to have the MySQL ADO.NET Connector (called Connector/Net) and Windows intalled on the computer that runs the Layer2 Cloud Connector. You can find the component on the MySQL Connectors page.
- Install the 32-bit provider (must fit to your Cloud Connector installation architecture). 64-bit does not appear to be supported for this provider.
- Please select the MySQL Data Provider from the list of installed providers.
- You can make use of any connection strings for MySQL as usual, e.g.:
Data Source=MyServerAddress; Database=MyDB; User Id=myUser; Password=myPassword.
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.
- In case of integrated authentication (trusted connection) please make sure that the current user has appropriate database access rights. Also take care about access rights of the Layer2 Cloud Connector Windows Service. Best to use basic authentication with a specific user. In the connection string, the UserID will need to be: auth_windows.
- 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 Cloud Connector, e.g. select customername as title, to auto-map to a SharePoint title column.
- The primary key is normally set automatically, if available.
- 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 this.
Do you have any issues to connect? Please contact sales@layer2solutions.com for next steps.
Known Issues and Workarounds
- There is a known bug in MySQL ADO.NET Connector version 6.10.4 which was actually exposed by a Windows Update on 12nd of April 2018 that includes .NET Framework changes.
You will receive the following error message:"The implementation of ADO.NET Provider MySql.Data.MySqlClient.MySqlClientFactory' does not seem adequate for synchronization, since its CreateDataAdapter()-Method returned <null>. Please contact the provider´s manufacturer about this issue or try to use another provider!"
To work around the issue please roll-back to a prior version of the MySQL ADO.NET Data Provider until the bug is resolved by MySQL.
Step-by-Step Intros For Specific MySQL Integration Scenarios
You will find more information about specific scenarios here:
- How to connect and sync SQL with Microsoft SharePoint or Office 365
- Connect and sync MySQL data queries with Dynamics CRM or ERP via OData
- Push MySQL data to Microsoft Exchange on-premises or Exchange Online for mobile and offline access on any device (BYOD)
Please also note this product video at YouTube. Can't find the scenario you are looking for? Please contact sales@layer2solutions.com for help.
Ready to go next steps?