KPI Partners Blog
What is Snapshot data?
Snapshot data is a copy of business data preserved at some point-in-time. In some cases we may not be able to recover older snapshot data from the current data sets because we need to preserve snapshots at regular (scheduled) intervals for historical analysis.
Tags: Data Warehousing, Financial Analytics, Oracle E-Business Suite, Prabu Varatharaju, Informatica, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
A key component to any Business Intelligence (BI) Architecture is the Extract, Translate and Load (ETL) process. The ETL process is typically scheduled on a daily basis and is capable of data movement from legacy systems into a data warehouse. It is also used to facilitate the work of the database administrators who connect different branches of databases as well as integrate or change the existing databases.
Knowledge Modules (KM), components of Oracle Data Integrator’s Open Connector Technology, are generic, highly specific and reusable code templates which defines the overall data integration process. Each Knowledge Module contains the knowledge required by ODI to perform a specific set of actions or tasks against a specific technology or set of technologies, such as connecting to this technology, extracting data from it, transforming the data, checking it, integrating it, etc.
The Oracle Data Integrator platform integrates into the broader Fusion Middleware platform and becomes a key component of this stack. Oracle Data Integrator provides it's run-time components as Java EE applications, enhanced to fully leverage the capabilities of the Oracle WebLogic Application Server. Oracle Data Integrator components include the FMW exclusive features for Enterprise-Scale Deployments, high availability, scalability, and hardened security.
The new release of the Oracle BI Applications (18.104.22.168.1) now leverages Oracle Data Integrator (ODI). This huge development means that ODI can alternatively be utilized as the primary data integration tool over Informatica. ODI and its Extract-Load-Transform functionality could provide customers a setup that delivers increased performance and reduced data integration costs.
Tags: Student Information Analytics, Webinar, JD Edwards, OBIEE, Vikas Agrawal, DAC, Oracle, Informatica, Business Intelligence, Video, Jeremiah Johnson, Events, Oracle BI, Oracle BI Applications, Exalytics, Examining OBIA 11g, Oracle Data Integrator (ODI), Hari Cherukupally, GoldenGate, Indirect Spend Planning, Blog
Oracle Data Integrator (ODI): Executing A Load Plan
A Load Plan is an executable object in Oracle Data Integrator that can contain a hierarchy of steps that can be executed conditionally, in parallel or in series. Procedures, interfaces, packages, variables, and can be added to Load Plans for executions in the form of scenarios in a Load Plan.
As part of KPI's web series on Examining Oracle BI Applications 11g, this short video provides a brief overview of the new release of the Oracle BI Applications. Areas of examination for this session include:
Tags: Student Information Analytics, OBIEE, Financial Analytics, Peoplesoft Campus Solutions, Ramesh Ponganti, Project Analytics, Rushendra Prasad, Jeremy Simmons, Srinivasan T, Sharath V, Vlad Valeyev, Prabu Varathaju, Informatica, Video, Myles Gilsenan, Jeremiah Johnson, HR Analytics, Oracle BI Applications, Procurement & Spend Analytics, Examining OBIA 11g, John Whitaker, Oracle Data Integrator (ODI), Fixed Asset Analytics, Indirect Spend Planning, Oracle GoldenGate, Supply Chain and Order Management, Blog