ODI with GIT

ODI 12.2 introduced the use of Subversion as an integrated VCS tool within ODI. To setup GIT access in ODI go to the team menu use ‘Switch Versioning Application’ to select GIT then in the ‘Settings’ create connection Avoid selecting the Auto Version option checkbox. Selecting this feature will commit and push a new version…

ODI Product Management

latest product information at http://my.oracle.com/site/pd/fmw/products/di/odi/index.html   11.1.1.9 12.2.1 What’s New Link Link Certifications Link Link Product Docs Link Link License Docs Link Link Release Notes Link Link Training & Webcasts Link Link Sell ODI-EE with other Oracle products With GoldenGate With SOA Suite With Enterprise Data Quality With BIEE Suite, BI Apps, and Hyperion Apps With…

Install ODI 12c on Non-GUI Platforms

Prerequisites Download Oracle Data Integrator 12.1.3.0.0 installer and save & unzip. If you want to install ODI JEE agent or Collocated Agent then you also need to download Oracle Fusion Middleware Infrastructure. Open a command prompt and go to the directory where you unzipped the jars. JDK 1.7 is required for ODI 12.1.3. to verify run: java -version. Install Invoke…

ODI 12c new flow-based mappings

Oracle Data Integrator 12c introduces several new tools aimed at increasing developer productivity, improving data loading performance, and enabling closer integration with Oracle Fusion Middleware. Probably the most exciting of these new tools, particularly for users of Oracle Database’s Oracle Warehouse Builder feature who are looking to upgrade to Oracle Data Integrator, is the new “flow-based”…

Where to Install Standalone Agent in ODI

ODI is a true ELT tool: no middle-tier server is required. Everything runs in the db, all operations can be run by a lightweight agent. Therefore without a dedicated server, where to install the agent? Source systems are not ideal – they could be dispersed widely… so installing the agent on the target systems appears more appropriate.…

Processing RSS in ODI

We can process RSS using ODI XML technology which has a driver whose file specification includes support for filesystem, URL and ftp. Use a url like below to define an XML dataserver. jdbc:snps:xml?f=http://feeds.bbci.co.uk/news/rss.xml&s=BBC&dtd=d:/bbcrss.dtd When you use the selective reverse engineer you can see the available datastores in the model generated.; To access the URL from within ODI…