Visit our new documentation site! This documentation page is no longer updated.

Migrating to Presto ODBC Driver

This document discribes how to migrate from Treasure Data ODBC Driver to the new Presto ODBC Driver.

The final day for migrating your ODBC connectivity to the new one is June 6th, 2017. At that time, the current version will stop working.

Table of Contents

Tableau Desktop ODBC Connection

This section convers a step to update your existing datasource in Tableau Packaged Workbook(twbx).

1. Setup Presto ODBC Driver

Please refer to here

2. Edit DataSource

First, open “Edit Data Source” in the existing twbx file.

https://treasure-data.gyazo.com/55b3398d3cb9ad48b485590e44c2b2c7

Then, Connections section contains Treasure Data ODBC Driver’s connection. You can edit it after you open the editor at the pull down menu.

https://treasure-data.gyazo.com/a998e81b08b00e40c53dd701233f4501

https://treasure-data.gyazo.com/b45e26b1020459465e8ad8a41493ca3f

In Other Databases (ODBC) menu, you can change DSN to “Treasure Data Presto ODBC DSN”. After checking the connectivity, you will get same schema / same data as Treasure Data ODBC Driver.

Finally, please confirm whether your workbook can recollect data after you exchange these connections.

Excel ODBC Connection

This section covers a step to update your existing Excel ODBC connection, which is using Treasure Data ODBC Driver.

1. Setup Presto ODBC Driver

Please refer to here

2. Reinstall Excel from 32 bit to 64 bit.

If you use Treasure Data ODBC Driver with Excel, we expect your Excel version is for 32 bit. On the other hands, our Presto ODBC Driver supports only 64 bit version. In this case, please unistall your Excel 32 bit version, and then install Excel 64 bit version. For business use-case, Office 365 subscription package provides both version. Please check it with your Administrator.

3. Open your Excel file using Treasure Data ODBC Driver.

First, please open your existing Excel file using Treasure Data ODBC Driver.

4. Add Presto ODBC connection as DataSource (New Query –> From Other Sources –> From ODBC)

Second, you need to add your Presto ODBC connection as DataSource. You can add it at From Other Sources

https://treasure-data.gyazo.com/fc8a4663f1fac57fb201f50c38bbbc98

5. Exchange Data source setting

In Data source settings, you have already registered one Treasure Data ODBC Driver at least. Please select the setting, and click Change Source.

https://treasure-data.gyazo.com/cd73ea8805f4fbef9e27ba205f0e36b5

You can choose Treasure Data Presto ODBC DSN through step 1.

https://treasure-data.gyazo.com/2bfa6e18dc7e01f23a478281c9999825

The exchange data source setting is done. The existing worksheet would be kept working. Please try “Refresh All”.

https://treasure-data.gyazo.com/074a0f0de9f911c469d8bf54f473fa6f

If you have any questions, please email us at support team.


Last modified: May 19 2017 15:56:47 UTC

If this article is incorrect or outdated, or omits critical information, let us know. For all other issues, access our support channels.