This database connector will allow you to connect to a MSSQL/MySql/Postgres server and run queries against a specific database. This plugin is only for use with Microsoft's SQL Server, MySql, Postgres.
Available Commands: SELECT, INSERT, UPDATE, DELETE, EXECUTE.
Install the plugin. Configure your host / database / username / password. Use Data (things) -> SQL Command to query data or execute SQL statements from your workflow(s). Use the data in your app as JSON or a datatype definition.
Available Commands:
SELECT Example: SELECT * FROM dbo.Table
INSERT Example: INSERT INTO dbo.Table SELECT Column1, Column2, Column3
UPDATE Example: UPDATE dbo.Table SET Column1 = 'data' WHERE Column2 = 2
DELETE Example: DELETE FROM dbo.Table WHERE Column1 = 'data'
Mesmo com a documentação não consegui ultilizar o plugin
Thank you for your feedback.
Unfortunately, we have no way of helping you unless you were to contact us and let us know you have a problem. The plugin is not the problem. Did you review the demo page which has working examples?
Could you connect to your database? Could you connect to your database but couldn't get data from a query? Who knows? Best of luck! (plugin author)
November 20th, 2023
•
BuildIt Branding
Testing App
October 15th, 2023
wq
steps missing from documentation
April 25th, 2023
documentation is quite unclear how to prompt the queries once you've connected the database...
Thank you for your feedback. I'm quite sorry that you struggled with how to use the queries. There is extensive documentation here: https://build-it-branding.gitbook.io/mssql-sql-database-connector/guide/introduction
If you want to try again we are happy to offer support or update our documentation with more specifics. (plugin author)