Can I leverage the new data export function provided by the Maximo integration framework to generate Optim™ import files for Maximo relationships from the Maximo metadata?
When you install Maximo Archiving with InfoSphere Optim Data Growth Solution, you have the option to install integration framework support. When you choose this option, a new object structure, ARCMAXRELATIONSHIP, is added to Maximo along with an outbound definition class that enables you to export MAXRELATIONSHIP data from the Database Configuration application to xml and to convert the xml into a format Optim can understand.
Enabling the application export of relationship data and converting to the Optim format
Enable the application export of relationship data and convert to the Optim format from the Database Configuration application as follows:
1. In the Object Structures application in Maximo, select the ARCMAXRELATIONSHIP object structure.
2. From the Action menu, select Add/Remove Application Export Support.
3. Select OK. It may take a few minutes to process as new buttons and security options are being created in the background.
4. Log out and log back in to use the new functionality.
When you add application export support a new security option IFEXPORT or Application Export is created and granted to any security group with read access to the Database Configuration application.
In the Database Configuration application you can now select one or more objects and export the relationships, creating an archive adapter on the fly.
For example, if a user just wants to export data for the work order object, he or she can do this by selecting just that object on the main tab. If the user wants to export data for an entire industry solution, he or she can filter on the list tab to show all the PLUST tables, for example, and export all the metadata for transportation industry solution.
Once you select your objects, you are prompted to select the Object Structure to use - choose ARCMAXRELATIONSHIP.
Exceptions to what relationships for your selected objects that the adapter contains
This adapter contains the relationships for your selected objects, with a few exceptions.
The system skips any MAXRELATIONSHIP where the WHERECLAUSE:
- is null
- uses dot notation (for example, when the object.attribute references an object not in the relationship)
- contains the terms: select, >, <, != or null (Optim relationships do not support these values).
When a valid WHERECLAUSE is found, it is converted to the syntax that is understood by Optim. You can then import these adapters into Optim just like the other relationships that ship with the product by replacing the standard constants (described below) and importing the files.
When a MAXRELATIONSHIP is converted, the constants used for the database are appended before the values of the parent and child attributes. You must replace the <DBALIASNAME> and <DBOWNERNAME> constants as you did when you imported the adapters shipped with the product.
Handling errors during import
Importing these adapters can often produce errors because MAXRELATIONSHIPS can have non-persistent objects, which are not supported for archiving as parent or child entities, and there is no way for the processing class to identify these at the time of processing. The error message displayed when you import these adapters will be similar to the following:
Unable to import Relationships:
Table 'db.owner.table' does not exist.
If an error appears when you import these adapters, select Continue import. Review the errors to ensure that the problem involves non-persistent objects.
These files contain only the relationship data. You need to create the primary keys and additions to access definitions in the Optim configuration tool. You can use these relationships to extend an existing definition, for example, adding MR information to the Work Order definition, or to create new relationships such as creating a new MR definition by entering the tables and selection criteria. Once you add the tables to the access definition on the Relationships tab in Optim, you will see your imported relationships indicated by the word New. When you select the relationships that you want to use and save the data, the New indicators disappear.