# Odbc Driver for Presto

Treasure Data provides a Presto API that can integrate directly with our Presto-specific ODBC driver. The installer for the driver is currently available for Windows 64-bit platform only.

The Presto ODBC driver will be deprecated in June 2025. There are no plans to provide updates to the ODBC driver in the future; consider using the OSS [Trino JDBC Drive](https://repo1.maven.org/maven2/io/trino/trino-jdbc/)

* [Release Downloads](/tools/cli-and-sdks/odbc-driver-for-presto#release-downloads)
* [Windows System Requirements](/tools/cli-and-sdks/odbc-driver-for-presto#windows-system-requirements)
* [Migrate from Treasure Data ODBC Driver for 32bit](/tools/cli-and-sdks/odbc-driver-for-presto#migrate-from-treasure-data-odbc-driver-for-32bit)
* [Install the Driver on Windows (64-bit)](/tools/cli-and-sdks/odbc-driver-for-presto#install-the-driver-on-windows-64-bit)
* [Configure the Proxy Server](/tools/cli-and-sdks/odbc-driver-for-presto#configure-the-proxy-server)


# Release Downloads

The downloads are available from your account or support representative.

* [TreasureDataPrestoODBC.msi](https://drive.google.com/file/d/1wGsWZ2krN-6f9d65AsbnVv1kheWMJ8X0/view?usp=sharing)
  * Windows Treasure Data Presto ODBC Driver installer
* [Treasure Data Presto ODBC Driver.tdc](https://drive.google.com/file/d/1juqsZfEjJ-_ca4BYlbVl2UMkcTxg-MPa/view?usp=sharing)
  * Tableau Datasource Customization File (.tdc) for Tableau users.
  * Copy this file to `My Documents\My Tableau Repositories\Data Sources` folder.
    * This file controls Tableau to use Presto compatible SQL queries.
* 2020-06-16 Download[ __ 1.4.0](https://drive.google.com/file/d/1wGsWZ2krN-6f9d65AsbnVv1kheWMJ8X0/view?usp=sharing) – you must select Download.
  * Support for two-way authentication
  * Support for Open-source Presto Server versions 0.235 and earlier
  * Support Presto Foundation Server 333 and earlier
  * The driver requires TLS version 1.2
  * Installer ships with visual c++ 14 runtime libraries (x64)
* 2018-06-19 Download [1.3.0](https://treasuredata.zendesk.com/knowledge/revisions/QnJhbmQ6MzgxMjE3/QXJ0aWNsZTozNjAwMDA3MDkxNjc6MzQ=/en-us?showDiff=true)


# Windows System Requirements

One of the following operating systems:

* Windows Vista, 7, 8, or 10
* Windows Server 2008 or later
* Visual C++ Redistributable Packages for Visual Studio 2013 installed. You can download the installation packages at [https://www.microsoft.com/en-ca/download/details.aspx?id=40784](https://www.microsoft.com/en-ca/download/details.aspx?id=40784).


# Migrate from Treasure Data ODBC Driver for 32bit

Treasure Data ODBC Driver for 32bit is no longer supported. Replace it with Presto ODBC Driver according to the following instructions. The old driver is no longer supported.

# Install the Driver on Windows (64-bit)

1. Download the ODBC driver installer [TreasureDataPrestoODBC.msi](https://drive.google.com/file/d/1ybuGmhp_Y91EC0-25VWm08bKvRhu0p_s/view?usp=sharing).
2. Double-click on the installer package and follow the instructions.
3. Open the Start menu (or press the Windows key) and search/select ‘ODBC Data Source Administrator (64-bit)’.
4. Select Treasure Data Presto ODBC DSN, and select **Configure**.
5. Enter your Master TD API key into the User field.
Follow these instructions to obtain your Master TD API key.


![](/assets/image-20190923-183549.5bd3ede35a9180cd5165ba8f88e4a6153c76da1df1deec15eece1af80570c40e.60bcc915.png)

![](/assets/image-20190923-183630.85ac44d879ec74e0d88817d7210fac0638ded33b5d24954ed4460180372db0ef.60bcc915.png)

1. Type the following values:
**Authentication Type** : No Authentication
**User** : **YOUR MASTER API KEY**
**Host** : [https://api-presto.treasuredata.com](https://api-presto.treasuredata.com)
**Port** : 443
**Catalog** : td-presto
2. Select **Test**.
3. If successful, press **OK.**


# Configure the Proxy Server

If you are connecting to a data source through a proxy server, you must provide connection information for the proxy server.

1. Open the ODBC Data Source Administrator where you created the DSN. Select the DSN, select **Configure** , and then select **Proxy Options**.
2. Check the **Use Proxy Server** box.
3. In the **Proxy Host** field, enter the hostname or IP address of the proxy server.
4. In the **Proxy Port** field, enter the TCP port number that the proxy server uses to listen for client connections.
5. In the **Proxy Username** field, enter your user name for accessing the proxy server.
6. In the **Proxy Password** field, enter the password of the user name.
7. (Optional) To save the proxy server in the Windows registry, select **Save Password (Encrypted)**.
8. Click **OK**.