Alation's Enterprise Data Catalog Connectors provide broad and deep connectivity to various data sources, empowering valuable insights and intelligence across the enterprise. With over 100 connectors, Alation offers a single-pane-of-glass view across your entire data ecosystem. These connectors facilitate metadata extraction, query log processing, profiling, and sampling, enabling users to understand their data and how it's used. Alation connectors process SQL queries and scripts to extract vital lineage information, allowing users to view end-to-end lineage to understand data flows, relationships, health, and impact analysis. Users can run SQL queries against a wide range of connected data source types, including RDBMS, NoSQL, and application sources, directly from Alation’s built-in Intelligent SQL Editor. Alation connectors let you match the source and organization-specific authentication methods you’ve already standardized, including SSO. Metadata extraction tracks changes, ensuring users always have a current and complete view of data across an organization's ecosystem. Alation analyzes query logs to spot usage patterns unique to your organization to uncover popular data assets and top users. Alation connectors gather helpful column-level profiling statistics – including minimum, maximum, frequency distribution, and null values. With sampling, a subset of the data is extracted and presented to users – offering a quick view into a table's contents and usefulness.

Features:

• Data lineage: View end-to-end lineage to understand data flows, relationships, health, and impact analysis. Alation connectors process SQL queries and scripts to extract this vital lineage information for those who need it.
• Run queries: Run SQL queries against a wide range of connected data source types – including RDBMS, NoSQL, and application sources. Best of all, run these queries right from Compose, Alation’s built-in Intelligent SQL Editor.
• Authentication: Authentication is a foundational security pillar that verifies users' identity. Alation connectors let you match the source and organization-specific authentication methods you’ve already standardized, including SSO.
• Metadata Extraction: Metadata is the foundation of a data catalog. It offers context, making it easier for you to understand and collaborate with data at scale. Metadata extraction tracks changes, ensuring users always have a current and complete view of data across an organization's ecosystem.
• Query Log Processing: Query logs are a rich source of information about who is using data and how. Alation analyzes these logs to spot usage patterns unique to your organization to uncover popular data assets and top users. Utilize these insights to prioritize which assets to work on first and who can help explain them.
• Profiling: Assess high-level data quality quickly with data profiling. Alation connectors gather helpful column-level profiling statistics – including minimum, maximum, frequency distribution, and null values. Data analysts and engineers can use these details to create data quality rules.
• Sampling: Sometimes, a glimpse of the data is all you need to start using it. With sampling, a subset of the data is extracted and presented to users – offering a quick view into a table's contents and usefulness.