Oracle Client
15 min
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 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 output parameter type description result string result of the operation query executed string output field query executed row count number count value 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 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 name string name of the resource file string output field file example \[ { "result" \[ {} ], "query executed" "select from table1", "row count" 1 } ] notes see the following topics for more information sql query and oracle data types https //cx oracle readthedocs io/en/latest/user guide/sql execution html