> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How Atoti connects data sources to visualization tools

> Connect Atoti to Atoti UI, Excel, Tableau, and Power BI, or build a custom front end using the XMLA endpoint, REST APIs, and WebSocket API for real-time pivot table and dashboard queries.

Atoti is designed to fit into any data analytics architecture.
It operates between data sources and visualization tools and delivers fast, precise and interactive analytics.

Business users can query Atoti using multiple front ends.
The recommended interface is Atoti UI, but users can also connect through third-party tools like Excel, Tableau, and Power BI.
This flexibility allows users to work with Atoti using the tools they are most comfortable with.

## Use Atoti UI

Atoti UI is the native graphical interface for Atoti.
It enables users to explore large-scale financial data using advanced pivot tables, interactive dashboards, and customizable visualizations.

Atoti UI supports all Atoti features, including context values and real-time updates.
It is continuously tested and updated alongside the Atoti platform to ensure full compatibility and reliability.

Atoti Python SDK automatically contains Atoti UI. No further set up is required.
[Find out how to install Atoti UI for Atoti Java SDK.](/data-visualization/atoti-ui/latest/developer-guide/install-and-start/set-up)

### Prepare Atoti UI for business users

Atoti UI can be deployed as soon as it is installed.
However, many of our clients choose to extend and personalize the interface.
This includes simple tasks like applying your organization's brand colors, as well as more complex ones such as building custom widgets.

[Find out more about how to prepare Atoti UI for business users.](/data-visualization/atoti-ui/latest/developer-guide/install-and-start/set-up)

## Use Excel to query Atoti

Access Atoti from an Excel pivot table, using the built-in drivers for Microsoft Analysis Services.

Find out more about how to do this:

* [Atoti Java SDK](/engine/java-sdk/latest/user_guide/querying/front_ends/excel_xmla)
* [Atoti Python SDK](https://docs.activeviam.com/products/atoti/python-sdk/latest/guides/connecting_from_excel.html)

The Atoti Excel Add-In provides some additional features for a more powerful and user-friendly experience.
It is available for Atoti Java SDK.
It requires an additional installation step.

### Advantages of Atoti Excel Add-in

* Allow users to drillthrough into special datagrids and widgets in Excel and bypass the Excel row limit
* Refresh the pivot table when real-time updates occur
* Move through sliced filters more easily using next and previous buttons
* View and configure context values
* View MDX queries executed by the pivot table

### Related reading

Find out how to

* [Work with the Atoti Excel Add-In.](https://docs.activeviam.com/products/atoti/excel-addin/latest/docs/overview)
* [Install and set up Atoti Excel for business users](https://docs.activeviam.com/products/atoti/excel-addin/latest/docs/overview/#installation)

## Use Tableau to query Atoti

Tableau can be used to query Atoti using the Atoti BI Adapter.
Users are able to access data and query Atoti using dedicated widgets.
The Atoti BI Adapter requires an extra installation step which is carried out by the developer team in your company.

Follow this link to find out more about Atoti BI Adapter for Tableau.

* [Work with Tableau using the Atoti BI Adapter](/engine/java-sdk/latest/user_guide/querying/front_ends/tableau/tableau_adapter)
* [Install and set up Atoti BI Adapter for Tableau](/engine/java-sdk/latest/user_guide/querying/front_ends/tableau/tableau_adapter_how_to)

## Use Power BI to query Atoti

Power BI can be used to query Atoti by importing data from Atoti into Power BI.

[Find out more about working with Atoti and Power BI.](/engine/java-sdk/latest/user_guide/querying/front_ends/power_bi)

## Prepare a custom front end for business users

We recommend using Atoti UI as the front end for business users.
However, it is also possible to integrate Atoti into a custom front end.

If you are preparing a custom front end for business users you will need to take the following into account.
Click on the links to find out more:

* [Continuous queries](/engine/java-sdk/latest/cube/continuous_query_engine)
* [MDX statements](/engine/java-sdk/latest/mdx/functions)

We make available a series of REST APIs and websockets to help with this:

* [XMLA endpoint](/engine/java-sdk/latest/endpoints/xmla)
* [Database REST API](/engine/java-sdk/latest/rest-api/database_rest_api)
* [Cube REST API](/engine/java-sdk/latest/rest-api/atoti_rest_api)
* [Cube Websocket API](/engine/java-sdk/latest/ws-api/pivot_ws_api)
* [Data export REST API](/engine/java-sdk/latest/rest-api/dataexport_rest_api)
* [ContentServer REST API](/engine/java-sdk/latest/rest-api/cs_rest_api)