In this tutorial I will show how to configure the Maximo Integration Framework in order to export data from Maximo into a Comma Separated Values (CSV) text file.
To achieve such goal we must configure the following chain:
- Object Structure
- Publish Service
- External System
If this is the first time you are using the Maximo Integration Framework, you should check that your MIF is properly set up before going ahead.
Open Integration > Object Structure application and create a new entry.
- Object Structure: D-PERSON
- Description: Demo Person Object Structure
- Consumed By: INTEGRATION
- Support Flat Structure: True
- Source Objects: PERSON
Remove unwanted attributes from the Object Structure. This will simplify the structure of the output file and will greatly improve performances of the import/export process.
Select the Include/Exclude Fields menu and check all the Exclude check-boxes except the following:
Go to Integration > Publish Channels application and create the following entry.
- Publish Channel: D-PERSON
- Description:Demo Publish Channel for Person data
- Operation: Publish
- Object Structure: D-PERSON
Go to Integration > External Systems application and create the following entry.
- System: D-EXTSYS
- Description: Demo External System
- End Point: MXFLATFILE
- Enabled: True
- Outbound Sequential Queue: jms/maximo/int/queues/sqout
- Inbound Sequential Queue: jms/maximo/int/queues/sqin
- Inbound Continuous Queue: jms/maximo/int/queues/cqin
Go in the Publish Channel tab and insert the D-PERSON channel created previously.
Don't forget to enable the Publish Channel and to save the External System.
To export the data stored in the Maximo PERSON table just click on the Data Export button. A dialog box will be displayed allowing you to enter an SQL where clause to filter to exported rows.
For simplicity just put a small number in the Export Count field to limit the number of exported rows.
Click on the OK button and your CSV file will be exported in a directory named flatfiles under the path specified in mxe.int.globaldir system property. In my environment the directory is D:\MIF\flatfiles. Here is how the output file should look like.
D-EXTSYS,D-PERSON,,EN DISPLAYNAME,FIRSTNAME,LASTNAME,PERSONID Tom Revis,Tom,Revis,REVIS Fred Stanley,Frederick,Stanley,STANLEY Keith Mills,Keith,Mills,MILLS Mark Jacoby,Mark,Jacoby,JACOBY Bob Pillance,Bob,Pilla,BPILLA
If the file does not appear in one or two minutes please verify your Maximo Integration Framework configuration.
Now you can include more attributes to your objects using the Include/Exclude Fields action of the Object Structure application or you can create your own object structure.
You may also try to import data in Maximo database or look at other articles about Maximo Integration Framework.
This is just the beginning of your journey in the MIF. Keep in mind that MIF is a powerful tool that allows to do many things.
Just to play a little bit let's do one last trick.
Go to Publish Channels application, open the D-PERSON object and select Enable Event Listener.
Now go in Administration > Resources > People and create a new person record. If you look in your MIF directory on the Maximo server and you should see that a new CSV file has been automatically created with the new person data.