Connect to Databases & Create Datasets

This article describes how to connect to databases from Treasure Reporting.

Table of Contents

Initial Setup by Account Owner

First, please login as Treasure Data’s account owner and go to Treasure Data Console.

Then you’ll see Reporting button on the left navigation. Clicking Reporting button will let you redirect to reporting.treasuredata.com and log in to Treasure Reporting.

First time account owner clicks the Reporting button, it will setup Treasure Reporting account automatically.

Connect to Databases

Then let’s set up the connection from Treasure Reporting to your databases. In Treasure Reporting, connections are called Integrations.

To create the new integration, please click the big red + button on the bottom right, and select Integration. Then you can choose either Treaure Data or PostgreSQL.

Treasure Data

Treasure Data integration will let you query directly against your databases.

  • Integration Name: Your integration name
  • Endpoint: api-presto.treasuredata.com
  • Database Name (Optional): Your default database to use
  • API key: Your apikey. Please refer here to retrieve your API key.

After you’ve confirmed the connection, please select Multidimentional data source.

PostgreSQL (Datatank)

PostgreSQL integration will connect to your Datatanks, which is a TD’s datamart.

  • Integration Name: Your integration name
  • Host: Your PostgreSQL hostname
  • Port: Your PostgreSQL port
  • Database Name: Your PostgreSQL database name (you need to create integration per database)
  • Username: Your PostgreSQL username
  • Password: Your PostgreSQL password

Create Dataset

Next, you need to create a Dataset which represents the source data for your report & dashboard. Please click the big red + button on the bottom right again, and select Dataset.

Then click Dataset based on existing integration and select the integration you’ve created above.

Then, you can create the dataset either from your own SQL or existing tables.

Then you specify types of each column.

If you click big blue Done button, dataset will be created. Now it’s time to create charts & dashboards!


Last modified: Apr 28 2017 09:59:17 UTC

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