Configuring data sources

You can configure the federated server to access relational and nonrelational data sources.

Configuring access to Db2 data sources
To configure a federated server to access Db2® family data sources, you must provide the federated server with information about the data sources and objects that you want to access.
Configuring access to BigSQL data sources
To configure a federated server to access BigSQL data sources, you must provide the federated server with information about the data sources and objects that you want to access.
Configuring ODBC access to Hive data sources
To configure the federated server to access Hive data sources, you must provide the federated server with information about the data sources and objects that you want to access. The ODBC wrapper is optimized to access Hive data sources. The ODBC wrapper detects the ODBC driver and automatically configures the performance options.
Configuring ODBC access to Impala data sources
To configure the federated server to access Impala data sources, you must provide the federated server with information about the data sources and objects that you want to access. The ODBC wrapper is optimized to access Impala data sources. The ODBC wrapper detects the ODBC driver and automatically configures the performance options.
Configuring JDBC access to Spark data sources
To configure the federated server to access Spark data sources, you must provide the federated server with information about the data sources and objects that you want to access. Spark that are accessed through the JDBC API are referred to in this text as Spark data sources.
Configuring ODBC access to PostgreSQL data sources
To configure the federated server to access PostgreSQL data sources, you must provide the federated server with information about the data sources and objects that you want to access. The ODBC wrapper is optimized to access PostgreSQL data sources. The ODBC wrapper detects the ODBC driver and automatically configures the performance options.
Configuring ODBC access to MySQL data sources
To configure the federated server to access MySQL data sources, you must provide the federated server with information about the data sources and objects that you want to access. The ODBC wrapper is optimized to access MySQL data sources. The ODBC wrapper detects the ODBC driver and automatically configures the performance options.
Configuring access to ODBC data sources
To configure the federated server to access ODBC data sources, you must provide the federated server with information about the data sources and objects that you want to access.

Updates to this topic are made in English and are applied to translated versions at a later date. Consequently, the English version of this topic always contains the most recent updates.

See when the translated version of this topic was last updated.
See when the English version of this topic was last updated.