Acquiring data using Query with SQL

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.

For a complete list of database middleware that Query with SQL can access, see the SAP Product Availability MatrixInformation published on SAP site.
Table 1: Supported database middleware drivers

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=reghelpdeskInformation published on non-SAP site. Choose the appropriate driver for your database, save the compressed installation file to your computer, extract the compressed file (db2jcc.jar) to a local directory, and run the installer from your computer. For versions earlier than 9.5, you must extract db2cc.jar and db2jcc_license_cu.jar instead.

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=driverInformation published on non-SAP site. Choose the appropriate driver for your database, save the installation file to your computer, and run the installer from your computer.

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.htmlInformation published on non-SAP site

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-driverInformation published on non-SAP site. Choose the appropriate driver for your database, save the compressed installation file to your computer, extract the compressed file to a local directory, and run the installer from your computer.

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.

Table 2: JDBC drivers for typical database middleware

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