4 Replies Latest reply on Nov 14, 2019 12:56 PM by 1376999

Does ODI generate SQL as OWB?

1376999 Nov 14, 2019 12:18 PM

Hi,

I want to generate SQL code in ODI like OWB (https://gerardnico.com/dit/owb/sql_generated ). Is it possible?

Thanks!

1. Re: Does ODI generate SQL as OWB?

Adrian_Popescu-Oracle Nov 14, 2019 12:40 PM (in response to 1376999)

Yes,

You can see the SQL code generated by ODI.
To do this, you have the option to execute a mapping (ODI 12c)/ interface (ODI 11g) in Simulation mode.
Or you can see the code generated in Operator.

Adrian
Like Show 0 Likes(0)

Actions
2. Re: Does ODI generate SQL as OWB?

1376999 Nov 14, 2019 12:47 PM (in response to Adrian_Popescu-Oracle)

Thanks Adrian,

But what I really want is generate intermediate sql like OWB.
For example, In a mapping (ODI 12c) I have 2 datastore (A and B), 1 join between A and B, 1 filter post-join and finally 1 datastore C for the integration.

I want te see the where in the join, ignoring filter and datastore C.

thanks,
Like Show 0 Likes(0)

Actions
3. Re: Does ODI generate SQL as OWB?

Adrian_Popescu-Oracle Nov 14, 2019 12:51 PM (in response to 1376999)

Hi,

ODI will generate the final SQL, as per the steps included in IKM / LKM.
Adrian
1 person found this helpful
Like Show 1 Likes(1)

Actions
4. Re: Does ODI generate SQL as OWB?

1376999 Nov 14, 2019 12:56 PM (in response to Adrian_Popescu-Oracle)

Thanks!
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.