...
Note |
---|
This article is also intended for individuals with a good understanding of SQL and relational databases. Familiarity with sql queries, inserts, updates and deletes is necessary to configure and use the Database V2 connector with Oracle Exadata at UConn |
The September 2023 Runtime release included several important changes to the Database V2 connector. These specifically added better null handling for updates. Check back soon for updated guides on how to best use this new functionality.
\uD83D\uDCD8 Instructions
...
In a working directory create a new component of type Process
Ideally there are existing connections to Oracle Exadata that were configured by your account administrator for you to us. Here is an example of the IDGarden Identities Oracle Database V2 Connector. Instructions for creating the connector are found in the UConn Boomi Administration SharePoint. Here is an example:
In your start shape select No Data
Add a Database V2 Connector to the Start Shape. In the example below the IDGarden Identities Oracle Database V2 Connector is selected as the Connection. Set the Action to GET.Click the green plus in the Operation to create a new Operation
On the New Connector Operation window click Import.
Select an atom that has firewall access to the exadata instance, leave the Get Operation Type as Dynamic Get. Click Next
On the Object Type drop down select the table or view you are trying to query. Click Next.
On the Database V2 Import Wizard window click Next.
The import wizard creates JSON Request and Response profiles. If your project team has standards for naming that are different then the default names supplied, click the yellow pencil to edit and rename the profiles. In the example here, Database V2 NAME (TABLE) GET Request is renamed to NAME GET Request.
After any renaming required to adhere to project standards, remove the WHERE clause in the SQL Query and click Save and Close. (To run this in test mode, you must set the Max Rows value to 99)
Add a stop shape and save the new process
...