Integrating Decisions with External Oracle DatabaseLast Updated: 09/07/2016 Introduced in Verision: 3.0
This tutorial demonstrates how to Integrate Decisions with Oracle Database.
In this example we are going to demonstrate how to Integrate Decisions with Oracle Database, Add Table to created integration, and use System Generated Steps in a Workflow.
We begin with Creating Database Connection. In Decisions Portal we navigate to System > Integrations > Databases and click Create Connection on the Folder Actions Panel.
Database Integration window pops up. First, we define desirable Connection Name. Then, from Database Type drop-down we pick ORACLE.
Next, we have an option to specify properties to connect to Oracle Server. They are:
- Use TNS
- Database Name
- User Name
- Host Name
Also, we have an option to check Custom Connection String check-box, and specify our Connection String. Then, we can click Test button to test our database connection before we save.
If our Test Status is Success, we can click Ok to save this Database Integration.
We can see that our database connection is being created in System > Integrations > Databases Folder. Next, we navigate to the Connection Folder that we just created.
In our Database Integration Folder we have several Actions like: Edit Database Definition [Advanced], Delete Database Definition, Add Table, Add View, Add Procedure, Add Relationship, Manage, etc.
We click Add Table on the Folder Actions Panel.
In the resulting Database Integration window we select desirable table from Table Name drop-down and click Next to continue.
In the resulting window we select desirable Table Fields and Table Keys. Then, we click Next.
On the last Database Definition window we pick which Steps we need System to generate for us to use in Workflows. Then, we click Save.
System adds Table Integration to our Database Connection Folder.
Next, we are going to create a simple Flow to demonstrate how to communicate with Integrated Database Table using System generated Steps in Workflow process.
In the Designer Folder we click Create Flow on Folder Actions Panel.
In the resulting window we Name the Flow and click Create to proceed to the Flow Designer.
In the Flow Designer we can find Steps for our Integrated Database in Integrations > My Integrations > Database > [Integrated Database Name] > [Integrated Table Name]. In this example we add Get all from [Our Integrated Table Name] Step after Start Step in our Flow.
Then, we select our Get All step on the work-space and set Limit Count Input to Ignore.
Finally, we connect both outcomes from Get All step to the End Step in our Flow. This completes our Flow. We click Test Flow on the top panel of the Flow Designer to test our Flow.
Our Flow is being executed in the Debugger with no issues, and we should be able to see that Get All step returns Data from our Integrated Oracle Table.