COZYROC Tableau components, part of COZYROC SSIS+ suite, are third-party plug-ins for Microsoft SSIS that make it easy to integrate or migrate data to and from Tableau. You can use any application, service or database supported by SQL Server Integration Services (SSIS) or COZYROC’s toolkit as the source for a Tableau Data Extract (TDE) file. The toolkit is easy to use and follows the same guidelines and principles used by the standard out-of-the-box SSIS components.
The Tableau integration package consists of:
Overview
Configuration is provided for establishing connections with Tableau Server via its REST API. The configuration is used in the REST Connection Manager.
Demonstration
Quick Start
In this guide, we will show you how to create a connection to Tableau service using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio".
Step 2. Right click on "Connection Managers" tab and select "New Connection..."
Step 3. In "Add SSIS Connection Manager" scroll down and select "REST connection manager" and click "Add..."
Step 4. From Configuration combo box select "Tableau".
Step 5. Enter server host parameter.
Step 6. Enter user name parameter.
Step 7. Enter password parameter.
- site - If you are connecting to "Tableau Online", the site parameter is mandatory. For on-premise server it is optional and when empty the result is identical to specifying the Default site.
- impersonateId - The LUID of a user to sign in as. For impersonation when a system administrator signs in with user name and password.
Step 7. Click "Test Connection" to test your connection.
Congratulations! You have now established a connection to your Tableau instance.
In this guide, we will show how to read data from the Tableau service resource using COZYROC REST Source component.
Step 1. Select existing "Data Flow task" or create new "Data Flow Task".
Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.
Step 3. Double click on "REST Source" component and select Tableau connection from the combo. Select from available Tableau resources listed in the second combo below.
Optionally you can include extra parameters in the grid below if needed.
Step 4. Click on "Columns tab" and select Tableau resource columns you want to read.
Step 5. Click Preview to make sure all necessary resource columns are included.
Bravo! You have now learned how to read data from Tableau service.
In this guide, we will show how to write data to Tableau service resource using COZYROC REST Destination component.
Step 1. Select existing "Data Flow task" or create new "Data Flow Task".
Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.
Step 3. Double click on "REST Destination" component and select Tableau connection from the combo. Also, select resource action and the Tableau resource you want to work on.
Step 4. Click on "Mapping" tab and map the input columns for the process you are configuring.
If you want to provide input for other resource composite objects, change the input above and map the columns.
Done. You have now learned how to write data into a Tableau resource.
In this guide, we will provide steps to upload a Tableau TDE file to a server. For novice users, we recommend you first review "Push data to service" guide.
You can upload a Tableau TDE file either to a "Data Source" or "Workbook" resource. This guide will show the "Data Source" use and the process will be similar for the other resource.
Step 1. You have to provide input for the following required columns:
- name - name of the data source.
- project.id - project identifier.
- content - the TDE file content. Use the standard "Import Column" transformation to load the file content into a data flow column. Here you can find one reference how to configure the "Import Column" transformation.
Step 2. Set the Tableau connection.
Step 3. Set the resource to "Data Source".
Step 4. Set the action to Create.
Step 5. Set batch size to 1.
Step 6. Click on the "Mapping" tab and connect the required input columns.
Configuration
Base URL address: https://[pod].online.tableau.com/api/3.4.
-
The authentication uses a session token.
The authentication has the following user-defined parameters:
- name: Required. Specify user name.
- password: Required. Specify password.
- site:
- impersonateId:
- expiration: Session token expiration in minutes.
The following request parameters will be automatically processed during the authentication process:
-
X-Tableau-Auth:
{{=token.Access}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#sign_in.
- [Read] action
-
Endpoint URL address:
/sites.
The result is extracted from:{{=response.sites.site}}.
The result is paginated.The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_sites.
-
pageSize:
- [Create] action
-
Endpoint URL address:
/sites.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{={ site: item } }}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_site.
-
_includeUserParameters:
- [Update] action
-
Endpoint URL address:
/sites/{{=item.id}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{={ site: item } }}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_site.
-
_includeUserParameters:
- [Delete] action
-
Endpoint URL address:
/sites/{{=item.id}}.
The action uses DELETE method.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_site.
- id
A key field. Template: Id.
- name
Template: ShortText.
- contentUrl
Template: ShortText.
- adminMode
Template: ShortText.
- disableSubscriptions
Data type: DT_BOOL
- state
Template: ShortText.
- revisionHistoryEnabled
Data type: DT_BOOL
- revisionLimit
Data type: DT_I4
- subscribeOthersEnabled
Data type: DT_BOOL
- guestAccessEnabled
Data type: DT_BOOL
- cacheWarmupEnabled
Data type: DT_BOOL
- commentingEnabled
Data type: DT_BOOL
- flowsEnabled
Data type: DT_BOOL
- userQuota
Data type: DT_I4
- storageQuota
Data type: DT_I4
- [Read site] action
-
Endpoint URL address:
/sites/{{=parameters.site}}/views.
The result is extracted from:{{=response.views.view}}.
The result is paginated.The action has the following user-defined parameters:
- site: Required. Specifies site identifier.
The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_views_for_site.
- [Read workbook] action
-
Endpoint URL address:
/sites/{{=parameters.site}}/workbooks/{{=parameters.workbook}}/views.
The result is extracted from:{{=response.views.view}}.
The result is paginated.The action has the following user-defined parameters:
- site: Required. Specifies site identifier.
- workbook: Required. Specifies workbook identifier.
The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_views_for_workbook.
- id
Template: Id.
- name
Template: ShortText.
- contentUrl
Template: ShortText.
- workbook
Template: Reference.
- owner
Template: Reference.
- usage
Field components:
- Contains the following components: totalViewCount.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/dataAlerts.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_data-driven_alerts.
- [Update] action
-
Endpoint URL address:
/dataAlerts/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_data-driven_alert.
- [Delete] action
-
Endpoint URL address:
/dataAlerts/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_data-driven_alert.
- id
A key field. Template: Id.
- subject
Template: ShortText.
- creatorId
Template: Id. A read-only field.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- frequency
Template: ShortText.
- public
Data type: DT_BOOL
- owner
Template: Reference.
- view
Template: Reference. A read-only field. Field components:
-
Uses template:
Reference. - Contains the following components: workbook, project.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/projects.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_projects.
- [Create] action
-
Endpoint URL address:
/projects.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_project.
- [Update] action
-
Endpoint URL address:
/projects/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_project.
- [Delete] action
-
Endpoint URL address:
/projects/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_project.
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: LongText.
- contentPermissions
Template: ShortText.
- owner
Template: Reference. A read-only field.
- parentProjectId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/workbooks.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_workbooks_for_site.
- [Read user] action
-
Endpoint URL address:
{{=connection.serverHost}}/users/{{=parameters.user}}/workbooks.The action has the following user-defined parameters:
- user: Required. Specifies user identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_workbooks_for_user.
- [Create] action
-
Endpoint URL address:
/workbooks.The following request parameters will be automatically processed:
-
uploadSessionId:
{{=Tableau.uploadFile(item.content)}} -
workbookType:
{{=item.type || 'twb'}} -
multipart/mixed;boundary={{=Tableau.BoundId}}:
{{=Tableau.getRequestBody({ workbook: item })}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#publish_workbook.
-
uploadSessionId:
- [Update] action
-
Endpoint URL address:
/workbooks/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_workbook.
- [Delete] action
-
Endpoint URL address:
/workbooks/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_workbook.
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: LongText.
- webpageurl
Template: ShortText. A read-only field.
- contentUrl
Template: ShortText. A read-only field.
- showTabs
Data type: DT_BOOL
- size
Data type: DT_I4 A read-only field.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- project
Template: Reference.
- owner
Template: Reference.
- tags
Field components:
- An array.
- content
Data type: DT_IMAGE The value is gathered from
/workbooks/{{=item.id}}/contentaddress.Data type: DT_IMAGE A read-only field. The value is gathered from
/workbooks/{{=item.id}}/pdfaddress.- type
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/workbooks/{{=parameters.workbook}}/connections.The action has the following user-defined parameters:
- workbook: Required. Specifies workbook identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_workbook_connections.
- [Update] action
-
Endpoint URL address:
/workbooks/{{=item.workbookId}}/connections.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_workbook_connection.
- id
A key field. Template: Id.
- type
Template: ShortText.
- serverAddress
Template: ShortText.
- serverPort
Template: ShortText.
- userName
Template: ShortText.
- password
Template: ShortText.
- embedPassword
Data type: DT_BOOL
- workbookId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/datasources.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_data_sources.
- [Create] action
-
Endpoint URL address:
/datasources.The following request parameters will be automatically processed:
-
uploadSessionId:
{{=Tableau.uploadFile(item.content)}} -
datasourceType:
{{=item.type || 'tde'}} -
multipart/mixed;boundary={{=Tableau.BoundId}}:
{{=Tableau.getRequestBody({ datasource: item })}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#publish_data_source.
-
uploadSessionId:
- [Update] action
-
Endpoint URL address:
/datasources/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_data_source.
- [Delete] action
-
Endpoint URL address:
/datasources/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_data_source.
- id
A key field. Template: Id.
- name
Template: ShortText.
- contentUrl
Template: ShortText.
- type
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- project
Template: Reference.
- owner
Template: Reference.
- tags
Field components:
- An array.
- isCertified
Data type: DT_BOOL
- certificationNote
Template: ShortText.
- content
Data type: DT_IMAGE The value is gathered from
/datasources/{{=item.id}}/contentaddress.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/datasources/{{=parameters.datasource}}/connections.The action has the following user-defined parameters:
- datasource: Required. Specifies data source identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_data_source_connections.
- [Update] action
-
Endpoint URL address:
/datasources/{{item.datasourceId}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_data_source_connection.
- id
A key field. Template: Id.
- type
Template: ShortText.
- serverAddress
Template: ShortText.
- serverPort
Template: ShortText.
- userName
Template: ShortText.
- password
Template: ShortText.
- embedPassword
Data type: DT_BOOL
- datasourceId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_groups.
- [Create] action
-
Endpoint URL address:
/groups.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_group.
- [Update] action
-
Endpoint URL address:
/groups/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_group.
- [Delete] action
-
Endpoint URL address:
/groups/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_group.
- id
A key field. Template: Id.
- name
Template: ShortText.
- domain
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: name.
-
Uses template:
- import
Field components:
-
Uses template:
ShortText. - Contains the following components: source, domainName, siteRole.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_users_on_site.
- [Read group] action
-
Endpoint URL address:
/groups/{{=parameters.group}}/users.The action has the following user-defined parameters:
- group: Required. Specifies group identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_users_in_group.
- [Create] action
-
Endpoint URL address:
/users.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#add_user_to_site.
- [Update] action
-
Endpoint URL address:
/users/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_user.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#remove_user_from_site.
- id
A key field. Template: Id.
- name
Template: ShortText.
- siteRole
Template: ShortText.
- lastLogin
Template: DateTime. A read-only field.
- externalAuthUserId
Template: Id.
- authSetting
Template: ShortText.
- fullName
Template: ShortText.
Template: ShortText.
- password
Template: ShortText.
Based on resource template Base.
- [Read datasource] action
-
Endpoint URL address:
/datasources/{{=parameters.datasource}}/revisions.The action has the following user-defined parameters:
- datasource: Required. Specifies data source identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_data_source_revisions.
- [Read workbook] action
-
Endpoint URL address:
/workbooks/{{=parameters.workbook}}/revisions.The action has the following user-defined parameters:
- workbook: Required. Specifies workbook identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_workbook_revisions.
- [Delete] action
-
Endpoint URL address:
{{=(parameters.resource == 'datasource') ? '/datasources/' + item.resourceId + '/revisions/' + item.revisionNumber : '/workbooks/' + item.resourceId + '/revisions/' + item.revisionNumber}}.The action has the following user-defined parameters:
- resource: Required. Specifies resource type - datasource, workbook.
- revisionNumber
A key field. Data type: DT_I4
- createdAt
Template: DateTime.
- isDeleted
Data type: DT_BOOL
- user
Template: Reference.
- resource
Template: ShortText. The gathered value is processed with
{{=parameters.get('datasource') ? 'datasource' : 'workbook'}}expression.- resourceId
Template: Id.
- content
Data type: DT_IMAGE The value is gathered from
{{=parameters.get('datasource') ? '/datasources/' + parameters.datasource + '/revisions/' + item.revisionNumber + '/content' : '/workbooks/' + parameters.workbook + '/revisions/' + item.revisionNumber + '/content'}}address.
Based on resource template Base.
- [Read datasource] action
-
Endpoint URL address:
/datasources/{{=parameters.datasource}}/permissions.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- datasource: Required. Specifies data source identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_data_source_permissions.
- [Read project] action
-
Endpoint URL address:
/projects/{{=parameters.project}}/permissions.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- project: Required. Specifies project identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_project_permissions.
- [Read] action
-
Endpoint URL address:
/projects/{{=parameters.project}}/default-permissions/{{=parameters.resource}}.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- project: Required. Specifies project identifier.
- resource: Required. Specifies resource type - datasources, workbooks, flows
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_default_permissions.
- [Read view] action
-
Endpoint URL address:
/views/{{=parameters.view}}/permissions.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- view: Required. Specifies view identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_view_permissions.
- [Read workbook] action
-
Endpoint URL address:
/workbooks/{{=parameters.workbook}}/permissions.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- workbook: Required. Specifies workbook identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_workbook_permissions.
- user
Template: Reference.
- group
Template: Reference.
- capabilities
Field components:
- An array.
- Contains the following components: name, mode.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/jobs.
The result is extracted from:{{=response.backgroundJobs}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_jobs.
- [Delete] action
-
Endpoint URL address:
/jobs/{{=item.id}}.
The action uses PUT method.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#cancel_job.
- id
A key field. Template: Id.
- status
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- startedAt
Template: DateTime. A read-only field.
- endedAt
Template: DateTime. A read-only field.
- priority
Template: ShortText.
- jobType
Template: ShortText.
- [Read] action
-
Endpoint URL address:
/schedules.
The result is extracted from:{{=response.schedules.schedule}}.
The result is paginated.The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_schedules.
-
pageSize:
- [Create] action
-
Endpoint URL address:
/schedules.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{={ schedule: item } }}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_schedule.
-
_includeUserParameters:
- [Update] action
-
Endpoint URL address:
/schedules/{{=item.id}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{={ schedule: item } }}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_schedule.
-
_includeUserParameters:
- [Delete] action
-
Endpoint URL address:
/schedules/{{=item.id}}.
The action uses DELETE method.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_schedule.
- id
A key field. Template: Id.
- name
Template: ShortText.
- state
Template: ShortText.
- priority
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- type
Template: ShortText.
- frequency
Template: ShortText.
- nextRunAt
Template: DateTime.
- endScheduleAt
Template: DateTime.
- executionOrder
Template: ShortText.
- frequencyDetails
Field components:
-
Uses template:
ShortText. - Contains the following components: start, end, intervals.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/subscriptions.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_subscriptions.
- [Create] action
-
Endpoint URL address:
/subscriptions.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_subscription.
- [Update] action
-
Endpoint URL address:
/subscriptions/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_subscription.
- [Delete] action
-
Endpoint URL address:
/subscriptions/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_subscription.
- id
A key field. Template: Id.
- subject
Template: ShortText.
- content
Field components:
-
Uses template:
Id. - Contains the following components: id, type.
-
Uses template:
- schedule
Template: Reference.
- user
Template: Reference.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/favorites/{{=parameters.user}}.The action has the following user-defined parameters:
- user: Required. Specifies user identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_favorites_for_user.
- [Create] action
-
Endpoint URL address:
/favorites/{{=item.userId}}.
- [Delete] action
-
Endpoint URL address:
/favorites/{{=item.userId}}/{{= (item.datasource && 'datasources/' + item.datasource.id) || (item.project && 'projects/' + item.project.id) || (item.view && 'views/' + item.view.id) || (item.workbook && 'workbooks/' + item.workbook.id) }}.
- label
Template: ShortText.
- project
Template: Reference.
- workbook
Template: Reference.
- view
Template: Reference.
- datasource
Template: Reference.
- userId
Template: Id.
- [Read] action
-
The result is extracted from:{{=response[resource.objects][resource.object]}}.
The result is paginated.The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
-
pageSize:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=function() { var result = {}; result[resource.object] = item; return result; }()}}
-
_includeUserParameters:
- [Update] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=function() { var result = {}; result[resource.object] = item; return result; }()}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- Id
Data type: DT_GUID
- DateTime
Data type: DT_DBTIMESTAMP
- Reference
Field components:
-
Uses template:
Id. - Contains the following components: id, name.
-
Uses template:
Knowledge Base
- Where can I find the documentation for the Tableau Connection?
- How to install the Legacy Extract API for .tde files.
What's New
- Fixed: Incorrect pagination definition (Thank you, Leo).
- New: Introduced connection.
Related documentation
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
Overview
The Tableau Destination Component is an SSIS Data Flow Component for loading data into a Tableau Data Extract (TDE) file. The configuration parameters are provided in the standard Data Flow Component dialogs.
2.2 Starting in Tableau 10.5 to use the component for .hyper format files, you will need to download the Hyper API package for C++ and then extract the contents of the bin sub-folder to C:\Program Files (x86)\COZYROC\SSIS\TDE64\. The newest package from Tableau only support 64-bit machines, so make sure you execute it in a 64-bit process.
Quick Start
In this section we will show you how to set up a Tableau Destination component.
Step 1. In the SSIS Toolbox, locate the COZYROC's Tableau Destination component and drag it onto the Data Flow canvas.
Step 2. Right click on Connection Managers tab and select New File Connection.
Step 3. Create a new file or Browse to select the existing 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. Select Create action. Select table collation from the Collation drop-down menu.
Step 6. Click on the Input Columns to select the column(s) you want and click OK.
Congratulations! You have successfully configured the Tableau Destination component.
In this section we will show you how to set up a Tableau Destination component and update data in a Tableau .hyper file.
Step 1. In the SSIS Toolbox, locate the COZYROC's Tableau Destination 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 an existing file you want to update 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. Select Update action. Select table collation from the Collation drop-down menu. Select PrimaryKeys from the list that the update will depend on.
Step 6. Click on the Input Columns to select the column(s) you want and click OK.
Congratulations! You have successfully configured the Tableau Destination component to perform update against a Tableau .hyper file.
The steps for Delete data in a Tableau .hyper file are the same. You only must select Delete action in component Custom Properties.
Parameters
Configuration
Use the parameters below to configure the component.
Select an existing File connection manager.
Related Topics: File Connection Manager
Indicate the destination table where the data is to be loaded.
Select table collation.
Select the destination resource action. This property has the options listed in the following table.
Action Description Create Create new records in the destination REST resource. Update Update existing records in the destination REST resource. You must specify the appropriate primary keys for the update to work. Delete Delete existing records in the destination REST resource. You must specify the appropriate primary keys for the delete to work. Select primary keys to match records for Update/Delete action.
Knowledge Base
- Where can I find the documentation for the Tableau Destination?
- How to install the Legacy Extract API for .tde files.
What's New
- New: Support for the latest Hyper API package at https://tableau.github.io/hyper-db/docs/releases/# .
- New: Support for the updating/deleting rows in a .hyper file (using the latest Hyper API)
- New: A new DestinationTable parameter specifying where to load data.
- Fixed: Incorrect inclusion of excluded columns in a dynamic data flow.
- New: Component now provides better diagnostic information when required third-party modules are not properly deployed.
- New: Support for newer Tableau SDK modules.
- New: Support for Tableau 10.5 Hyper.
- New: Introduced component.
Related documentation
Tableau Connection
- Fixed: Incorrect pagination definition (Thank you, Leo).
- New: Introduced connection.
Tableau Destination
- New: Support for the latest Hyper API package at https://tableau.github.io/hyper-db/docs/releases/# .
- New: Support for the updating/deleting rows in a .hyper file (using the latest Hyper API)
- New: A new DestinationTable parameter specifying where to load data.
- Fixed: Incorrect inclusion of excluded columns in a dynamic data flow.
- New: Component now provides better diagnostic information when required third-party modules are not properly deployed.
- New: Support for newer Tableau SDK modules.
- New: Support for Tableau 10.5 Hyper.
- New: Introduced component.
Knowledge Base
- Where can I find the documentation for the Tableau Connection?
- Where can I find the documentation for the Tableau Destination?
- How to install the Legacy Extract API for .tde files.
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.