Integrating Decisions with External Oracle Database

Overview

Oracle Database is a multi-model database management system commonly used for running online transaction processing, data warehousing, and mixed database workloads. This tutorial demonstrates how to Integrate Decisions with Oracle Database.

Oracle Integration

This example, will demonstrate how to Integrate Decisions with Oracle Database, Add Table to created integration, and use System Generated Steps in a Workflow. 

1. Begin by Creating Database Connection. In the Portal, navigate to System > Integrations > Databases and click CREATE CONNECTION on the Folder Actions Panel. 
2. First, define a desirable Connection Name. 
3. Then, from the Database Type drop down, pick ORACLE.

   

4. Next, there are option to specify properties to connect to Oracle Server. Which are:
   1. Use TNS
   2. Database Name
   3. User Name
   4. Password
   5. Host Name
   6. Port
5. Click TEST before saving. If the Test Status is Success, then click OK to save this Database Integration. 
6. The database connection being created can be found in System > Integrations > Databases Folder. 
7. Next, navigate to the Connection Folder that was just created.

   

8. In the Database Integration Folder, there are several Actions: Edit Database Definition [Advanced], Delete Database Definition, Add Table, Add View, Add Procedure, Add Relationship, Manage, etc.
9. Click ADD TABLE on the Folder Actions Panel.

   

10. Select a desirable table from the Table Name drop down and click NEXT to continue.

    

11. Select desirable Table Fields and Table Keys, then click NEXT.

    

12. On the last Database Definition window, pick which steps the System needs to generate for the Workflows to use.
13. Then click SAVE.

    

14. The System adds Table Integration to the Database Connection Folder.