// Licensed to the Apache Software Foundation (ASF) under one or more
// contributor license agreements.  See the NOTICE file distributed with
// this work for additional information regarding copyright ownership.
// The ASF licenses this file to You under the Apache License, Version 2.0
// (the "License"); you may not use this file except in compliance with
// the License.  You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
= Using Tableau With Apache Ignite

== Overview

http://www.tableau.com[Tableau, window=_blank] is an interactive data-visualization tool focused on business intelligence.
It uses ODBC APIs to connect to a variety of databases and data platforms allowing to analyze data stored there.

You can use the link:SQL/ODBC/odbc-driver[Ignite ODBC driver] to interconnect Ignite with Tableau and analyze the data stored
in the cluster.

== Installation and Configuration

To connect to an Apache Ignite cluster from Tableau, you need to do the following:

* Download and install Tableau Desktop. Refer to an official Tableau documentation located on http://www.tableau.com[the product's main website, window=_blank].
* Install the Apache Ignite ODBC driver on a Windows or Unix-based operating system. The detailed instructions can be found on the link:SQL/ODBC/odbc-driver[driver's configuration page].
* Finalize the driver configuration by link:SQL/ODBC/connection-string-dsn#configuring-dsn[setting up a DSN (Data Source Name)].
Tableau will connect to the DSN configured at this step.
* The ODBC driver communicates to the Ignite cluster over a so-called `ODBC processor`. Make sure that this component is
enabled on the link:SQL/ODBC/querying-modifying-data#configuring-the-cluster[cluster side].

After all the above steps are accomplished, you can connect to the cluster and analyze its data.

== Connecting to Ignite Cluster

. Launch Tableau application and find `Other Databases (ODBC)` setting located under `Connect` \-> `To a Server` \-> `+More...+` window.
+
image::images/tools/tableau-choosing_driver_01.png[Tableau Driver Selection]


. Click on the `Edit connection` reference.
+
image::images/tools/tableau-edit_connection.png[Tableau Edit Connection]

. Set the `DSN` property to the name you configured before. In the example below it's equal to `LocalApacheIgniteDSN`.
Once this is done, click on the `Connect` button.
+
image::images/tools/tableau-choose_dsn_01.png[Tableau Choose DSN]

. Tableau will try to check the connection by opening a temporary one. If the validation succeeds, the `Sign In` button
as well as additional connection related fields will become active. Click on `Sign In` to finalize the connection process.
+
image::images/tools/tableau-choose_dsn_02.png[Tableau Choose DSN]

== Data Querying and Analysis

Once the connection is successfully established between Ignite and Tableau, the data can be queried and analyzed in a
variety of ways supported by Tableau. For more details, refer to the  http://www.tableau.com/learn/training[official Tableau documentation, window=_blank].

image::images/tools/tableau-creating_dataset.png[Tableau Creating DataSet]

image::images/tools/tableau-visualizing_data.png[Tableau Visualizing Data]