Configure Remote Data Connectivity for a Trino Data Source

In Oracle Analytics, you can connect to a remote Trino data source using Data Gateway. Before workbook creators connect to the Trino data source, you must configure your Data Gateway installation to support Trino.

You supply your own driver for Trino connectivity. Oracle doesn't manage the license or usage compliance for Trino drivers. Make sure that you fully test data sources and database features before deployment to production.

Oracle Analytics requires that remote connectivity is enabled and that Data Gateway is installed on the system hosting your Trino web server. See Connect to On-premises Data Sources Using Data Gateway.

1. Download Version 352 of the Trino JDBC driver from the Maven central repository (in the Trino JDBC area repo1.maven.org/maven2/io/trino/trino-jdbc/).
   Note: Trino JDBC driver versions higher than 352 are compiled with JDK 11 and don't work with Data Gateway.
2. In each Data Gateway installation that you have, navigate to the \<Data Gateway installation>\ folder and copy in the JAR file.
   • In a server deployment, copy the JAR file into: <Data Gateway install_location>/domain/jettybase/thirdpartyDrivers
   • In a personal deployment on Windows, copy the JAR file into: <Data Gateway_extract_path>\thirdpartyDrivers
   • In a personal deployment on MacOS, copy the JAR file into: <Application->Show Package Contents>Resources->app.nw-> thirdpartyDrivers
3. Restart the Data Gateway agent.
   See Start and Stop a Data Gateway Agent.

Tip: Use the Query Page in Data Gateway to test the JDBC driver. See Diagnosing Connection Issues Using The Query Page. See JDBC driver for information about the JDBC connection string and driver class.

You can now use the Trino connection type to connect to your data source. See Connect to a Remote Trino Data Source.