How to Identify and Extract Agile data like Items,Changes from directly from database
Hi,
I’ve installed Oracle DB ,Middle-ware and Agile PLM application.
Successfully able to log into Agile Web client & Java Client.
I created some users and parts in web client.
would like to extract the same from database.
When i tried logging with default user details agile/tartan – Login failed.
When logged in with SYS account , not able to view any Agile tables like BOM,ITEM.
Could anyone please help me out in extracting Agile data from database.
Thanks in Advance,
Satish.
Hi Satish,
Based on what you wrote seems like you are not able to login with default credentials as well… You might need to look into that first.
Other then that, what’s the scope of your question? There are a couple of primary tables used to store PC information as below
Item, Change, Page_Two, Page_Three, BOM, Rev, nodetable, etc.
Regards,
Tariq
stevend17
Satish, is your question about what queries to use to get the data, or about getting access to the database? If its queries,I can help, but if its access, you may need your DBA to grant that. The username and passwords for the database are independent of those set up in the Agile client.