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
MySQL Integration with SharePoint, Office 365 and 100 more
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 [email protected] for next steps.
Step-by-Step Intros For Specific MySQL Integration Scenarios
You will find more information about specific scenarios here:
Please also note this product video at YouTube. Can't find the scenario you are looking for? Please contact [email protected] for help.
Next Steps for Product Evaluation
You can register to download and evaluate the Layer2 Cloud Connector here