✍ Kashif M
Trends

Saturday, 23 September 2017

Kashif
Kashif, September 23, 2017

Step by Step Installation of ODI 11.1.1.9


Below are the steps for Installing ODI (Oracle Data Integrator)

Pre_ Request:
Installed Oracle Data Base 11g
Installed JDK 1.7

Install ODI:
Download ODI11.1.1.9 from the Below link

http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index-100710.html


 
 
Download RCU From the same Link For 11.1.1.9
ExtractThe ZIP files For ODI
Then Start Installing the RCU For the ODI








Navigate C:\ODI_11.1.1.9.0\rcuHome\BIN







Insert the database connection









Then insert password for the schema



Then next







Then next



Here it’s going to Create The Temp Tables for The Work And Master Repo
















Start installing ODI

Navigate to C:\ODI_11.1.1.9.0\ODI11.1.1.9\Disk
Run The EXE with jreLoc







































NO

















Kashif
Kashif, September 23, 2017

Step by Step on creating new report in BI Publisher



Creating new Report in BI Publisher

Create a new report ‘Department_Details’ inside the created folder ‘BI_Publisher_LabGuide’



Click on Edit link mentioned below to create the report


Creating new Data Model

Select Data model à New





Enter the data model name àselect the type as SQL Query

Choose the data source



Write the SQL Query

SQL query can also be generated using SQL Builder which is discussed in the next example.



Save the report



View the report



The output could be viewed only in the data format, as we have not created any template for the report.

Click the view button to view the output. The output generated will be in the form of XML.



You can also edit the report by clicking the Edit link.



After editing, Save the report and view it as we have discussed already.
Viewing the Report in Different formats

Here we can view the above created report in various formats using Template.
Creating Default Template

Select the Layouts, and click the Generate button to create a new RTF template based on the default data model.



A default template (New_Template.rtf) will be generated.









Save the report.

Output is shown below with the generated default template.

The output could be viewed in different formats.
Viewing the output in Default Template

By clicking view one can see the output using default template.







Similarly we can view the report in various formats by selecting the desired output format.





Blog Archive