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
See also sources
defining SAP objects, 7.6.3
E-Business Suite, 8.1
flat files, 3.3
Oracle Designer, 10.1
PeopleSoft, 8.2
Siebel, 8.3
Database Link, 2.4.1
databases
importing definitions from, 2.4
DB Connectors
about, 2.2.2
DB2, 4, 8.4
connecting to, 6.2
JDBC connection, 6.2
defining
Business Intelligence objects, 9
ETL process for SAP objects, 7.8
flat files, 3
updating source definitions, 2.5.2
definitions
importing definitions from a database, 2.4
deploying
business definitions, 9.3
deriving
business intelligence objects, 9.8
Designer, 10.1, 10.1
drill paths
creating, 9.1.7, 9.5.5
editing, 9.1.8, 9.5.6
drills to detail
creating, 9.1.13
editing, 9.1.14
driver
JDBC driver for SQL, 6.3

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
See also flat files

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
See also external tables

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
loading
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
See also external tables
targets
flat files, 3.1.5
teradata, 11.5
Text String Matching, 8.1.1.4, 8.2.1.3
transparent tables, 7.3.1

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