ETL Setup

The Atlas ETL’s are used to collect metadata from a variety of sources and merge it into a common database.

There are several ETLs -

• LDAP: Loads user information from an LDAP server.
• (Optional) Sqlize Crystal Reports: ETL to extract sql queries from Crystal Reports.
• (Optional) Tableau Metadata: ETL to extract Tableau metadata, sql queries and run data.
• (Optional) PowerBI Metadata: ETL to extract PowerBI metadata and run data.
• Report Metadata (split into 8 sections): Collects metadata from over five different reporting tools.
• Report Run Data: Collects run data from various reporting tools.
• Solr Search: ETL to keep the search results fresh.