Creating a federation connector

Learn how you can create a federation connector that can be used by a Trino Virtual Warehouse to query and access data from different data sources.

You must create a Trino Virtual Warehouse.
You must register a secret for your Environment.

Log in to the Cloudera Data Warehouse service and click Federation Connectors.
The Federation Connectors page is displayed that lists all the currently configured connectors.
In the Data Source Type page, select the type of data source that you want to configure and then click Next.
You can choose between a Cloudera Certified connector or a Community connector.
In the Configuration Details page, enter the following information:
1. Provide a catalog name and description for the connector.
2. Select the appropriate environment.
3. Under the Configuration pane, enter the following key-value pairs:
  - Connector name
  - Connector URL to connect to the required data source. For example, jdbc:postgresql://example.net:3306/postgres
  - Connection user name
  - Connection password - Choose a registered secret from the environment selected above.
  tip
  You can choose to enter the catalog configuration details either as key-value pairs, properties, or as a JSON format.
4. For the Oracle connector, you can use Kerberos authentication instead of a connection user name and password. To enable Kerberos authentication, add the following properties in the Configuration pane:
```
oracle.authentication.type=KERBEROS
kerberos.client.principal=<principal>
kerberos.client.keytab=<path-to-keytab>
kerberos.config=<path-to-krb5.conf>
```
  - oracle.authentication.type specifies the authentication method. Set it to KERBEROS.
  - kerberos.client.principal specifies the Kerberos principal that connects to the Oracle database.
  - kerberos.client.keytab specifies the path to the keytab file for the principal.
  - kerberos.config specifies the path to the Kerberos configuration file.
5. Click Test Connection to verify if the configurations are correct to establish a successful connection to the data source.
  A message is displayed indicating if the connection is successful or not. If the connection fails, modify the configuration details and try again.
If the connection is successful, click Connect To Datasource to establish a connection to the data source.

The connector is created successfully and is listed in the Federation Connectors page.

If you configured the connector to use Kerberos authentication, configure krb5.conf with the connector's realm and KDC details on both the coordinator and the worker of the Trino Virtual Warehouse before you attach the connector, unless this configuration is already present. See Kerberos realm configuration for Trino Virtual Warehouses.