Connect to a Remote Trino Data Source

In Oracle Analytics, you can connect to a remote Trino data source.

Oracle Analytics requires that remote connectivity is enabled and that Data Gateway is installed on the system hosting your Trino web server. In addition, Data Gateway must be configured with a Trino driver. See Configure Remote Data Connectivity for a Trino Data Source.

Note: The Use Remote Data Connectivity option is selected by default and greyed out because you can only use this connection type with remote data sources.

1. On the Oracle Analytics Home page, click Create, and then click Connection.
2. Click Trino.
3. In Connection Name, enter a user-friendly display name.
4. Provide connection details.
   • For Host, copy in the hostname for your Trino web server. For example,

     http://example.net/.

   • For Port, copy in the port number for your Trino web server. For example, 8080 (for HTTP) or 443 (for HTTPS).
   • For Catalog and Schema, optionally specify the Trino catalog and schema (for example, hive and sales). If you omit these values, you can navigate to a specific data area when you create a dataset in Oracle Analytics.
5. In Authentication Type, select No Authentication or Ldap , depending on your requirements.
   • No Authentication - Connect to Trino insecurely without security verification.
   • Ldap - Connect securely using Lightweight directory access protocol (LDAP).

     For Username and Password, enter user credentials with access to the Trino data source.

     For SSL Verification, specify one of these values:

     FULL - The standard TLS verification is performed.

     CA - Only the CA (Certificate Authority) is verified but hostname mismatch is allowed.

     NONE - No verification is performed.

6. Click Save.