Warning: Undefined array key 1 in /home/tools/www/www/wiki/lib/plugins/note/syntax.php on line 103
Warning: Undefined array key 1 in /home/tools/www/www/wiki/lib/plugins/note/syntax.php on line 103
Target type is Tableau Hyper file
Advanced ETL Processor is capable of creating Tableau Hyper files.
About Tableau:
Tableau is a business intelligence software that allows anyone to connect to data in a few clicks, then visualize and create interactive, shareable dashboards with a few more. It's easy enough that any Excel user can learn it, but powerful enough to satisfy even the most complex analytical problems. Securely sharing your findings with others only takes seconds.
The result is BI software that you can trust to actually deliver answers to the people that need them.
http://www.tableausoftware.com/business-intelligence
What’s Hyper?
Under the hood, Hyper is the technology that now powers Tableau’s data engine. The data engine is what handles opening, creating, refreshing, and querying your extracts.
https://www.tableau.com/about/blog/2018/1/extracts-hyper-speed-what-you-need-know-79397
More information about tableau field types
https://help.tableau.com/current/api/hyper_api/en-us/reference/sql/datatype.html
Adding data to an existing hyper table
To add data open writer properties dialogue and select an existing table from the drop-down box
Creating new hyper table
Open writer properties dialogue and enter new table name.
Define Table structure
Run Transformation and check that table was created
Running SQL against hyper database
It is possible to run SQL before and after loading the data.
Video Tutorials