Action properties for Integration Framework (MIF)

In a recent forum post, I was asked why the data being imported was being overwritten and not replaced by the data specified in the integration table or flat file.  In short, the answer is you have to specify an ‘action’ property when importing the data.  That property is optional, but you can tell MIF what action to take when it encounters a situation like this one.  Here is a list of actions to use when importing data.

  • Add – Add records to database in receiving system
  • AddChange – Add or update existing records in the database in the receiving system
  • Change – Update existing records in the database in the receiving system
  • Delete – Delete records from the database in the receiving system
  • Replace – Substitute existing records in the database in the receiving system
  • null – Add records or replace records in the database in the receiving system depending on whether the primary record exists in the database.
    • If the primary record does NOT exist in the database, the system performs an Add action
    • If the primary record DOES exist in the database, the system performs a Replace action.
Series Navigation< Creating Additional Continuous Queues and MDBsHow to use XSL Transformations with MIF’s Publish Channels for Outbound Data >

Did You Know...

As Maximo Experts, we have developed Maximo adds on products to make Maximo work assignment simple, reporting easy, and facilitating service requests seamless. Check out our additional products EZPlanner, EZInsight, and EZRequest.

Find Out More

15 thoughts on “Action properties for Integration Framework (MIF)

  1. Hi Chon, is this action placed in the ACTION attribute in the MXIN_INTER_TRAN table? I thought this attribute was for Sync or Publish values.
    Thanks

      1. I know there’s an ACTION attribute in the interface table, but how do you specify a certain action if you’re importing via file upload? Do you need to add an extra column to the flat file?

  2. Hi Chon,

    If we are posting data to Maximo web service interface using a load tool like Informatica (Web Service Producer) is there a way that we can grab the Maximo response / error message back at the sender – the standard request response model of webservices. To keep this simple I would ask how do I or what do i need to configure a Maximo webservice to get the message that’s written to message tracking table.
    thanks
    Madhu

      1. Hi Chon,

        This is for Inbound data processing using webservices. Its a data load operation. I publish data from Informatica to Web Services interface (JMS Queue enabled) in Maximo. They get processed and as the enterprise services bound to this webservice in Maximo are message tracking enabled, an sucess or fail message is posted to message tracking table.

        As these are standard AXIS webservice engine that’s used, is there a way that i can capture the message put into message tracking application at the webservice sender.

        thanks
        madhu

        1. I don’t think that is possible. In some cases a web service transaction may take as long as 30 minutes to run, sometimes even longer depending on the data. You don’t want your Informatica to sit and wait for the response if that web service is taking that long to process.

          1. Hi Chon,
            If I use transformation as opposed to target for sending data through webservices to MIF I find the response is coming back in the output of transformation only for those records which are successfully inserted or updated. but all the failure messages are being written in Session log.

            I want those messages to be written in my file which are connected to output port.
            Or I want them to be captured by some means in informatica and definitely not in Session log.
            is there any way to do that?
            can I capture them using Source as to read ?

  3. Hello Chaon,
    is there a way to specify default action for, say, object within EnterpriseService?

    For example, if no action is specified in inbound XML message, i want it to be “Update”, not Sync as it works by default. I use webservices.

    Thank yoy

  4. In Maximo 7.5.0.3, I have tried both ‘Change’ and ‘Replace’ but it’s not clearing a field when loading Asset back to the system.

    Example: 1. Exported asset data using MXASSET
    2. Cleared Vendor and Manufacturer details from template (Using flat file method)
    3. Imported asset data using MXASSET
    4. Still i can see Vendor and Manufacturer details in Asset

Leave a Reply

Your email address will not be published. Required fields are marked *