Hey Devs, I was curious if there is a way to take the data that exists in an entity and insert it into an external SQL DB ? I’ve created an application the will be used for logging lab samples. Functionally, I am trying to have the test results the user inputted, inserted into a table I created in our SQL Server environment. Ideally the submit button would trigger a microflow that will handle this process. Please let me know if any additional info is needed. Thanks for the assistance.
Yes, you can use the Database Connector module from the Marketplace for this. It supports Microsoft SQL Server. You would have to write microflows to take the data from your entity and execute INSERT statements on the SQL Server database,
You can find more information in the documentation.