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.

Agile User Asked on November 1, 2016 in ERP integration,   Tools.

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.

on November 1, 2016.
Add Comment
1 Answer(s)

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

Agile Angel Answered on November 1, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.