Abstract: Disclosed herein are system, method, and computer program product embodiments for converting data transformation functions for one data consolidation tool to another data consolidation tool. A transformation function conversion system converts one or more first data transformation functions to one or more second data transformation functions using a mapping configuration file. The mapping configuration file includes direct and/or indirect mappings for data transformation functions. This may translate one or more functions from the first data consolidation tool to the second data consolidation tool. The transformation function conversion system may also convert configuration files containing the data transformation functions and/or metadata. The transformation function conversion system also generates a graphical user interface (GUI) with a visual representation of the data transformation process.

Abstract: Disclosed herein are system, method, and computer program product embodiments for converting queries and scripts used in big data systems. A script conversion system converts a script and its queries from a first big data format to a second big data format. The script conversion system uses a configuration mapping that includes direct and/or indirect function mappings. For the direct mapping, the script conversion system replaces the function with a new function in the second big data format. For the indirect mapping, the script conversion system constructs an equivalent function in the second big data format using information extracted from parsing queries in the first big data format. The script conversion system also formats a converted query using a project mapping and/or generates a conversion report indicating successful or unsuccessful conversions. Scripts may be converted from an on-premises data warehouse system to a cloud-based data warehouse system.