Database Utility

[adrian_horton]

What database utility is used to actually browse data in the ESO/CLM database?  For example, I need to know the base UOM for all material in ESO to determine the impact if I disable certain UOM.  The export to Excel material report does not display UOM.  I have to enter each material individually and I have over 120,000 material.

Also, we have ESO and CLM running on seperate installations.  There have been recent discussion within my organization to consolidate the 2 instances onto a single instance where ESO will host CLM.  Hence, I will need to evaluate/determine how to extract the CLM contract data/documents from CLM into ESO.

Any help on this is greatly appreciated!

Thanks,

Adrian

[Former Member · Accepted solution]

Hi Adrian,

You can use database access tools such as TOAD or SQL Plus to browse ESO/CLM tables. You will need to connection information to such as the TNS name, user id and password. Once you get access to the database, you will have to write SQL statements to extract information that you need from the tables.

If you are unable to get the database access you can view the database tables from the application itself. Navigate to Set up --> System Set up --> Queries and Reports --> Browse Full Schema. This will give list of all tables in the backend and when you open a table, you will see the columns each table.

Also there is another option to browse Extension Schema which are the dynamic tables created in the backend when custom fields are created.

There should be tables available to extract both UOM and Materials data and Contract documents data as well.

Hope this info helps.

Regards,

Parankush