Prepare the Tableau <source ID> configuration file

The lineage harvester uses the configuration file to connect to Tableau. However, you may need to provide additional information via a Tableau <source ID> configuration file. You use the Tableau <source ID> configuration file to:

  • Define your Tableau operating model.
  • Provide additional information about databases and files in Tableau. For example, you can define the system name of databases in Tableau.
  • Map a Tableau technical database name to the real database name, to preserve stitching. See the databaseMapping property.
  • Define in which domains in Collibra you want to ingest assets from your Tableau sites and Tableau projects. See the filters property.

Steps

  1. Create a new JSON file in the lineage harvester config folder.
  2. Give the JSON file the same name as the value of the Id property in the lineage harvester configuration file.
    Example If the value of the Id property in the lineage harvester configuration file is tableau-source-1, then the name of your JSON file should be tableau-source-1.conf.
    Important Your JSON file must have the file extension .conf.
  3. For each database in Tableau, add the following content to the JSON file:
    Tip You can use wildcards to capture multiple string combinations for any of these properties.
    PatternDescription
    *Matches everything.
    ?Matches any single character.
    [seq]Matches any character in "seq".
    [!seq]Matches any character not in "seq".

    Property

    		Description
    collibraSystemNames

    This section contains the system information for different Tableau data sources. Depending on the kind of data source or connection, you have to specify how to connect to this data source.

    Tip For more information, see the Tableau documentation. We also recommend to check the list of supported connectors in Tableau.

    databases

    This section contains connection information to one or more databases in Tableau.

    Tip 
    • If you do not have databases in Tableau, you can remove this section.
    • The values that you specify for this property are not case sensitive.
    hostname
    		The host name of the database.
    collibraSystemName

    The system name of the database.

    files

    This section contains connection information to one or more files in Tableau.

    Tip If you do not have files in Tableau, you can remove this section.

    filePath
    		The full path to the file. For example, the path to a JSON file.
    collibraSystemName
    		The system name of the file.
    connectors

    This section contains connection information to one or more connectors in Tableau.

    Tip 
    • If you do not have connectors in Tableau, you can remove this section.
    • The values that you specify for this property are not case sensitive.
    connectorUrl
    		The URL of the connector. For example, the URL to Google Analytics.
    collibraSystemName
    		The system name of the connector.
    cloudFiles

    This section contains connection information to one or more cloud files in Tableau's input data.

    Tip If you do not have cloud files in Tableau, you can remove this section.

    name
    		The name of the file. For example, the name of a Zendesk file.
    collibraSystemName
    		The system name of the cloud file.

    databaseMapping

    The Tableau API returns a technical database name based on the hostname, instead of the actual database name, which breaks stitching. The values that you specify for this property are not case sensitive.

    This property allows you to map a Tableau technical database name to the real database name, for example:

     
 "databaseMapping": {
	"<hostname:port>":"<actual database name>" 
 }

    Including the port, as shown in the example, is optional.

    filters (Beta)

    This section is a beta feature.

    This section defines the following ingestion rules:

    • The Tableau projects and sub-projects that you want to ingest assets from.
    • The domains in Collibra that you want to ingest assets in.

    Filtering is transitive, which means that all resources in a specified project, such as Tableau workbooks and all sub-projects are ingested.

    Tableau assets that are not mapped to the specified domains, for example the Tableau Server assets and the parent projects if you specify the sub-projects, are ingested in the default domain. For more information about the default domain, see the domainID property in the lineage harvester configuration file.

    Note  

    • If you want to ingest all assets in a Tableau site, use the domainMapping section.

    • The domainMapping and filters sections are mutually exclusive. Do not include both domainMapping and filters sections in your JSON file.
    projects

    Specifies the Tableau projects to be ingested and the domain in which you want to ingest assets from the Tableau projects or sub-projects.

    site_name > project_name : domain_id

    Specify <site_name> with the Tableau site name and <project_name> with the Tableau project name.

    Specify <domain_id> with the unique reference ID of the domain in Collibra in which you want to ingest assets from the Tableau project.

    When you specify the site and project names, the following rules apply:

    • Add spaces before and after >. The spaces are separators between the site and project.
    • Specify the full exact site and project names. Do not use wildcards.

    When you specify a project, all assets in the specified Tableau project are ingested in the specified domain. If you want to ingest assets from different Tableau projects in one domain, you can specify the same value for domain id for different projects.

    Example

    "Collibra_tab_partner_site > JB_Test_2812": "d224a1a5-43b4-43b2-8df0-ddf8f2726b82"

    site_name > project_name > sub-project_name : domain_id

    Specify <site_name> with the Tableau site name, <project_name> with the Tableau project name, and <sub-project_name> with the Tableau sub-project name.

    Specify <domain_id> with the unique reference ID of the domain in Collibra in which you want to ingest assets from the Tableau project.

    When you specify the site, project and sub-project names, the following rules apply:

    • Add spaces before and after >. The spaces are separators between the site and project.
    • Specify the full exact site and project names. Do not use wildcards.

    <sub-project_name> is optional. If you specify a sub-project, the assets in the specified sub-project are ingested in the specified domain. However, the assets in the specified project are ingested in the default domain. For more information about the default domain, see the domainID property in the lineage harvester configuration file.

    Example

    "Collibra_tab_partner_site > JB_Test_2812 > ProjectJJ2": "d224a1a5-43b4-43b2-8df0-ddf8f2726b82"

    domainMapping

    This section defines in which domains in Collibra you want to ingest assets from your Tableau sites and Tableau projects.

    Important 
    • Use this property only if you want to ingest Tableau assets into multiple domains in Collibra Data Intelligence Cloud. If you want to ingest into a single domain, use only the domainID property in the lineage harvester configuration file.
    • The domainID property in the lineage harvester configuration file represents the default domain. Tableau assets that are not mapped to specific domains via this domainMapping section, for example Tableau Server assets, are ingested in that default domain.

    Domain mapping is transitive, meaning that all resources, such as Tableau workbooks and data attributes in a parent Tableau site, project or sub-project, are ingested in the same domain as the parent.

    Note  

    • If you want to ingest all assets in a Tableau site, use the domainMapping section.

    • The domainMapping and filters sections are mutually exclusive. Do not include both domainMapping and filters sections in your JSON file.

    Let's say that you have a Tableau site named "Site-1". You want to ingest all Tableau projects in "Site-1" in a domain named "Domain-1" in Collibra, with the exception of one Tableau project named "Project-Default", which you want to ingest in "Domain-2". You should configure the domainMapping section as follows.

    "domainMapping": {
	 "<Site-1>": "reference-id-of-Domain-1",
	 "<Site-1> > <Project-Default>": "reference-id-of-Domain-2"
	}

    If you wanted to specify a domain for a sub-project of "Project-Default", you would use the <site name> > <project name> > <sub-project name> property, as described below.

    Tip For the properties in this domainMapping section, ensure that you maintain the spaces before and after ">", for example "Site-1 > Project-Default". The spaces serve as a separator between the site and the projects.
    site name

    The Tableau site name, followed by the unique reference ID of the domain in Collibra in which you want to ingest resources from the Tableau site.

    Important In the configuration file, use the actual site name, along with the domain reference ID, for example: "Collibra_tab_partner_site": "afc8cfb0-91f1-4075-a3e5-7ce6d1f9bcc9"
    site name > project name

    The Tableau project name, preceded by the name of the Tableau site to which it belongs, and followed by the unique reference ID of the domain in Collibra in which you want to ingest resources from the Tableau project.

    Important In the configuration file, use the actual site and project names, along with the domain reference ID, for example: "Collibra_tab_partner_site > JB_Test_2812": "d224a1a5-43b4-43b2-8df0-ddf8f2726b82"
    site name > project name > sub-project name

    The Tableau sub-project name, preceded by the name of the Tableau site and project to which it belongs, and followed by the unique reference ID of the domain in Collibra in which you want to ingest resources from the Tableau sub-project.

    Important In the configuration file, use the actual site, project and sub-project names, along with the domain reference ID, for example: "Collibra_tab_partner_site > JB_Test_2812 > ProjectJJ2": "d224a1a5-43b4-43b2-8df0-ddf8f2726b82"
    .

    Copy code

    {
  "collibraSystemNames": {
    "databases": [
      {
        "hostName": "database-hostname",
        "collibraSystemName": "public"
      }
    ],										
    "files": [
      {"filePath": "C:\\ProgramData\\Tableau\\Tableau Server\\data\\files\\sample.xls",
        "collibraSystemName": "sample-files"
      }
    ],
    "connectors": [
      {
        "connectorUrl": "tableau-server-connector-url.com",
        "collibraSystemName": "Oracle-connector"
      }
    ],
    "cloudFiles": [
      {
        "name": "file-name",
        "collibraSystemName": "FILE"
      }
    ]
  },
  "databaseMapping": {
	 "<hostname:port>":"<actual database name>"
  },
  "filters": {
     "projects":{
       "site_name2 > project_name2": "domain-reference-id2",
       "site_name3 > project_name3 > subproject_name": "domain-reference-id2"
		}
	}	
}

    Tip Click Copy code to copy the example to your clipboard.

  4. Save the <source ID> configuration file.