Introduction Oracle data integrator is a next-generation ETL tool in the market. A widely used data integration software product, Oracle Data Integrator provides a new declarative design approach to defining data transformation and integration processes, resulting in faster and simpler development and maintenance. Based on a unique E-LT architecture (Extract - Load Transform), Oracle Data Integrator not only guarantees the highest level of performance possible for the execution of data transformation and validation processes but is also the most cost-effective solution available today. I write this post as a part of research about ODI 12.2.1 features. But steps are simillar with all ODI 12c versions. ODI 12.2.1 New features. Big Data investments include Spark Streaming support.
New Flatten and Jagged Components. Support for Cube and Dimensions. New Model and Topology Objects Wizard. Orchestration of Oracle Data Integrator Jobs using Oozie. Oracle Data Integrator Console Enhancements. Enhanced Big Data Support. Enhanced Hive Driver and Knowledge Modules.
New/Update Hive Components Style Knowledge Modules. Ability to View the List of Users Connected to the Studio/Repository. Complex File Enhancements. Complex File, File, LDAP, JMS Queue XML, JMS Topic XML, and XML Technology Enhancements.
Microsoft Excel as a Source and Target as Oracle in ODI 11.1.1.6. Main menu Skip to primary content Skip to secondary. Microsoft Excel as a Source and Target as Oracle in ODI 11.1.1.6. 2008, 64 bit, the 64 bit excel/access odbc driver will not be available for you. You can only see the default odbc driver location as “C: WINDOWS. Feb 12, 2017 - Data Integrator installation folder (ODI_Home oracledi drivers) if they are not already referenced in the Java classpath. Oracle Data Integrator.
%ORACLEHOME/odi/studio/bin directory Open the odi.conf file using any text editor. Add a line at the bottom of the file specifying the location of a certified JDK. For 12c (12.2.1.2.6), the certified JDK is 1.8.0101 and later. For example: set JAVAHOME=C: home Oracle Java jdk1.8.0101 Save the file. Starting ODI using odi.exe (odi.sh for UNIX).
Create new connection to the master repository File – New – Create a new ODI Repository Login Enter credentials for master repository which we define in RCU configuration Connect to master repository Click 'Ok' to connect master repository Create Java EE Agent for ODI Open folder C: Oracle Middleware OracleHome oraclecommon common bin Open Config.cmd file with administrator privileges Select Create a new domain option to create a new domain. If you want to change existing domain select update an existing domain option and browse. Start Admin Server, Node Manager and ODI agent. Open folder%ORACLEHOME%/userprojects/domains/odidomain/bin.
You can see bat files which file name start with start prefix Run below files to below order as administrator Now you can open web logic console and server EM. Weblogc Console URL:. Enterprice Manager URL: Preparing console to start work Weblogic console login page. Enter your weblogic username and password to logging as a weblogic administrator. Weblogic console main interface Enterprise Manager main interface Start ODI Agent i. Open ODI studio and go to topology tap. Right-click agent in Physical Architecture and select new agent in the pop-up menu.
This is a new agent interface. Define agent name as an OracleDIAgent1 (Defined in domain creating process.), host.
(Port should be same to port which we define in domain creating process) and save. Create logical agent using logical architecture tab Start Agent Service. Go to location using CMD%ORACLEHOME%/userprojects/domains/odidomain/bin Run below command agent.cmd –NAME=OracleDIAgent1 Agent Started Test agent. Open agent in studio Enter below URL in browser and go If your agent working correctly, You can see below message in your browser Note: If you are using the default Java EE agent, the agent name in ODI Studio must be 'OracleDIAgent'.