Firebird SQL Query
Query a Firebird SQL database.
Properties
| Name | Type | |
|---|---|---|
| engine | String=firebird:query | |
| connection | Object | |
| query | String | |
| schema | Object | |
engine
Must be firebird:query.
- Required
- Yes
connection
The SQL connection parameters.
- Required
- Yes
Properties
| Name | Type | |
|---|---|---|
| host | String | |
| database | String | |
| user | String | |
| password | String | |
connection.host
The network address of the Firebird SQL server e.g. `db.example.com:3306`.
- Required
- Yes
connection.database
The name of the Firebird SQL database.
- Required
- Yes
connection.user
The username to authenticate to Firebird SQL.
- Required
- Yes
connection.password
The password to authenticate to Firebird SQL. Requires `username`.
- Required
- Yes
query
The SQL query to retrieve the data.
- Required
- Yes
schema
Define the schema of the data, entering the field name returned by the SQL query into `Source`.
- Required
- Yes