This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hello all,
We have a database table we created directly in the database without using Maximo database configuration application.
We can use this table in our BIRT report. However, we can not add it to Object Structure or application designer since Maximo is not aware of it.
Can I just create a new table in Maximo Database Configuration and point it to the same existing database table, without overriding existing table structure and data in it?
Please advise the best way to do this.
Thank you very much.
Haiyan
You might want to:
1. Re-name the existing table to a different name, i.e. MYTABLE_BACKUP
2. Create the table, with the correct name, i.e. MYTABLE, using the
Maximo DBConfig
3. Copy the data from MYTABLE_BACKUP to MYTABLE.
That's how I would do it.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
haiyanchen
Sent: May-02-12 8:18 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] How to add an existing database table to Maximo
Database Configuration?
Hello all,
We have a database table we created directly in the database without using
Maximo database configuration application.
We can use this table in our BIRT report. However, we can not add it to
Object Structure or application designer since Maximo is not aware of it.
Can I just create a new table in Maximo Database Configuration and point it
to the same existing database table, without overriding existing table
structure and data in it?
Please advise the best way to do this.
Thank you very much.
Haiyan
If you create the object in DBConfig, MAXIMO will import the definitions of the table without overriding it.
You will NOT be able to modify the table in DBConfig though, so any changes still have to be done in the database directly. You'd then have to delete the object in DBConfig and recreate it.
I have done this several times to make Maximo aware of custom tables.
The other alternative is to create the object in MAXIMO first, and then copy the values from the custom table into the new table you created and stop using the database only table. This way you can use DBConfig to maintain it going forward.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of haiyanchen
Sent: Wednesday, May 02, 2012 11:18 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] How to add an existing database table to Maximo Database Configuration?
Hello all,
We have a database table we created directly in the database without using Maximo database configuration application.
We can use this table in our BIRT report. However, we can not add it to Object Structure or application designer since Maximo is not aware of it.
Can I just create a new table in Maximo Database Configuration and point it to the same existing database table, without overriding existing table structure and data in it?
Please advise the best way to do this.
Thank you very much.
Haiyan
Thanks a lot. We got it done by renaming our DB only custom tables, creating the object in Database configuration and then copy the data into the newly created DB tables.
Next time we will try the first method and see if Maximo will import the DB table definition without overriding it. That would save some time.
Thanks!
--- In MAXIMO@yahoogroups.com, Sean Clark-McCarthy <smccarthy@...> wrote:
>
> If you create the object in DBConfig, MAXIMO will import the definitions of the table without overriding it.
>
> You will NOT be able to modify the table in DBConfig though, so any changes still have to be done in the database directly. You'd then have to delete the object in DBConfig and recreate it.
>
> I have done this several times to make Maximo aware of custom tables.
>
> The other alternative is to create the object in MAXIMO first, and then copy the values from the custom table into the new table you created and stop using the database only table. This way you can use DBConfig to maintain it going forward.
>
> --- Sean Clark-McCarthy
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of haiyanchen
> Sent: Wednesday, May 02, 2012 11:18 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] How to add an existing database table to Maximo Database Configuration?
>
>
>
> Hello all,
>
> We have a database table we created directly in the database without using Maximo database configuration application.
>
> We can use this table in our BIRT report. However, we can not add it to Object Structure or application designer since Maximo is not aware of it.
>
> Can I just create a new table in Maximo Database Configuration and point it to the same existing database table, without overriding existing table structure and data in it?
>
> Please advise the best way to do this.
>
> Thank you very much.
>
> Haiyan
>
>
>
>
>