2024-06-18 15:53:06 +02:00
|
|
|
---
|
2025-06-20 19:46:38 +05:30
|
|
|
title: SAS Connector | OpenMetadata Analytics Integration Guide
|
2024-06-18 15:53:06 +02:00
|
|
|
slug: /connectors/database/sas
|
|
|
|
---
|
|
|
|
|
|
|
|
{% connectorDetailsHeader
|
|
|
|
name="SAS"
|
|
|
|
stage="BETA"
|
|
|
|
platform="OpenMetadata"
|
|
|
|
availableFeatures=["Metadata"]
|
2025-03-03 12:56:25 +05:30
|
|
|
unavailableFeatures=["Query Usage", "Data Profiler", "Data Quality", "Lineage", "Column-level Lineage", "dbt", "Stored Procedures", "Owners", "Tags", "Sample Data"]
|
2024-06-18 15:53:06 +02:00
|
|
|
/ %}
|
|
|
|
|
|
|
|
In this section, we provide guides and references to use the SAS connector.
|
|
|
|
|
|
|
|
Configure and schedule SAS metadata workflow from the OpenMetadata UI:
|
|
|
|
|
|
|
|
- [Requirements](#requirements)
|
|
|
|
- [Metadata Ingestion](#metadata-ingestion)
|
2025-04-07 13:41:53 +05:30
|
|
|
- [Troubleshooting](/connectors/database/sas/troubleshooting)
|
2024-06-18 15:53:06 +02:00
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/ingestion-modes-tiles.md" variables={yamlPath: "/connectors/database/sas/yaml"} /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
|
|
|
## Requirements
|
|
|
|
|
|
|
|
{%inlineCallout icon="description" bold="OpenMetadata 1.3 or later" href="/deployment"%}
|
|
|
|
To deploy OpenMetadata, check the Deployment guides.
|
|
|
|
{%/inlineCallout%}
|
|
|
|
|
|
|
|
## Metadata Ingestion
|
|
|
|
|
|
|
|
Prepare the SAS Service and configure the Ingestion:
|
|
|
|
|
|
|
|
{% partial
|
2024-12-12 11:34:09 +05:30
|
|
|
file="/v1.7/connectors/metadata-ingestion-ui.md"
|
2024-06-18 15:53:06 +02:00
|
|
|
variables={
|
|
|
|
connector: "SAS",
|
2024-12-12 11:34:09 +05:30
|
|
|
selectServicePath: "/images/v1.7/connectors/sas/select-service.png",
|
|
|
|
addNewServicePath: "/images/v1.7/connectors/sas/add-new-service.png",
|
|
|
|
serviceConnectionPath: "/images/v1.7/connectors/sas/service-connection.png",
|
2024-06-18 15:53:06 +02:00
|
|
|
}
|
|
|
|
/%}
|
|
|
|
|
|
|
|
{% stepsContainer %}
|
|
|
|
{% extraContent parentTagName="stepsContainer" %}
|
|
|
|
|
|
|
|
#### Connection Details
|
|
|
|
|
|
|
|
- **ServerHost**: Host and port of the SAS Viya deployment.
|
|
|
|
- **Username**: Username to connect to SAS Viya. This user should have privileges to read all the metadata in SAS Information Catalog.
|
|
|
|
- **Password**: Password to connect to SAS Viya.
|
|
|
|
- **Filter**: A filter expression specifying items for import. For more information [see](https://developer.sas.com/apis/rest/DataManagement/#catalog)
|
|
|
|
|
|
|
|
{% /extraContent %}
|
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/test-connection.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/metadata/configure-ingestion.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/ingestion-schedule-and-deploy.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
|
|
|
{% /stepsContainer %}
|