# Datorama Export Integration

This article describes how to use [Datorama](http://www.datorama.com/) with Treasure Data. Datorama supports Treasure Data natively.

## Prerequisites

- Datorama account
- Basic knowledge of Treasure Data
- Requires access to the new Presto-specific JDBC/ODBC API, currently in Private Beta. Contact your account representative if you’d like access to this feature.


## Create a Data Stream

1. Select the Data Streams parent tab and then the Data Streams child tab.
2. Find Treasure Data under the Technical Vendors category and select the icon.


![](/assets/image-20191016-122208.b5301b49973c51149082e4032bf18de1443d8911cb1f329868541dca504e1d3e.6ef209bd.png)

Then, specify your data stream Name, Data Stream Type, and Default Channel Name.

![](/assets/image-20191016-122234.2950a230a3b5ac6b57712bc902660b2d72ca8b5ea10113d90b372ccebc8d29e2.6ef209bd.png)

Then, you’ll set Connection Info from the dialog as follows:

![](/assets/image-20191016-122255.5adfad73a9aaf24f8d7165e4367f16b79f0597069001ff364de78af4891bb3ad.6ef209bd.png)

Set each field:

| Delivery Method | Databases |
|  --- | --- |
| Connection String | jdbc:presto://api-presto.treasuredata.com:443/td-presto/database |
| Credentials - User | “YOUR_API_KEY” |
| Credentials - Password | (Empty) |
| Query | “YOUR_TREASURE_DATA_QUERY” |


Select **Validate**. If it shows Success! dialog, your setup was succeeded.

# Data Mapping

When you select **Next**, the Treasure Data SQL query executesand Datorama shows a list of columns of the result. In this screen, you map your original columns to Datorama’s global columns. With Datorama’s auto-mapping algorithm, some columns may be already mapped based on your previous mapping activities.

![](/assets/image-20191016-122537.daebd347690ee74d293834454bba3b9c6d1181af0a7a9e25d765818701164983.6ef209bd.png)

For the rest of the column, which is not mapped, you can manually map with global columns.

![](/assets/image-20191016-122546.eb7917aad177628a8c75ee5fd09b60bdbc31cea369935d4214c3adc090190ff9.6ef209bd.png)

Select **Save** to finalize the mapping phase. If it shows an error like the following example, you must resolve these errors to proceed to the next phase.

![](/assets/image-20191016-122614.6bd5dce18df50ce11310a9e27439a5d19eacb9694af8b48827215df66e3dca81.6ef209bd.png)

Data Preview shows the actual records retrieved from Treasure Data inside Datorama.

Check if the records are correct.

Select **Continue**.

![](/assets/image-20191016-122627.1db4ad880f0be543f89ebc90864d93968987e5af4597827ba348591fb38dd87b.6ef209bd.png)

Your data is ingested into Datorama. It should show Processing Complete! message when it’s completed.

![](/assets/image-20191016-122710.be0c2f16f5d6c97e0bee21252516db7e95257f78ca8a79f1cb8bfda19615eb16.6ef209bd.png)