Lookup data from SQL server, similar to MySQL integration?

#1

Hi again,

Does anyone have or know of a strategy for connecting to an SQL server database and select, insert, update, delete similar to the MySQL integration component I see?
Looking to respond to bot users questions about their account etc from an existing customer database.
Appreciated.

B

(Ryan McGuinness) #2

Hi,

This would be doable, although it wouldn’t connect directly to the SQL server. You would need to use an additional service to act as a middleman between Flow XO and your SQL server. The service you use would need to have a REST API, this would allow the use of webhooks in Flow XO.

Hope this helps,

Ryan.

(Joe Hatch) #3

@bp3849 I’ve looked at something similar where we’re using WordPress as a CMS with a decoupled front end.

So essentially to deliver content via a webservice api (REST) which is hosted in a traditional backend and database like MySQL.

I found a service called dreamfactory which has an open source version available for free if you want to self-host or they also offer paid options.

In theory this should be the middle man that @ryan.mcguinness mentioned.

1 Like
(John Jackson) #4

What an incredible find Joe, just what a lot of customers need. :slight_smile: Thanks!

1 Like
#5

Thanks Joe!
Up and running and tested.
Excellent!!
Appreciated

1 Like