The amazing world of IBM ODM and more

The amazing world of IBM ODM blog - Angello Manrique Vigil
  • HOME
  • ABOUT ME
  • CONTACT ME

ODM Java API

Connecting to external Database with ODM API

Thursday, 17 August 2017 by Angello Manrique Vigil

The IBM ODM Decision Center and the Rule Execution Server values are stored, by default, in a Derby database that comes with the IBM ODM suite installation. During a rules development project we sometimes need to access these values and insert them on an external database or update this external database accordingly. In this post I will show you how to connect to an external Datase with the ODM API in java and execute a simple query after collecting Decision Center values. You can use this method in your project with any values you need from the Decision Center.

To understand the basics of the ODM API, please refer to my previous post about the IBM ODM API here.


  1. Preparing Decision Center Values
    • In our Java project make sure you can connect successfully to the Decision Center.ODM API connection decision center sample
    • Personalize the values you need from the Decision Center. For example the Rule project name:IBM ODM API rule project name sample
  2. Connecting to an External DB
    • Let’s create a new Java class with the Connection details.odm api db java class sample
    • It is a good practice to have the value of the connection datasource in a properties file.odm api db java properties sample
    • Create a getConnection() method in the DBConnection class and add the following structure:odm api java db sample
    • Return the con variable and call this method from the main ODM API java class:odm api java db method sample

Now you are ready to execute any statement in the external DB using the Decision Center variables. Query statement sample: ps = con.prepareStatement(“INSERT INTO db.dt VALUES (‘”+ruleProject.getName())

I hope you enjoy this tutorial and please feel free to contact me with any query or feedback, thank you!

DecisionTableJavaODMAPIRuleDesigner
Read more
  • Published in Debug, Decision Center, Decision Table, Java, ODM API, Rule Designer
2 Comments

Custom log file with ODM API

Tuesday, 04 July 2017 by Angello Manrique Vigil

Given the positive feedback from previous post we will continue to work further on with the ODM API and discover new possibilities and features to implement in our Rule projects. In this tutorial we will see how to create a custom log file, focusing on obtaining the values from Deployments of Decision Services within the Business Console.

To understand the basics of the IBM ODM, please refer to my previous post about the IBM ODM API here.


  1. Creating a custom log file
    • In our Java ODM API project let’s create a global variable to define the output file.IBM ODM API log file java variable sample
    • Now create a constructor method to add the values you want in your custom log file. In this example we are obtaining the deployment time stamp when a business user deploys a Decision Service from the Business Console:ODM API custom log java sample
    • Tip: Remember we need to throw an IOException class for our constructor.
    • We can continue adding the values we require in our outfile variable. In this code example we are getting the following values:
      • The timestamp an element changed (for example the deployment report)
      • Who changed the element and who deployed it (business user who deploys the Decision Service)
      • Rule project nameIBM ODM API log variables sample java
    • Tip: Remember to format the log file with methods like newLine() and flush().
    • Now we need to repackage and reinstall the teamserver.ear with our custom jar file and it will automatically start generating the log file when we make a Decision Service deployment. I will make a post explaining this process in detail in the future.

If we did not specify an output location for the log file you will find it in <Your WAS Installation Path>\logs. I hope you enjoy this tutorial it helps you, please feel free to contact me with any feedback or questions! Thank you!

DecisionCenterJavaODMAPIRuleDesigner
Read more
  • Published in Decision Center, Java, ODM API, Rule Authoring, Rule Designer
2 Comments

Working with the Decision Center API

Wednesday, 21 June 2017 by Angello Manrique Vigil

In many IBM ODM rules implementation projects we are going to have requirements that involve working with the IBM ODM API. Even though the Decision Center has a lot of powerful features to customize our rules, there are some things that can only be achieve by working with the API, this means we will have to work with java code and be familiar with the ODM API classes to accomplish our goals. In this tutorial I will show you the basics of how to establish a connection with the Decision Center from the Rule Designer and retrieve valuable project information. You can apply this for your particular requirement.


Steps:

  1. Getting familiar with ODM API
    • We first need to take a moment and review some of the most important classes in the IBM ODM API documentation (IlrSession) , it’s ok if you don’t fully understand how they work at first. It is all about practice.
    • Enter here to access the documentation.
  2. Creating a Java project
    • Open Rule Designer and create a new Java Projectnew java project odm sample
    • Now we have to add the teamserver libraries to the build path for our Java project:properties java build path sample odm
    • Tip: the libraries are in <your_installation_path>\teamserver\lib
  3. Establishing the decision center connection
    • Create a new main class to test our remote ODM API decision center connectionjava main class sample odm
    • Our java class needs to implement the IlrSession class:remote connection sample session odm api
    • Create your connection parameters, in my case:ibm odm api connection remote session parameters sample
    • Now in our main class we need to create an object of the IlrSessionFactory class that implements IlrRemoteSessionFactory
    • Lets call the connect method:ibm odm api connection remote session parameters sample
    • Tip: be sure to work in a try/catch block to manage any connection exceptions
  4. Obtaining Decision Center data
    • Now that we are able to connect to the Decision Center repository let’s try to obtain information about the project
    • Create an object of IlrSession to obtain the current session:factory odm api sample
    • Lets obtain the rule project name:ibm odm api rule project name code sample

Results:

We can work and obtain pretty much any data, object or method that is inside the Decision Center repository. We can also create our custom jar classes and repackage the teamserver.ear with it.

I hope you enjoy this tutorial and please let me now if you need help working with the ODM API and what do you want to see next. Thank you!

DecisionCenterODMAPIRuleDesigner
Read more
  • Published in Decision Center, ODM API, Rule Designer
No Comments

Recent Posts

  • RPA – UiPath: Working with Excel

    In this blog post we will talk about working wi...
  • ODM on Docker!

    If you are a DevOps enthusiast like me you prob...
  • RPA: UiPath and ODM integration

    In this technical tutorial we will have a look ...
  • Populating Decision Tables with external data sources

    One of the most used artifacts in IBM ODM is th...
  • Decision Composer, integration with Rule Designer

    In this post I will show a new way to start you...
  • Connecting to external Database with ODM API

    The IBM ODM Decision Center and the Rule Execut...
  • Custom log file with ODM API

    Given the positive feedback from previous post ...
  • Working with the Decision Center API

    In many IBM ODM rules implementation projects w...
  • Automating deployments with Ant tasks

    To deploy RuleApps to Rule Execution Server, au...
  • Editing business rules in Microsoft Office

    IBM ODM Decision Center Business Console provid...

Categories

  • Ant Tasks
  • Bluemix
  • Cloud
  • Database
  • Debug
  • Decision Center
  • Decision Operation
  • Decision Table
  • Decision Warehouse
  • Docker
  • Domains
  • Java
  • ODM API
  • RPA
  • Rule Authoring
  • Rule Designer
  • Rule Execution Server (RES)
  • Rule Solutions for Office
  • Ruleflow
  • UiPath

Recent Posts

  • RPA – UiPath: Working with Excel

    In this blog post we will talk about working wi...
  • ODM on Docker!

    If you are a DevOps enthusiast like me you prob...
  • RPA: UiPath and ODM integration

    In this technical tutorial we will have a look ...
  • Populating Decision Tables with external data sources

    One of the most used artifacts in IBM ODM is th...
  • Decision Composer, integration with Rule Designer

    In this post I will show a new way to start you...

Recent Comments

  • Mastan on Debugging a simple Ruleflow in Rule Designer
  • Angello Manrique Vigil on ODM on Docker!
  • brian on ODM on Docker!
  • Angello Manrique Vigil on Populating Decision Tables with external data sources
  • Pramod on Populating Decision Tables with external data sources

Subscribe

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

All rights reserved. Made by Angello Manrique Vigil.

TOP