What does Atlan crawl from SSRS?

Atlan crawls and maps the following assets and properties from SQL Server Reporting Services (SSRS).

Notation:

• 🔀 = Includes lineage support
• 📊 = Includes column-level details

SSRSFolder

Folders in SSRS organize reports, datasets, and data sources in a hierarchy. Atlan maps each folder to an SSRSFolder asset and captures its path, visibility, and audit fields. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
Path	ssrsPath	asset profile
Created By	sourceCreatedBy	asset profile and properties sidebar
Creation Date	sourceCreatedAt	asset profile and properties sidebar
Modified By	sourceUpdatedBy	asset profile and properties sidebar
Modified Date	sourceUpdatedAt	asset profile and properties sidebar
Hidden	ssrsHidden	API only

SSRSReport 🔀

Reports are the main deliverable in SSRS (RDL files or published report definitions). Atlan maps each report to an SSRSReport asset and captures metadata such as parameters, size, and links to datasets and data sources. Reports include lineage support showing connections to datasets. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
Path	ssrsPath	asset profile
Size	ssrsReportSize	asset profile
Parameters	ssrsReportParameters	asset profile
Created By	sourceCreatedBy	asset profile and properties sidebar
Creation Date	sourceCreatedAt	asset profile and properties sidebar
Modified By	sourceUpdatedBy	asset profile and properties sidebar
Modified Date	sourceUpdatedAt	asset profile and properties sidebar
Hidden	ssrsHidden	API only
Dataset Count	ssrsReportDataSetCount	asset profile
Data Source Count	ssrsReportDataSourceCount	asset profile

SSRSDataSet 🔀📊

Datasets define the queries and data that feed reports; they can be shared across reports or embedded in a single report. Atlan maps each dataset to an SSRSDataSet asset and captures the query text, data source reference, and field count. Datasets include lineage support and column-level details showing connections to data sources and fields. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Dataset Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
SQL Query	ssrsDataSetSqlQuery	asset profile
Is Shared DataSet	ssrsDataSetIsSharedDataSet	asset profile
Query Parameters	ssrsDataSetQueryParameters	asset profile
Data Source Connection String	ssrsDataSetDataSourceConnectionString	asset profile
Data Source Reference	ssrsDataSetDataSourceReference	asset profile
Extension	ssrsDataSetExtension	API only
Table Name	ssrsTableName	asset profile and overview sidebar
Catalog Name	ssrsCatalogName	asset profile
Schema Name	ssrsSchemaName	asset profile
Reference Table Names	ssrsDataSetReferenceTableNames	asset profile
Path	ssrsPath	asset profile
Report Name	ssrsReportName	asset profile and overview sidebar
Cube Name	ssrsDataSetCubeName	asset profile
Stored Procedure Name	ssrsDataSetStoredProcedureName	asset profile
Processed SQL	ssrsDataSetProcessedSql	API only
Log Messages	ssrsDataSetLogMessages	API only
Error Code	ssrsDataSetErrorCode	API only
Connected	ssrsDataSetConnected	asset profile
Field Count	ssrsDataSetFieldCount	asset profile

SSRSField 🔀

Fields are the columns exposed by a dataset (from queries, stored procedures, or report models). Atlan maps each field to an SSRSField asset and captures data type, source column references, and expressions for lineage. Fields include lineage support showing connections to source database columns. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
Datatype	ssrsFieldDatatype	asset profile and overview sidebar
Function	ssrsFieldFunction	asset profile
Calculated Field	ssrsFieldCalculatedField	asset profile
Database Field	ssrsFieldDatabaseField	asset profile
SQL Transform Expression	ssrsFieldSqlTransformExpression	asset profile and overview sidebar
Table Name	ssrsTableName	asset profile and overview sidebar
Catalog Name	ssrsCatalogName	asset profile
Schema Name	ssrsSchemaName	asset profile
Referenced Column Names	ssrsFieldReferencedColumnNames	asset profile
Path	ssrsPath	asset profile
Field Type	ssrsFieldFieldType	asset profile
Cube Name	ssrsFieldCubeName	asset profile
Stored Procedure Name	ssrsFieldStoredProcedureName	asset profile
Ordinal Position	ssrsFieldOrdinalPosition	asset profile
Log Messages	ssrsFieldLogMessages	API only
Error Code	ssrsFieldErrorCode	API only
Report Source	ssrsFieldReportSource	asset profile
Data Group	ssrsFieldDataGroup	asset profile
Connected	ssrsFieldConnected	asset profile

SSRSDataSource

Data sources hold connection information to external databases and systems that reports and datasets use. Atlan maps each data source to an SSRSDataSource asset and captures the connection string (without secrets), credential mode, and audit fields. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
Path	ssrsPath	asset profile
Extension	ssrsDataSourceExtension	API only
Connection String	ssrsDataSourceConnectionString	asset profile
UserName	ssrsDataSourceUserName	API only
Created By	sourceCreatedBy	asset profile and properties sidebar
Creation Date	sourceCreatedAt	asset profile and properties sidebar
Modified By	sourceUpdatedBy	asset profile and properties sidebar
Modified Date	sourceUpdatedAt	asset profile and properties sidebar
Credential Retrieval	ssrsDataSourceCredentialRetrieval	API only
Windows Credentials	ssrsDataSourceWindowsCredentials	API only
Enabled	ssrsDataSourceEnabled	asset profile
Use Original Connect String	ssrsDataSourceUseOriginalConnectString	API only
Original Connect String Expression Based	ssrsDataSourceOriginalConnectStringExpressionBased	API only
Impersonate User	ssrsDataSourceImpersonateUser	API only
Prompt	ssrsDataSourcePrompt	API only

SSRSModel

Report models provide a semantic layer over data sources and define entities and relationships for ad hoc reporting. Atlan maps each report model to an SSRSModel asset and captures size, entity count, and data source count. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
Path	ssrsPath	asset profile
Created By	sourceCreatedBy	asset profile and properties sidebar
Creation Date	sourceCreatedAt	asset profile and properties sidebar
Modified By	sourceUpdatedBy	asset profile and properties sidebar
Modified Date	sourceUpdatedAt	asset profile and properties sidebar
Hidden	ssrsHidden	API only
Size	ssrsModelSize	asset profile
Entity Count	ssrsModelEntityCount	asset profile
Data Source Count	ssrsModelDataSourceCount	asset profile

SSRSEntity

Entities are business objects defined inside a report model (for example, tables or views). Atlan maps each entity to an SSRSEntity asset and captures its link to the parent model and its attribute and role counts. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
Path	ssrsPath	asset profile
Model	ssrsModelName	asset profile and overview sidebar
Model Path	ssrsModelQualifiedName	asset profile
Hidden	ssrsHidden	API only
Report Model Source	ssrsEntityReportModelSource	asset profile
Attribute Count	ssrsEntityAttributeCount	asset profile
Role Count	ssrsEntityRoleCount	asset profile

SSRSAttribute

Attributes are the fields (columns) of an entity in a report model. Atlan maps each attribute to an SSRSAttribute asset and captures column name, data type, and relationships to the parent entity and model for lineage. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
Column Name	ssrsAttributeColumnName	asset profile and overview sidebar
Table Name	ssrsTableName	asset profile and overview sidebar
Catalog Name	ssrsCatalogName	asset profile
Schema Name	ssrsSchemaName	asset profile
Datatype	ssrsAttributeDatatype	asset profile and overview sidebar
Format	ssrsAttributeFormat	asset profile
Path	ssrsPath	asset profile
Hidden	ssrsHidden	API only
Sort Direction	ssrsAttributeSortDirection	asset profile
Is Aggregate	ssrsAttributeIsAggregate	asset profile
Function	ssrsAttributeFunction	asset profile
Model	ssrsModelName	asset profile and overview sidebar
Model Path	ssrsModelQualifiedName	asset profile
Entity	ssrsEntityName	asset profile
Entity Path	ssrsEntityQualifiedName	asset profile
Report Model Source	ssrsAttributeReportModelSource	asset profile
Nullable	ssrsAttributeNullable	asset profile

SSRSRole

Roles define relationships between entities in a report model (for example, foreign key–style links). Atlan maps each role to an SSRSRole asset and captures cardinality, relation end, and links to the related entity. The following properties are available.

SSRS Property	Atlan Property	Where in Atlan
Name	name	asset profile and overview sidebar
Description	description	asset profile and overview sidebar
Path	ssrsPath	asset profile
Model	ssrsModelName	asset profile and overview sidebar
Model Path	ssrsModelQualifiedName	asset profile
Entity	ssrsEntityName	asset profile
Entity Path	ssrsEntityQualifiedName	asset profile
Cardinality	ssrsRoleCardinality	asset profile
Relation End	ssrsRoleRelationEnd	asset profile
Related Role ID	ssrsRoleRelatedRoleId	API only

See also

• Set up SSRS: Configure connection and authentication to your Report Server
• Crawl SSRS assets: Run and schedule metadata collection
• Common SSRS issues: Resolve connection and crawl issues