IBM Support

How to Migrate existing Oracle View into Maximo Database Configuration

Technical Blog Post


Abstract

How to Migrate existing Oracle View into Maximo Database Configuration

Body

Depending on what you want to achieve, here's a basic guide on how to
migrate Oracle view into Maximo DB.

 

1) Create a view directly on the backend.
Create view MPCASSET as select * from asset;
later, you can select all records from MPCASSET, just to see the
resultSet, the same as in ASSET

 

2) Go to Maximo DB Config, and click New
Type the same name... MPCASSET
The app will automatically recognize the existing view and set Is View= trueSelect ASSET as the Extends Object
You may have to use the options for Join Object and View Where if you want more complex views .
Save


3) Run DB Config.

 

And here are some technotes that can also help as guide:

 

Having trouble creating a view by joining 2 objects?

/support/pages/node/1133565


Unable to View Data From a New Field in Computers Application

/support/pages/node/624159

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11130757