Preparing the federated server to access data sources through JDBC of Type 1

For JDBC data sources of Type-1 the user must download the JDBC driver.

Before you begin

Ensure that the federated server is able to access JDBC data sources.
Verify the federated parameter to ensure that federation is enabled.

Recommendation:

For the following data sources, use the specialized native wrappers instead of JDBC wrapper:

For Teradata, see Configuring access to Teradata data sources.

This will result in better performance and, in some cases, more functionality.

Restrictions:

The restrictions of the data sources which are optimized are provided below:

Data Source	Restrictions
Amazon Athena^Example	IUD and Transparent IUD are not supported. Method 1 is not supported for NNSTAT. COMMIT and ROLLBACK are not supported. Binay and String are truncated by default when the length is greater than 32672 in both passthru-mode and nickname sessions. For other limitations that apply to all JDBC data sources, see Configuring access to JDBC data sources.
Apache Derby	IUD and Transparent IUD are not supported. Method 1 is not supported for NNSTAT. COMMIT and ROLLBACK are not supported. IUD and Transparent IUD are not supported.
Databricks	Method 1 is not supported for NNSTAT. COMMIT and ROLLBACK are not supported.
Db2® for z/OS®	Db2 for z/OS Decfloat is mapped to Double. Varchar for bit data is mapped to Varbinary. BLOB(`n`) is mapped to Varbinary (`n`) when 1<`n`<32673.
DVM server	DVM Binary(`n`) is mapped to Binary when 1<`n`<256, and mapped to Varbinary(`n`) when 255<`n`<32673. Character(`n`) is mapped to Char when 1<`n`<256, and mapped to Varchar(`n`) when 255<`n`<32673.
IBM PureData® System for Analytics (formerly Netezza®)	IUD and Transparent IUD are not supported. Method 1 is not supported for NNSTAT. COMMIT and ROLLBACK are not supported. For other limitations that apply to all JDBC data sources, see Configuring access to JDBC data sources.
MariaDB	MariaDB Tinyint is mapped to Smallint in Db2. Integer is mapped to Bigint, and Smallint is mapped to Integer. This is because MariaDB unsigned Smallint, Integer, and Bigint are larger than the Db2 maximal value. MariaDB Float is mapped to Double. Decimal(`p`,`s`) is mapped to Double when 32<`p`<65. Bit is mapped to Binary.
MySQL Community Server	MySQL Tinyint is mapped to Smallint in Db2. Integer is mapped to Bigint, and Smallint is mapped to Integer. This is because MySQL unsigned Smallint, Integer, and Bigint are larger than the Db2 maximal value. MySQL Float is mapped to Double. Decimal(`p`,`s`) is mapped to Double when 32<`p`<65. Bit is mapped to Binary.
SAP HANA	HANA Bit is mapped to Boolean. Bit(`n`) is mapped to Varbinary when 261376<`n`<83886080. Nchar is mapped to Graphic, and Nvarchar is mapped to Vargraphic. Smalldecimal is mapped to Decimal, and Decimal(`p`,`s`) is mapped to Double when 31<`n`<38.
Snowflake^Example	Binay, String and Text will be truncated when the length is > 32672 in both passthru-mode and nickname sessions by default; Geospatial type is not supported.
Spark	IUD and Transparent IUD are not supported. Method 1 is not supported for NNSTAT. COMMIT and ROLLBACK are not supported.
Teradata	Some limitations for Teradata JDBC driver to connect. For more information see Using the Teradata JDBC Driver. IUD and Transparent IUD are not supported. Method 1 is not supported for NNSTAT. COMMIT and ROLLBACK are not supported. Binay and String are truncated by default when the length is greater than 32672 in both passthru-mode and nickname sessions.

Procedure

Download the appropriate JDBC drivers from the data source vendors and configure the drivers on the Federation server.
Check the federated parameter to ensure that federation is enabled.