Product specifications
5.3.4 JAR file location reference
The following table describes the names of the folders where you must place middleware JAR files to
enable JDBC connections. The first column lists the database vendor names as shown in the connection
wizard. The second column lists the names of the databases that support JDBC connections, as
described in the DataBase section of the corresponding SBO file. The third column lists the names of
the folders you can create, as described by the Extensions parameter values of the SBO file.
The Extensions parameter is a child element of the DataBase element that corresponds to the
targeted database middleware in SBO files. If it is not under DataBase, it means the parameter value
is valid for all middleware configured in the SBO file. Then refer to the Defaults section of the file.
On MS Windows, JDBC configuration files are located in the connectionserver-install-
dir\connectionServer\jdbc directory.
Note:
The Data Federator JDBC drivers are installed as part of the BI platform in the connectionserver-
install-dir\connectionServer\jdbc\drivers\datafederator directory. The SAP HANA
1.0 SP3 JDBC drivers are installed in the connectionserver-install-dir\connectionServ
er\jdbc\drivers\newdb directory. Consequently, you do not require to perform any additional
configuration to create a connection to either Data Federator XI 3.0 Query Server or SAP HANA
database.
Extensions parameter valuesDatabaseVendor
derby10, derby, jdbcDerby 10 Embedded
Apache
apache, hive, jdbcApache Hadoop HIVE
postgresql8, postgresql, jdbc
GreenPlum 3, GreenPlum4, Post-
greSQL 8
Greenplum
neoview, jdbcHP NeoviewHewlett Packard
hsqldb18, hsqldb, jdbcHSQLDB 1.8 EmbeddedHSQLDB
db2v8, db2udb, db2, jdbcDB2 UDB v8
IBM db2v9, db2udb, db2, jdbcDB2 v9
ids11, informix, jdbcInformix Dynamic Server 11
2012-03-1553
Creating a connection