SAGA.db_odbc.8: Import Table from SQL Query

Import a SQL table from a database via ODBC.

Inputs

Data Source Name

string

User Name

string

Password

string

Server Connection

string

Tables

string

Fields

string

Where

string

Group by

string

Having

string

Order by

string

Outputs

Distinct

transmission

Execution options

successUri
inProgressUri
failedUri

format

mode

Execute End Point

View the execution endpoint of a process.

View the alternative version in HTML.

{"id": "SAGA.db_odbc.8", "title": "Import Table from SQL Query", "description": "Import a SQL table from a database via ODBC.", "version": "1.0.0", "jobControlOptions": ["sync-execute", "async-execute", "dismiss"], "outputTransmission": ["value", "reference"], "links": [{"rel": "http://www.opengis.net/def/rel/ogc/1.0/execute", "type": "application/json", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8111/ogc-api/processes/SAGA.db_odbc.8/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8111/ogc-api/processes/SAGA.db_odbc.8/execution.html"}], "inputs": {"ODBC_DSN": {"title": "DSN", "description": "Data Source Name", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "ODBC_DSN"}, "ODBC_USR": {"title": "User", "description": "User Name", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "ODBC_USR"}, "ODBC_PWD": {"title": "Password", "description": "Password", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "ODBC_PWD"}, "CONNECTION": {"title": "Server Connection", "description": "Server Connection", "schema": {"type": "string", "enum": ["Default>"], "nullable": true}, "id": "CONNECTION"}, "TABLES": {"title": "Tables", "description": "Tables", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "TABLES"}, "FIELDS": {"title": "Fields", "description": "Fields", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "FIELDS"}, "WHERE": {"title": "Where", "description": "Where", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "WHERE"}, "GROUP": {"title": "Group by", "description": "Group by", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "GROUP"}, "HAVING": {"title": "Having", "description": "Having", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "HAVING"}, "ORDER": {"title": "Order by", "description": "Order by", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "ORDER"}}, "outputs": {"DISTINCT": {"title": "Distinct", "description": "Distinct", "schema": {"type": "boolean", "default": false, "nullable": true}, "id": "DISTINCT"}}}

http://tb17.geolabs.fr:8111/ogc-api/processes/SAGA.db_odbc.8.html
Last modified: Sat Dec 4 00:09:36 CET 2021