Abstract: Systems and methods for an extract, transform and load (ETL) framework are disclosed. Some implementations include retrieving, at a server, chat and call log files from a customer service database, automatically including the chat and call log files into a server database, receiving, one or more queries related to the chat and call log files in the server database, where the queries include one or more of phrase queries or wildcard queries, processing the one or more queries to generate results satisfying the one or more queries, and providing the results of the queries to a client computing device for display, wherein the retrieving, the automatically including, the receiving and the processing are performed in parallel at the server.