Product specifications
middleware
(continued)
listing supported 42
MINUS 168
MINUS_ALL 169
MINUS_IN_SUBQUERY 169
MS Access
DISCTINCT 161
MS SQL Server 117
MSOlap CLSID 151
multisource universes 190
N
Native Connectivity service 22
Native Int64 Available 132
network layers
checking connectivity with
middleware 46
listing supported 40
selecting 103
new in the guide 13
O
ODBC
about connections 59
Connection Status Available 146
data types 182
DataDirect drivers 117
Empty String 147
exposing database layer in server
mode 104
generic ODBC2 59
generic ODBC3 61
ODBC Cursors 147
SQLMoreResults Available 148
Use DataDirect OEM Driver 148
ODBC Cursors 147
ODBC drivers 27
OLE DB
data types 185
Enumerator CLSID 150
Provider CLSID 150
openrda.ini file 89
Optimize Execute 133
Oracle
connectivity check example 47
data types 187
Identifier Quote String 131
Include Synonyms 131
LEFT_OUTER 167
Optimize Execute 133
RIGHT_OUTER 172
stored procedures 29
Oracle EBS connections 77
Oracle RAC connections 78
ORDER_BY 170
ORDER_BY_REQUIRES_SELECT
170
ORDER_BY_SUPPORTS_COLUMN_INDEX
170
Owners Available 133
P
Password Encryption 152
PERCENT_RANK_SUPPORTED 171
PrimaryKey Available 144
PRM files
about 155
about function help text 158
editing 157
editing help text 158
structure 156
viewing 157
Provider CLSID 150
PVL Available 144
Q
Qualifiers Available 134
Query TimeOut Available 134
Quote Identifiers 135
Quoted Identifier 153
R
RANK_SUPPORTED 171
reading traces 106
Recover Errors 153
requirements
connections 37
Data Federator minimum version
87
RIGHT_EXT_JOIN 172
RIGHT_OUTER 172
S
salesforce.com connections 78
sample drivers 18
SAP ERP connections 68, 141
data types 178
SAP HANA connections 79
PVL Available 144
SAP MaxDB connections 83
SAP NetWeaver BW connections 84
SAP Queries 69
SAS connections 85
SBO files
configuring a JavaBean connection
using Extensions 58
configuring a JDBC connection
using ClassPath 50
configuring a JDBC connection
using Extensions 52
Connection Check 116
customizing 115, 116
Databases parameters 121
Defaults parameters 121
editing 115
installed 110
structure 121
viewing 115
SEED_SAMPLING_SUPPORTED 173
SELECT_SUPPORTS_NULL 173
server mode 103, 106
Settings 95
Setup File Extension 100
setup files 109
Shared Connection 144
single sign-on 27, 80, 82
SMB 64
SQL External Extension 100
SQL External File 135
SQL Parameter Extension 100
SQL Parameter File 136
SQL Server
GROUP_BY_SUPPORTS_CONSTANT
164
LEFT_OUTER 167
RIGHT_OUTER 172
SQL Server Analysis Services
connections 76
SQLDDL files 66
SQLDescribeParam Available 147
SQLMoreResults Available 148
SSO
configuring for the information
design tool 80
configuring for Web Intelligence 82
configuring for Web Intelligence
Rich Client 82
datasources supported 27
SSO Available 136
stored procedures
about 28
about JavaBean connections 56
creating Oracle 30
limitations 29
Oracle 29
Teradata 31
Strategies Extension 101
Strategies File 137
SUBQUERY_IN_FROM 174
2012-03-15195
Index