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.

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.

Tip: 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.