Connectivity: Database
Overview
Database connectivity is used to enable direct access to information from major Database Management Systems (DBMS) in the market: MySQL, PostgreSQL, SQL Server, Firebird, and Oracle.
For this type of connectivity, Skyone Studio supports SQL commands such as SELECT, UPDATE, DELETE, CREATE, among others.
SELECT operations are the most common. They allow secure querying of the database, returning information in a structured JSON format.
UPDATE, DELETE, and CREATE operations are used when the system lacks processes exposed via APIs and require more control, as these commands modify the database directly. We recommend using views or temporary tables that will be processed later.
How to connect an account
After defining the type of connectivity, the next step is to choose the type of authentication. Only after these settings have been made will you be able to add a new account, as well as select, edit or remove one of the previously registered accounts.
To add a connected account, click on "Connected account" and then "Add connected account".

Follow the steps according to the type chosen in Database (authentication type):
Finally, click on "Save changes" to configure your module settings.
Next step: Create operations for the module
Read also: Connected accounts management
Last updated
Was this helpful?










