SAS Connector | Collate Analytics Integration Guide

Connect SAS databases to Collate with our comprehensive connector guide. Step-by-step setup, configuration, and metadata extraction instructions.

In this section, we provide guides and references to use the SAS connector. Configure and schedule SAS metadata workflow from the Collate UI:

• Requirements
• Metadata Ingestion
• Troubleshooting

Requirements

OpenMetadata 1.3 or later

To deploy OpenMetadata, check the Deployment guides.

Metadata Ingestion

Prepare the SAS Service and configure the Ingestion:

Connection Details

1. 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
2. Test the Connection

   Once the credentials have been added, click on Test Connection and Save the changes.

   
3. Configure Metadata Ingestion

   In this step we will configure the metadata ingestion pipeline, Please follow the instructions below

   
4. Schedule the Ingestion and Deploy

   Scheduling can be set up at an hourly, daily, weekly, or manual cadence. The timezone is in UTC. Select a Start Date to schedule for ingestion. It is optional to add an End Date.

   Review your configuration settings. If they match what you intended, click Deploy to create the service and schedule metadata ingestion.

   If something doesn’t look right, click the Back button to return to the appropriate step and change the settings as needed.

   After configuring the workflow, you can click on Deploy to create the pipeline.

   
5. View the Ingestion Pipeline

   Once the workflow has been successfully deployed, you can view the Ingestion Pipeline running from the Service Page.

   

   If AutoPilot is enabled, workflows like usage tracking, data lineage, and similar tasks will be handled automatically. Users don’t need to set up or manage them - AutoPilot takes care of everything in the system.

Troubleshooting

SAS Troubleshooting

Learn more about how to troubleshoot common SAS connector issues and resolve configuration or ingestion errors.