PowerExchange for Oracle E-Business
PowerExchange for Oracle E-Business Suite integrates PowerCenter with Oracle E-Business Suite to extract data from Oracle E-Business Suite applications and write data to Oracle E-Business Suite applications. Oracle E-Business Suite sources represent tables, views, or flexfields in an Oracle application.
Oracle E-Business Suite consists of business applications to help manage components of an enterprise. Oracle E-Business Suite includes applications for supply chain management, human resource management, and financials.
You can use PowerExchange for Oracle E-Business Suite to read data from Oracle E-Business Suite in the following situations:
* Synchronize data with other applications. Sometimes, to enable smoother flow of operations, data generated or captured in an E-Business suite application must be synchronized with other applications in the IT environment. For example, to provide better post sales support, it would help to synchronize data in an E-Business suite application with data in a custom application built for performing post sales operation. PowerExchange for Oracle E-Business Suite enables you to read data from the E-Business suite application, which can then be written to the custom application.
* Collect data for analysis and reporting. For example, your organization wants to include data from the Oracle E-Business Suite financial application to report on quarterly profits. Use PowerExchange for Oracle E-Business Suite to read data from the financial application and write it to the data warehouse for the reporting tool.
You can use PowerExchange for Oracle E-Business Suite to write data to Oracle E-Business Suite in the following situation:
* Migrate data to Oracle E-Business Suite. For example, your organization uses an ERP system for human resource management. You want to migrate to Oracle E-Business Suite human resource management applications. Leverage the connectivity provided by PowerCenter to extract data from legacy systems and use PowerExchange for Oracle E-Business Suite to write data to the Oracle E-Business Suite human resource management application.
PowerCenter Integration with Oracle E-Business Suite: PowerExchange for Oracle E-Business Suite integrates Oracle E-Business Suite with the Designer and the PowerCenter Integration Service. Import Oracle E-Business Suite metadata into PowerCenter and use it in mappings. You can run sessions that extract, transform, and load Oracle E-Business Suite data.
Designer and Oracle E-Business Suite Integration: PowerExchange for Oracle E-Business Suite connects the Designer to the database tier of Oracle E-Business Suite using ODBC drivers. You can import tables, views, and flexfields from the Oracle database tier as source definitions.
You can import open interface tables as target definitions. When you import a target definition, the Designer connects to the database tier.
PowerCenter Integration Service and Oracle E-Business Suite Integration: The PowerCenter Integration Service uses ODBC to connect to the Oracle E-Business Suite. It connects to the database tier of Oracle E-Business Suite to read source data and write target data.
The batch identifier is a unique value assigned to each row of data. Open interfaces that require a batch identifier contain a batch identifier column in the open interface table. A batch identifier can be in several forms, such as Batch_ID, Batch_name, and Group ID. For example, General Ledger Journal Entry uses the column JE_BATCH_ID. The form of the batch identifier in the open interface is the form of the batch identifier in the target definition.
PowerCenter Integration Service and Oracle E-Business Suite Integration ( sample foto här )
Oracle E-Business Suite addresses business-to-business (B2B) and business-to-consumer (B2C) sales, marketing, analysis, and service needs through the Internet. Oracle E-Business Suite consists of front-office Customer Relationship Management (CRM) applications and back-office Enterprise Resource Planning (ERP) applications. These applications automate marketing, sales, contracts, service, manufacturing, and supply chain processes.
Oracle E-Business Suite has a three-tier architecture. It includes the * desktop tier, * application tier, * and database tier.
A tier is a logical grouping of services that can be spread across more than one physical machine. The desktop tier provides the user interface through an add-on component to a standard Web browser. The application tier supports and manages various application components. It hosts servers that process the business logic. It also manages communication between the desktop tier and the database tier. The database tier supports and manages the Oracle database.
PowerExchange for Oracle E-Business Suite interacts with the database tier to extract metadata and data. When the PowerExchange for Oracle E-Business Suite loads data to Oracle E-Business Suite, it interacts with the database tier and the Concurrent Processing Server component of the application tier. Your comment are always welcome here, any question will be glad to answer.
MCTS & MCITP