Import real time data from MySQL to SharePoint

Copper Contributor

Hi,

We have recently implemented share point in our org and want to start building workflows in it.

Business Case-

We have forms submitted by our customers on our website and that data is stored in a MySQL database. I want that data to be auto populated in the share point so i can create a workflow.  This forms have 5 to 6 fields and the traffic is about 10 forms in a day. I want to get that data in the share point on a near real time basis meaning couple of times a day or at least one time. Could some one suggest a good approach for this and we also might have similar projects in the future.

1 Reply

@Uday33 one approach would be to use the MySql connector for Flow to copy data from the DB to a SPO list, see https://docs.microsoft.com/en-us/connectors/mysql/.