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 for the following reasons:

  • To define your Tableau operating model.
  • To provide additional information about databases and files in Tableau. For example, you can define the system name of databases in Tableau.
    Note This is only required when the useCollibrasystemName property in the lineage harvester configuration file is set to true.

Prerequisites

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.
  3. For each database in Tableau, add the following content to the JSON file:

    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.

    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.

    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.
    Tableau Workbook contains/contained in Tableau Data Model
    		Resource ID of the manually created relation type.
    Report uses/used in Data Attribute
    		Resource ID of the manually created relation type.
    .

    Copy code

    {
  "collibraSystemNames": {
    "databases": [
      {
        "hostName": "tableau-server.us-east-1.rds.amazonaws.com",
        "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"
      }
    ]
  },
  "catalogRelationsIds": {
    "Tableau Workbook contains/contained in Tableau Data Model": "12345678-abc1-def2-4ef5-abcdef012345",
    "Report uses/used in Data Attribute": "0987654-abc2-def3-4ef5-abcdef67890"
  }
}

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

  4. Save the <source ID> configuration file.