node-sqlagent icon indicating copy to clipboard operation
node-sqlagent copied to clipboard

Flow + SQLAgent + MSSQL

Open yilativ opened this issue 2 years ago • 2 comments

Hi, I've been trying to integrate Flow and would like to create a Database component that I can use that will be able to connect and query a MS SQL instance.

I'm seeing that this is compatible with totaljs platform. Would the instructions be where I can:

  • go into flow
  • create component
  • follow the readme instructions on SqlAgent
  • is there a module I should follow to then enable QueryBuildery functionality so I can MSSQL connectivity/operation functionality in my flows

Thank you for any insight

yilativ avatar Nov 14 '23 20:11 yilativ

You can be inspired by this: https://github.com/totaljs/flowstreamcomponents/blob/main/components/postgresql.html

  • you need to use MS SQL connector only from NPM

petersirka avatar Nov 14 '23 21:11 petersirka

Thank you, I'll then use the Import Component and copy the code to try to use it

yilativ avatar Nov 14 '23 21:11 yilativ