Overview
The Tableau Source Component is an SSIS Data Flow Component for consuming data from a Tableau .hyper file (i.e. the latest evolution of Tableau Data Extract). The configuration parameters are provided in the standard Data Flow Component dialogs.
To use this component you will need to download Hyper API package for for C++ and then extract the contents of the bin sub-folder to C:\Program Files (x86)\COZYROC\SSIS\TDE64\.
Please note that Hyper API supports only 64-bit machines and applications. Thus, the design-time support is not available in any 32-bit Visual Studio (i.e. only Visual Studio 2022 can be used to set up the metadata).
Quick Start
In this section we will show you how to read data from a HYPER file using the Tableau Source component.
Step 1. In the SSIS Toolbox, locate the COZYROC's Tableau Source component and drag it onto the Data Flow canvas.
Step 2. Right click on Connection Managers tab and select New File Connection.
Step 3. Browse to select the file you want and click OK.
Step 4. Double-click on the component on the canvas. Once the component editor opens, select the Connection Manager you just created.
Step 5. Click on the Component Properties and go to the Custom Properties. In the SourceTable drop-down menu specify a table and click the Refresh button.
Step 6. Click on the Column Mappings to check the mappings and click OK.
Congratulations! You have successfully configured the Tableau Source component.
Parameters
Configuration
Use the parameters below to configure the component.
Select an existing File connection manager.
Related Topics: File Connection Manager
Specify the table from which the data is read. If the file has multiple schemas, it needs to be prefixed with the schema name (e.g.
mySchema.myTable). If not specified, the first table from the first schema will be processed.
Knowledge Base
What's New
- New: Introduced component.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.