Learn to work with Cubes and Dimensions, a new feature in Oracle Data Integrator 18.104.22.168.0
This tutorial covers how to exchange custom objects within the ODI community via the Update Center. You can optionally add your own work to the library and download other people's contributions.
This tutorial covers how to make ODI mappings with Big Data using Apache™ Hadoop®, Hive™, Pig, and Spark™.
This tutorial covers how to use complex ASCII files as data stores, and how to invoke web services to and from ODI packages.
This tutorial shows you how to install and configure Oracle Data Integrator (ODI) 12c (12.1.3) by updating a WebLogic Server (WLS) domain on an existing Oracle Java Cloud Services (JCS) Virtual Image domain.
The topology of the domain you create can vary, depending upon how many virtual machines and how many Managed Servers you provision as part of your Java Cloud Service Virtual Image subscription. For the purposes of this tutorial, it is assumed that you have created a domain that contains an Administration Server and one Managed Server on the same JCS Virtual Image instance. Your actual topology may vary.
This tutorial covers install and configuration of Oracle Data Integration (ODI) 12.1.3 from command line ("silent" install via text response file) on platforms where Graphical User Interface (GUI) is not available.
This demo illustrates how you can move and transform all your data using Oracle Data Integration - whether that data resides in Oracle Database, Hadoop, third-party databases, applications, files, or a combination of these sources. The "Design once, run anywhere" paradigm allows you to focus on the logical rules of data transformation and movement while the choice of implementation is separate and can evolve as use cases change and new technologies become available.
The demo highlights Oracle Data Integrator and Oracle GoldenGate integrating with Oracle Loader for Hadoop, Oracle Big Data SQL, Hive, Sqoop, Flume, Pig, HDFS.
In this tutorial, you will create the sample database users and tables, configure Oracle GoldenGate (OGG) manager and agents, configure Oracle Data Integrator (ODI) data servers, models, datastores, maps, agents, and packages, and then start/stop/control the integration processes. There will be both OGG replication (capture and delivery) and ODI replication (Change Data Capture via Journaling). The OGG will run near-real-time, the ODI will run in micro-batches of one row of changed data polling once/second.
This self study course introduces the new features in version 12.1.3, such as FIPS AES encryption, Big Data support, and JSON support.
This video is a subset of the larger "Oracle Data Integrator (ODI) Interactive Upgrade Guide" ecourse, https://apex.oracle.com/pls/apex/f?p=44785:24:0::::P24_CONTENT_ID,P24_PREV_PAGE:9797,1 . This demonstrates the FMW Upgrade Assistant upgrading ODI version 22.214.171.124 to ODI version 126.96.36.199 Master and Work Repositories, as well as Repository Creation Utility (RCU) upgrade. This presumes no WLS installed.
This Interactive Upgrade Guide lets you explore the options of upgrading from various earlier versions of ODI to later versions such as 12c. It includes videos of a live upgrade, and pointers to other documents, training, and web sites.
This is the third in a series of four OLL Live recorded webcasts in the Oracle Data Integrator 12c: Getting Started series. A common task that is performed using ODI is to set up and install an ODI Agent. After the ODI scenarios are created, they can be scheduled and orchestrated using an ODI Agent, which is a lightweight Java process that orchestrates the execution of ODI scenarios. This tutorial walks you through the steps that are needed to set up and install the ODI Agent. This webcast walks you through the steps that are needed to use Oracle Data Integrator Studio (ODI Studio) graphical tools to create an agent collocated with WLS to support (among other things) scheduling of procedures.
This is the second in a series of four OLL Live recorded webcasts in the Oracle Data Integrator 12c: Getting Started series. There are many ways to get a flat file of data into an Oracle Database. For example, SQL*Loader is one of the proprietary tools included in many versions of Oracle Database. The problem is that other versions of other databases (such as IBM DB2, or Microsoft SQL Server) use different proprietary tools. ODI provids one standard way of importing files into many different databases. Furthermore, SQL*Loader is designed to take the data in unmodified, whereas ODI is designed to transform the data while it is being loaded. This webcast walks you through the steps that are needed to use Oracle Data Integrator Studio (ODI Studio) graphical tools to export an ASCII flat file of columnar data to an Oracle Database 12c relational table.
This is the first in a series of four recorded webcasts in the Oracle Data Integrator 12c: Getting Started series. Repositories are schemas and tables in a database that hold information about ODI Designs, Topologies, and Security. There is a one-to-many relationship between Master and Work repositories. The repository schemas and tables can be created either manually using ODI Studio or automatically using Repository Creation Utility (RCU). RCU is the preferred method of maintaining the repositories. The database storing the repository can be Oracle Database 12c or several other supported databases. This recording will walk you through the steps that are needed to create and connect to the Oracle Data Integrator (ODI) Master Repository and the ODI Work Repository using Repository Creation Utility (RCU) and ODI Studio.