OpenMetadata/openmetadata-docs/content/v1.6.x/connectors/pipeline/wherescape/index.md

title	slug
Wherescape	/connectors/pipeline/wherescape

{% connectorDetailsHeader name="Wherescape" stage="BETA" platform="Collate" availableFeatures=["Pipelines", "Pipeline Status", "Lineage", "Owners"] unavailableFeatures=["Tags"] / %}

In this section, we provide guides and references to use the Wherescape connector.

Configure and schedule Wherescape metadata workflow from the OpenMetadata UI:

• Requirements
• Metadata Ingestion
  • Connection Details
• Troubleshooting

{% partial file="/v1.6/connectors/ingestion-modes-tiles.md" variables={yamlPath: "/connectors/pipeline/wherescape/yaml"} /%}

Requirements

{% note %}

The Wherescape connector is available only in OpenMetadata version 1.6.8 or later.

{% /note %}

To extract Wherescape metadata, we need the batabase connection details where the metadata is stored.

• API Permission ( While Creating the User, from Admin -> User )
• To retrieve lineage data, the user must be granted Component-level permissions.
• To enable lineage tracking in Matillion, Matillion Enterprise Mode is required. For detailed setup instructions and further information, refer to the official documentation: Matillion Lineage Documentation.

Metadata Ingestion

{% partial file="/v1.6/connectors/metadata-ingestion-ui.md" variables={ connector: "Wherescape", selectServicePath: "/images/v1.6/connectors/wherescape/select-service.png", addNewServicePath: "/images/v1.6/connectors/wherescape/add-new-service.png", serviceConnectionPath: "/images/v1.6/connectors/wherescape/service-connection.png", } /%}

{% stepsContainer %} {% extraContent parentTagName="stepsContainer" %}

Connection Details

• Connection: Wherescape metadata database connection.

In terms of connection we support the following selections:

• Microsoft SQL Server: To connect to the Wherescape metadata database:
  • Provide the SQL Server connection credentials including username and password
  • Specify the database name where Wherescape metadata is stored
  • Enter the host and port for the SQL Server instance
  • The connector will establish a connection to this database to extract Wherescape pipeline metadata

{% /extraContent %}

{% partial file="/v1.6/connectors/test-connection.md" /%}

{% partial file="/v1.6/connectors/pipeline/configure-ingestion.md" /%}

{% partial file="/v1.6/connectors/ingestion-schedule-and-deploy.md" /%}

{% /stepsContainer %}