A data integration system accesses a time series database and an asset relational database. The asset relational database is comprised of a plurality of asset nodes related in a hierarchical structure. Each asset node may represent a physical asset in an industrial setting. The data integration system displays a graphical representation of the hierarchical structure of the asset relational database, receives user input selecting an asset node from the hierarchical structure, and displays a hierarchical search template based on the selected asset node. The data integration system searches the asset relational database for matching asset nodes and retrieves corresponding time series data from the time series database. The data integration system generates a report from the retrieved data.