This content has been marked as final. Show 6 replies
You will need access to Siebel Tools to look at the joins (1:1 M:1) and link (M:M 1:M) objects that define the SQL joins (inner or outer) generated.1 person found this helpful
You can generate reporting to track this information, basically the column ROW_ID is nearly always used as Foreign Key.
The data model is also available online, what version are you working on ?
I am working on 7.7 and soon going to upgrade to 8.1.
it would be nice if you could share the data model for both the version.
Have a look on Oracle MySupport to
<li> Siebel Data Model Reference, Version 7.7 [ID 566251.1]
<li> Siebel Data Model Reference, Version 8.1.1 [ID 557187.1]
<li> Siebel Data Model Reference for Industry Applications, Version 8.1.1 [ID 557189.1]
I need to write SQL query to fetch data from siebel tools.
I am able to find the table and column name with help of siebel tools but i am facing issue finding the table joins.
Could some one help me on this.
Let us know what you want ot fetch
Any particular reason you're going directly to the tables for BI reports instead of using the Siebel/BI Integration web services? I just finished setting up Siebel 18.104.22.168 and BI Publisher, and found that using the web services is the best method of running reports.