You can create a data provider by manually entering the SQL for a target data source. You can specify the source tables, columns, and functions used to acquire data.
.
|
Supported database middleware |
How to obtain the driver |
|---|---|
|
Apache |
Amazon EMR and Apache Hive Simba drivers are included with SAP Lumira. |
|
Cloudera |
The Cloudera Impala Simba driver is included with SAP Lumira. |
|
IBM DB2 |
Go to the IBM DB2 connectivity download page at https://www.ibm.com/account/profile/us?page=reghelpdesk Before you can download a driver, you must register using a free IBM-recognized user email address as the account name. If you do not know which version of the driver to use, both drivers for DB2 version 10.1 [DB2 version 10.1 FP0 (GA) and version 10] are suitable for all versions later than DB2 version 9.5. For more information, contact your database administrator. |
|
IBM Netezza |
See your Netezza administrator. |
|
Microsoft SQL Server |
Go to the SQL Server 2005, 2008, and 2012 Microsoft Drivers
download center page at http://www.microsoft.com/en-us/download/driver.aspx?q=driver If you don't know which version of the driver to use, Microsoft JDBC Driver 4.0 for SQL Server is suitable for all supported SQL server versions. If you are installing JDBC Driver 4.0 for SQL Server, the driver is sqljdbc_4.0.2206.100_enu.exe for a Windows operating system. The sqljdbc4.jar driver file is extracted to \sqljdbc_4.0\enu\, in the specified extraction folder. |
|
Oracle |
Go to the Oracle JDBC Driver Downloads page at http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html Before you can download a driver, you must create a free user account. If you don't know which version of the driver to use, ojdbc14.jar is suitable for any supported version of Oracle 10 and 11. |
|
Sybase |
The Sybase driver (jconn4.jar) is installed by default; you do not need to install it. It is located at \\<InstallDir>\Program Files\SAP Lumira\Desktop\plugins\com.businessobjects.connectionserver.standalone_3.1.3.v20120603-0404\ConnectionServer\jdbc\drivers\IQ15. |
|
Teradata |
Go to the Teradata connectivity download page at http://downloads.teradata.com/download/connectivity/jdbc-driver Before you can download a driver, you must create a free user account. If you don't know which version of the driver to use, the Teradata JDBC Driver 14 is suitable for all supported Teradata versions. For Windows, use TeraJDBC__indep_indep.14.00.00.14.zip. Once extracted, the driver files are tdgssconfig.jar and terajdbc4.jar. |
|
Database middleware |
JDBC driver available |
|---|---|
|
Oracle |
ojdbc14.jar |
|
Microsoft SQL Server |
sqljdbc4.jar |
|
Teradata |
terajdbc4.jar and tdgssconfig.jar |
|
Sybase |
jconn4.jar |
|
IBM DB2 |
db2jcc.jar or db2cc.jar and db2jcc_license_cu.jar for versions earlier than 9.5 |
|
IBM Netezza |
nzjdbc.jar |