Oracle Client

use this connector to execute an sql queries on an oracle database from swimlane turbine prerequisites this connector can connect to an oracledb using one of the following methods using connection string use oracledb auth with connection string asset to connect to the oracledb using a connection string a connection string will be in the following format \<username>/\<password>@\<host> \<port>/\<db name> using dsn (data source name) use oracledb auth with dsn asset to connect to the oracledb using dsn this asset requires the following parameters username password one of the following combinations of parameters host, port, sid host, port, service name dsn string a dsn string will be in the following format (description=(address=(protocol=tcp)(host=\<host>)(port=\<port>))(connect data=(sid=\<sid>))) or (description=(address=(protocol=tcp)(host=\<host>)(port=\<port>))(connect data=(service name=\<service name>))) capabilities this connector provides the following capabilities run read only query on a oracle database run modification query on a oracle database notes see the following topics for more information https //cx oracle readthedocs io/en/latest/user guide/sql execution html configurations oracledb auth with connection string connect to oracle databases using connection string configuration parameters parameter description type required connection string connection string to connect to the database string required oracledb auth with dsn connect to oracle databases using dsn configuration parameters parameter description type required db username username to connect to the database string required db password password string required dsn dsn string string optional host server host string optional sid database sid string optional service name database service name string optional port host port to use number optional actions run modification query run a query that modifies the database and does not return information example insert input argument name type required description query string required query using parameters is acceptable ('select from foo where id = %s or id = %s') parameters need to be supplied through the parameter input in order parameters array optional a list of parameters should be in order input example {"parameters" \["idparam1","idparam2"],"query" "insert into example1 values (2, 'bob');"} output parameter type description result string result of the operation query executed string output field query executed row count number count value output example {"result" "success","query executed" "insert into example1 values (2, 'bob');","row count" 1} run read only query runs the supplied query un constrained and returns the result only for queries that return information example select input argument name type required description query string required query using parameters is acceptable ('select from foo where id = %s or id = %s') parameters need to be supplied through the parameter input in order parameters array optional a list of parameters should be in order to csv boolean optional when true, returns a csv as an attachment input example {"parameters" \["idparam1","idparam2"],"query" "select table name from dba table","to csv"\ false} output parameter type description result array result of the operation query executed string output field query executed row count number count value file object file file file name string name of the resource file file string output field file file output example {"result" \[{"id" 1,"name" "adam"}],"query executed" "select from table1","row count" 1} response headers header description example content type the media type of the resource application/json date the date and time at which the message was originated thu, 01 jan 2024 00 00 00 gmt