Product specifications

Driver capabilities...................................................................................................................63
6.1.1
File location............................................................................................................................64
6.1.2
Table mapping........................................................................................................................65
6.1.3
Schema detection..................................................................................................................66
6.1.4
SAP ERP connections............................................................................................................68
6.2
Driver capabilities...................................................................................................................68
6.2.1
Access to InfoSets and SAP Queries.....................................................................................69
6.2.2
Access to ABAP functions.....................................................................................................71
6.2.3
ERP limitations.......................................................................................................................73
6.2.4
Connection reference...........................................................................................................75Chapter 7
Apache Hadoop HIVE connections.........................................................................................75
7.1
IBM DB2 connections............................................................................................................76
7.2
MS Analysis Services connections........................................................................................76
7.3
Oracle EBS connections........................................................................................................77
7.4
Oracle Essbase connections..................................................................................................77
7.5
Oracle RAC connections........................................................................................................78
7.6
salesforce.com connections...................................................................................................78
7.7
SAP HANA connections........................................................................................................79
7.8
Creating a connection............................................................................................................79
7.8.1
Before configuring single sign-on...........................................................................................80
7.8.2
To configure single sign-on for the information design tool.....................................................80
7.8.3
To configure single sign-on for Web Intelligence.....................................................................81
7.8.4
To configure single sign-on for Web Intelligence Rich Client...................................................82
7.8.5
To configure the Java Virtual Machine for instrumentation.....................................................83
7.8.6
SAP MaxDB connections.......................................................................................................83
7.9
SAP NetWeaver BW connections..........................................................................................84
7.10
Requirements for connecting Data Federator to SAP NetWeaver BW...................................84
7.10.1
SAS connections...................................................................................................................85
7.11
Installing drivers for SAS connections....................................................................................85
7.11.1
Creating a connection to Data Federator XI 3.0 Query Server.............................................87Chapter 8
About Data Federator XI 3.0 Query Server connections.........................................................87
8.1
Configuring the connection wizard for a Data Federator JDBC or ODBC connection.............88
8.2
Configuring Data Federator ODBC connections.....................................................................88
8.3
Configuring the Data Federator ODBC middleware ...............................................................89
8.3.1
Configuring Connection Server for a Data Federator ODBC connection................................89
8.3.2
Configuring Web Intelligence Rich Client connections using Data Federator ODBC
middleware.............................................................................................................................90
8.4
Configuring the Data Federator ODBC middleware for a connection to Web Intelligence Rich
Client.....................................................................................................................................91
8.4.1
2012-03-155
Contents