Skip to content

Execute SQL query

Description

Expects a SQL query to execute, outputs a json in a long text format

Input Ports

Name dataType sourceType required description
Username text link-manual true The user name of the account
Password text link-manual true The password of the account
Host text link-manual true The host address of the database server
Port text link-manual true The port number of the database server
Database name text link-manual true The name of the database
Options data-item link-manual false Options are for some connection params that does not require a username and password
Query long-text link-manual true The raw query you want to execute

Scenarios

  • The user wants to connect to a mysql database and execute a raw query
  • The user wants to connect to a SQLite database and execute a raw query
  • The user wants to connect to a Postgress database and execute a raw query
  • The user wants to connect to a Oracle database and execute a raw query
  • The user wants to connect to a MSSQL database and execute a raw query

Use case

Command

Inputs
  • Username: root
  • Password: *****
  • Host: localhost
  • Port: 3306
  • Database name: deviceRepository
  • Options:
    options
  • Query: Select * from devices
Experienced tips
  • If you do not specify an database server Host address, the process will continue and use the default host address of localhost
  • If you do not specify an database server Port number, the process will continue and use the default port number of the database adapter
  • If you specify an incorrect database server Port number, the process will stop and provide you with the following error. connect ECONNREFUSED 127.0.0.1:33055
  • If the username or password is incorrect, the process will stop and provide you with the following error. ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server
  • If you target the Sqlite database adapter, you can access the data without making use of the username and password, only provide the filename inside of the options
Output

Output

Search Tags

Execute Raw database query