Index

A B C D E F G H I J L M N O P R S T U W

A

alternative sort orders

creating, 9.1.11

editing, 9.1.12

B

business areas

creating, 9.1.5, 9.5.7

editing, 9.1.6, 9.5.8

business definitions

deploying, 9.3

Business Domain, 8.1.1.4, 8.2.1.3

business domains

SAP, 7.3.2

business intelligence objects

deploying, 9.3

Business Intelligence objects

defining, 9

deriving, 9.8

C

CMI, 11.2.6, 11.4

COBOL, 2.5.2

code templates

about, 12.1

coding conventions, Preface

configuring

runtime parameters, SAP files, 7.8.1.3

SAP, loading type parameter, 7.8.1.2

connectivity

ODBC, 1.3.4

OLE DB drivers for heterogeneous data sources, 1.3.4

connectivity agent, 1.3

connectors

creating, database connector, 2.2.2

creating, directory connector, 2.2.2

Connectors

about, 2.2.2

containers

Oracle Designer Repository, 10.1

SAP application, 7.6.3

control center agent

start, 12.2.5.2.1

conventions

coding, Preface

example, Preface

Create External Table Wizard, 3.6.1

Create Flat File Wizard, 3.2

creating

alternative sort orders, 9.1.11

business areas, 9.1.5, 9.5.7

drill paths, 9.1.7, 9.5.5

drills to detail, 9.1.13

item folders, 9.1.4, 9.5.4

list of values, 9.1.9

locations, 2.2.1.1

Oracle Designer 10g source modules, 10.1.1

Oracle Discoverer module, 9.1.1

registered functions, 9.1.15

Custom Metadata Import, 11.4

Custom Metadata Interface, 11.2.6

D

data definitions, importing, 10

data sources, 10

E

E-Business Suite

importing metadata, 8.1

editing

alternative sort orders, 9.1.12

business areas, 9.1.6, 9.5.8

drill paths, 9.1.8, 9.5.6

drills to detail, 9.1.14

item folders, 9.1.3, 9.5.3

list of values, 9.1.10

registered functions, 9.1.16

example conventions, Preface

Excel files

loading data from, 5

Execution Units, 12.2.5.5

External Table editor, 3.6.3

external tables

configuring, 3.6.5

creating a new definition, 3.6.1

defined, 3.1.4.2, 3.6

editor, 3.6.3

synchronizing definition, 3.6.4

wizard for creating, 3.6.1

F

files, defining, 3

flat file modules, creating, 3.1.6

flat files

creating new, 3.2

defining, 3

describing, 3.2.1

as sources, 3.1.4

as targets, 3.1.5

G

Gateway, 1.3

Gateways, 1.3

Connecting Through, 1.3.1

DRDA, 4

Informix, 4

SQL Server, 4

Sybase, 4

Teradata, 4

H

HOST

PORT

SERVICE, 2.4.1

I

importing

data definitions, 10

definitions, database systems, 2.4

flat files, 3.3

from E-Business Suite, 8.1

from flat files, 3.3

from PeopleSoft, 8.2

from SAP R/3, 7.6

from Siebel, 8.3

Import Metadata Wizard, 2.4

Oracle database metadata, 2.4

informix, 11.5

Informix, 8.4

item folders

about, 9.1.2

creating, 9.1.4, 9.5.4

editing, 9.1.3, 9.5.3

synchronizing, 9.1.4.8, 9.5.4.8

J

JDBC, 1.3.2

connection, 6.2

driver for DB2, 6.2

driver for SQL, 6.3

jdbc connection

informix, 11.5

mySQL, 11.5

sybase, 11.5

teradata, 11.5

JDBC connectivity, 2.5.2

L

language, SAP, 7.8.1.3

list of values

creating, 9.1.9

editing, 9.1.10

data from Excel files, 5

flat files, 3.2.4.1

loading types

for SAP, 7.8.1.2

locations

creating, 2.2.1.1

deleting, 2.2.1.4

registering, 2.2.1.3

unregistering, 2.2.1.3

M

metadata

Import Metadata Wizard, 2.4

importing from databases, 2.4

importing from flat files, 3.3

Microsoft Excel

loading data from, 5

modules

defining SAP objects, 7.6.3

SAP application, 7.6.3

mySQL, 11.5

N

non-Oracle database systems

as data sources, 1.3

O

OBIEE, 9

OCI, 2.4.1, 2.4.1

ODBC, 1.3.4

ODBC for heterogeneous data sources, 1.3.4

OLE DB drivers for heterogeneous data sources, 1.3.4

Oracle Business Intelligence Enterprise Edition, 9

Oracle Call Interface, 2.4.1

Oracle Designer, 10, 10.1

Application Systems, 10.1

source module, 10.1

workareas, 10.1

Oracle Discoverer, 9

Oracle Discoverer module, 9.1.1

Oracle E-Business Suite, 2.5.2

Oracle Gateways, 1.3, 2.5.2

P

PeopleSoft, 2.5.2, 8.4

importing metadata, 8.2

pooled tables, 7.3.1

R

registered functions

creating, 9.1.15

editing, 9.1.16

remote function call, 7.6.3

remote function call (RFC)

RFC connection, 7.6.3.1

SAP RFC connection, 7.6.3.1

RFC, 7.6.3

runtime, SAP, 7.8.1.3

S

SAP

Business Domain, 8.1.1.4, 8.2.1.3

defining ETL process for SAP objects, 7.8

defining SAP objects, 7.6.3

remote function call, 7.6.3

SAP application source module, 7.6.3

SAP business domains, 7.3.2

SAP Connector

creating definitions, 7.6.3

SAP file physical properties

Data File Name, 7.8.1.3

File Delimiter for Staging File, 7.8.1.3

SAP System Version, 7.8.1.3

SQL Join Collapsing, 7.8.1.3

Staging File Directory, 7.8.1.3

SAP parameters

language, 7.8.1.3

loading type, 7.8.1.2

runtime, 7.8.1.3

SAP R/3

importing metadata, 7.6

SAP table types

cluster, 7.3.1

importing, 7.3.1

pooled, 7.3.1

transparent, 7.3.1

SAPRFC.INI, 7.6.3

SAPRFC.INI file, 7.6.3.1, 7.6.3.1

Setting the Language Parameter, 7.8.1.3

Setting the Runtime Parameter, 7.8.1.3

Siebel, 2.5.2, 8.4

importing metadata, 8.3

SOAP, 13.1

source modules, 10

importing definitions, 2.4

Oracle Designer 10g, 10.1.1

Oracle Designer Repository, 10.1

SAP application, 7.6.3

sources

data sources, 10

flat files, 3.1.4

updating source definitions, 2.5.2

SQL Server, 8.4

connecting to, 6.3

SQL*Loader properties, 3.2.4.1

SQL*NET Connection, 2.4.1

sybase, 11.5

Sybase, 8.4

synchronizing

item folders, 9.1.4.8, 9.5.4.8

T

tables

U

updating

source definitions, 2.5.2

W

web services

WSDL, 13.1

wizards

Create External Table Wizard, 3.6.1

Create Flat File Wizard, 3.2

Import Metadata Wizard, 2.4

workareas, Designer 10g, 10.1