https://embedded-workflow-builder.netlify.app/assets/js/8cc49012.1bcf244b.js

1"use strict";(self.webpackChunkembedded_workflow_builder_docs=self.webpackChunkembedded_workflow_builder_docs||[]).push([["7648"],{48355(e,n,t){t.r(n),t.d(n,{metadata:()=>s,default:()=>h,frontMatter:()=>i,contentTitle:()=>o,toc:()=>d,assets:()=>c});var s=JSON.parse('{"id":"connectors/oracledb","title":"Oracle Database Connector","description":"Query and manage data in an OracleDB database.","source":"@site/docs/connectors/oracledb.md","sourceDirName":"connectors","slug":"/connectors/oracledb","permalink":"/connectors/oracledb","draft":false,"unlisted":false,"tags":[],"version":"current","frontMatter":{"title":"Oracle Database Connector","sidebar_label":"Oracle Database","description":"Query and manage data in an OracleDB database."},"sidebar":"docs","previous":{"title":"OpenAI","permalink":"/connectors/openai"},"next":{"title":"Oracle Fusion Cloud HCM (Beta)","permalink":"/connectors/oracle-fusion-cloud-hcm"}}'),r=t(74848),a=t(28453);let i={title:"Oracle Database Connector",sidebar_label:"Oracle Database",description:"Query and manage data in an OracleDB database."},o,c={},d=[{value:"API Documentation",id:"api-documentation",level:2},{value:"Connections",id:"connections",level:2},{value:"On-Premise Connection",id:"oracledbconnection",level:3},{value:"Prerequisites",id:"prerequisites",level:4},{value:"Configure the Connection",id:"configure-the-connection",level:4},{value:"Actions",id:"actions",level:2},{value:"Query",id:"query",level:3}];function l(e){let n={a:"a",code:"code",h2:"h2",h3:"h3",h4:"h4",img:"img",li:"li",p:"p",strong:"strong",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",ul:"ul",...(0,a.R)(),...e.components};return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsxs)(n.p,{children:[(0,r.jsx)(n.img,{alt:"Oracle Database",src:t(28197).A+"#connector-icon",width:"32",height:"32"}),"\n",(0,r.jsx)(n.a,{href:"https://www.oracle.com/database/",children:"Oracle Database"})," is a popular relational database system.\nThis component allows querying an Oracle database."]}),"\n",(0,r.jsx)(n.h2,{id:"api-documentation",children:"API Documentation"}),"\n",(0,r.jsxs)(n.p,{children:["This component was built using ",(0,r.jsx)(n.a,{href:"https://node-oracledb.readthedocs.io/en/latest/user_guide/introduction.html#getting-started",children:"Node.js for Oracle Database"}),"."]}),"\n",(0,r.jsx)(n.h2,{id:"connections",children:"Connections"}),"\n",(0,r.jsx)(n.h3,{id:"oracledbconnection",children:"On-Premise Connection"}),"\n",(0,r.jsx)(n.p,{children:"Authenticate requests to an OracleDB server."}),"\n",(0,r.jsxs)(n.p,{children:["Create a connection of type ",(0,r.jsx)(n.strong,{children:"On-Premise Connection"})," to authenticate with an Oracle Database server using a direct connection with host, port, and database credentials."]}),"\n",(0,r.jsx)(n.h4,{id:"prerequisites",children:"Prerequisites"}),"\n",(0,r.jsxs)(n.ul,{children:["\n",(0,r.jsx)(n.li,{children:"An Oracle Database instance accessible from the network"}),"\n",(0,r.jsx)(n.li,{children:"Database user credentials with appropriate permissions"}),"\n"]}),"\n",(0,r.jsx)(n.h4,{id:"configure-the-connection",children:"Configure the Connection"}),"\n",(0,r.jsxs)(n.ul,{children:["\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Host"}),": The hostname or IP address of the Oracle Database server (e.g., ",(0,r.jsx)(n.code,{children:"192.168.0.1"}),")"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Port"}),": The port the database server is exposing (default: ",(0,r.jsx)(n.code,{children:"1521"}),")"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Database"}),": The Oracle database SID to connect to (e.g., ",(0,r.jsx)(n.code,{children:"xe"}),")"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Username"})," (optional): The username for authenticating with the Oracle Database server (omit when using OS authentication)"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Password"})," (optional): The password for authenticating with the Oracle Database server (omit when using OS authentication)"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Connection Timeout"})," (optional): The amount of time in seconds to wait for a connection to be established before timing out (default: ",(0,r.jsx)(n.code,{children:"10"}),")"]}),"\n"]}),"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n",(0,r.jsxs)(n.table,{children:[(0,r.jsx)(n.thead,{children:(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.th,{children:"Input"}),(0,r.jsx)(n.th,{children:"Comments"}),(0,r.jsx)(n.th,{children:"Default"})]})}),(0,r.jsxs)(n.tbody,{children:[(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Host"}),(0,r.jsx)(n.td,{children:"The host name or IP address of the Oracle DB server."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Port"}),(0,r.jsx)(n.td,{children:"The port of the Oracle DB server."}),(0,r.jsx)(n.td,{children:"1521"})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Database"}),(0,r.jsx)(n.td,{children:"The database SID in Oracle DB."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Username"}),(0,r.jsx)(n.td,{children:"The username used to authenticate to the Oracle DB server."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Password"}),(0,r.jsx)(n.td,{children:"The password used to authenticate to the Oracle DB server."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Connection Timeout"}),(0,r.jsx)(n.td,{children:"The amount of time (in seconds) to wait for a connection to be established before timing out. Default is 10 seconds."}),(0,r.jsx)(n.td,{children:"10"})]})]})]}),"\n",(0,r.jsx)(n.h2,{id:"actions",children:"Actions"}),"\n",(0,r.jsx)(n.h3,{id:"query",children:"Query"}),"\n",(0,r.jsx)(n.p,{children:"Returns the results of an OracleDB database query."}),"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n",(0,r.jsxs)(n.table,{children:[(0,r.jsx)(n.thead,{children:(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.th,{children:"Input"}),(0,r.jsx)(n.th,{children:"Comments"}),(0,r.jsx)(n.th,{children:"Default"})]})}),(0,r.jsxs)(n.tbody,{children:[(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Connection"}),(0,r.jsx)(n.td,{children:"The OracleDB connection to use."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"SQL Query"}),(0,r.jsx)(n.td,{children:"The SQL statement to execute against the database. Use named parameters (e.g. ':name') to safely bind values supplied through the parameter inputs."}),(0,r.jsx)(n.td,{children:"SELECT * FROM mytable WHERE name = :name AND company = :company_id"})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Named Parameters"}),(0,r.jsx)(n.td,{children:"Optional named parameters to insert into a query. Ensure the keys of these parameters match parameters in the query. For example, if the query contains ':company_name', give this parameter the key 'company_name'. Values specified here are merged with values supplied from the 'Named Parameters Object' input."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Named Parameters Object"}),(0,r.jsx)(n.td,{children:"Optional named parameters to insert into a query. Ensure the keys of these parameters match parameters in the query. For example, if the query contains ':company_name', the object should contain a key 'company_name'. Values in this object are merged with values supplied from the 'Named Parameters' input."}),(0,r.jsx)(n.td,{})]})]})]})]})}function h(e={}){let{wrapper:n}={...(0,a.R)(),...e.components};return n?(0,r.jsx)(n,{...e,children:(0,r.jsx)(l,{...e})}):l(e)}},28197(e,n,t){t.d(n,{A:()=>s});let s="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAACXBIWXMAAAsSAAALEgHS3X78AAAEzElEQVRYhc1XTWgUSxCubFYUJOIPBCWKHoIaghJ/DuIhEUUP6lFEBX2CIIqHoOhBjeSighgPggdF30PRgAcPijd/UQ+iJkYUBRX8DXHdxCSa7O50T09/j+qZyc7uzuzse6cMFDO73V1VXfXV111EEQ+IqkBU7f8eJZqZJfrLIvo7R/QyRzSUI9Ke8PfLLNE/PAdEMwN6qllXlJ3QB0QJFv4WRIs8o8MgAoi0JoJNBMsT/tbeGM/hubxmhGhRsb7YB96u+4lqckQdgkiwUuUqdnJENr99474Ex3gur+G1rIN1BXXHGreIGiyiHlYiiZwskeJQFxuNEp7La3gt62BdrLOsE/AGMkQrJFHKC6X9XwyHOcI6vI2kWHeoE8jnu9Em6uMFvIMChVVVsBIJWNXVsJLJcOExnlPkCOtinaybbQRtko9QENVIoq4S42yYFRfuLFTKrfGd8Gz4mKgK7r7DD3vJzvmdTEI0NcHetQvq+HGoCxegrlyBunwZ6tw52G1tkJs3Q8ybV7o277hJB9sqiIIgapJEWeHlrTiE9r59wPfvwO/f0G/fwrl/H+rGDairV6E6O+HcugXnyRPoT5+A0VHori7IlpYSJ1g32/BsNY1hQBJdLAm9F0J7yxYgm4W9bRusyZNDUxHcsaitherogB4chKirK3EikIqLxniGqE4QDdjFu08mjXL7wAHwY7e3Qy5bBmvKlJL8+vOt2lrI1avhXL8OOI5JmRkLAJNtsC22ybZJEe3wcl9ILr4Dhw5Bp1Jw7t4FhoeBdNqkQT99CufRIziPH0M/fw794QMwNAT09cG5fdt8iyVLShzwScsjtx0c/kuh4PMdOHYMzoMH7n+8w1WrYO/cCfvgQTPG4LNbW02q5PLlsCZONFHS6TQERyzcAZ8bLjHrdZWNwJEj0K9fmzyanPvvMEkkzFssWAD8+RMbAbZNfJKV5D/oQGurwYB+9w7q7FnI7dshVq6EmD8fYu5cU3aisRFyzRrIvXuhrl0DBgZcDCxeHOWAwQHbpkiq9R04ehS6uxv27t3Qd+64uU6ngcFB4NevMdE/fkC/eQOns9NwBfr7I1MQdIRiHWAMPHzolhuX04QJsKZPd3e+cKEJt5g9G1ZNTb46pk41TlbqwFDZFLS1QT97FsluYazJ9W+qYOnS+BRYcSD0MMDlxpwgmpsh5sxx+YCJiWXaNIj6esgNG2CfPAl8/gxoXQ4DeRDKuDI8fNgA0D5xAvrVK+ifP03+mRv0t2/Qvb0uJpgDentNyar2dgPEMhHIl6GKIyLGwL17LgYSCQjOP6O+uRly3TrItWvdqqivh2Ac8DzmgVQKgnkhjogycVS8fz/0ly+wZs1yF5fjAQ8D7BgyGYiGhngqjjyMfLDNmGEigJER81anT8Peswdy0ybI9eshN26E3LrVOKrOn4fT3Q1YFtSpU6FALTmMKjmOzSnX0gJ15gwc5oKeHuiPH6G/fjXR0e/fQ794AefmTcOcXJphFRN6HKOSC4kXwoKjl/lg0iRXvPovOJ5Daj/0QoK4K5kv/l0wglTi5kReySq+lBZHJUwi5pe9lI6La/m4aEzGRWtGeSfGmkluMP9vc8qNbbG+ip/i9pxbbm69uQWPas/ZKM/hVj4Y0XLt+b9LMWWpMfYH0wAAAABJRU5ErkJggg=="},28453(e,n,t){t.d(n,{R:()=>i,x:()=>o});var s=t(96540);let r={},a=s.createContext(r);function i(e){let n=s.useContext(a);return s.useMemo(function(){return"function"==typeof e?e(n):{...n,...e}},[n,e])}function o(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(r):e.components||r:i(e.components),s.createElement(a.Provider,{value:n},e.children)}}}]);