Category: BICC

Why use DataStage?

ETL Datastage

Datastage is an ETL tool which extracts, transform and load data from source to the target. The data sources might include sequential files, indexed files, relational databases, external data sources, archives, enterprise applications, etc. The reasons for using DataStage • DataStage Module helps in reducing the workload and business rules management. It optimizes hardware utilization and control job activities • It provides user interaction with administrative projects. It also keeps interaction with systems and can manage global settings. The administrator’s responsibility varies from setting up projects, properties, adding, deleting and moving projects. A command interface is given to DataStage Repository administrators. • DataStage repository can be viewed and edited, the main interface of DataStage repository is DataStage Manager. To search or Store DataStage repository and manage to reuse Metadata, the Manager loads all the services. It plays an important role in organizing all tasks to the DataStage Repository. • It helps in creating jobs on DataStage or app by giving the design interface. Each job from outside view specifies the instinct of data, possible transformations, and the target as well. The designer will also provide user graphical interface which is easy. The server will take care of loading the executable […]

Read More +

Creating BICC extracts from Oracle Fusion Application Products for data extraction

To extract data from a Fusion Applications Cloud data source, you use the BI Cloud Connector (BICC) Console to schedule a once-only or regular data load, known as a Cloud Extract.BI Cloud Connector provides the option to extract Fusion Data to both Universal Content Management (UCM) and Cloud Storage Service. • Within BICC the public view object(PVO) is associated with the Oracle BI Applications (OBIA) offering. Each offering (Finance, HCM, SCM, etc.) contains multiple seeded PVOs. Each PVO within an offering extracts data from a group of tables. • For example, if you select HCM offering for the extract, it includes a view object named ‘oracle.apps.hcm.action.publicView.analytics.ActionReasonsPVO’ as one of its PVOs. This view object extracts data from tables PER_ACTION_REASONS_TL and PER_ACTION_REASONS_B. • The other PVOs seeded within Oracle HCM offering will extract data from a different group of tables. • To add more data sources to seeded PVOs, you can use Cloud Extract Configuration and Extraction UI. There are two options when adding a data store; Fact Group or Dimension Group. • Once the extract has been configured, you need to schedule using the ‘Manage Extract Schedules’ option. • The file created by the Fusion BI Cloud Connector tool can […]

Read More +