Maybe someday you will need to use Adaptive Analytics but there is little information about this, so I decided to write an article on how to start developing a dashboard on Tableau using the Atscale cube.
PC preparation
You need a driver to connect. I use Cloudera Hive. You can download the driver from the official site:
https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-1.html
Registration is required, and you can do it right there for free. You also need to know your OS and bit depth in order to choose the right version for download.
Installation is simple, no explanation required.
Preparing AtScale
Project Publication
To connect a cube, you need to publish a project with the necessary cubes.
To publish, select PROJECTS > "Project name" > DRAFT "Project name" > PUBLISH
In the window that appears, you can select another datasource or leave the current one by clicking Next.
In this way, I once republished the project to different data sources when it was necessary to generate reports for 5 regions with an identical data structure, until the cubes and reports were cloned for each region.
Downloading the tds file
After that, we will have a published project. We need a Tableau connection file. In the Published Project, select the Cube. In our case, this is Members. Then go to the CONNECT tab. On it, select Connect a BI Tool > TABLEAU
In the window that appears, select DOWNLOAD TDS.
Connecting source to Tableau
New file
When starting Tableau, from the menu on the left, select Connect > To a File > More… from the list and open your .tds file that you downloaded earlier.
To an existing report
If you want to add a data source to an existing report, you need to select the Data Source tab on the tab bar below and click on the Tableau icon in the top left, then follow the steps described above.
Authorization at the data source
Tableau will ask you to enter your username and password from Atscale.
After successful authorization, your cube will appear in the data sources and you can start working.
Basically, the TDS file is an XML file, so it won't be too hard to fix this XML without downloading, if you republish the project under a different name, or make changes to the hostname of the Atscale server.
.png)
I found out about it by accident, just out of curiosity, I opened the TDS in the text editor.
I work a lot on Dashboards on Tableau and PowerBI in conjunction with Adaptive Analytics (based on AtScale). So you can write me questions and themes for future articles.
Hope you found the article useful, looking for your feedback!