How to Use Our Tools
HANA CV to SQL Converter
Step 1: Get XML File from HANA Studio
Once processing is complete, your converted SQL queries along with node-level logic as a ZIP file will be available for download. This ZIP file and detailed data mapping encrypted Excel sheet will also be stored in Account > Conversions page.
Step 2: Upload XML Files
Upload your View XML file using the file upload option. The tool accepts .xml and .txt file formats.
Step 3: Process Files
Click the Process button to start the conversion. The tool will validate your XML files and display Node count and Paid/Free conversion details, then convert the HANA Calculation View logic into standard SQL queries.
Step 4: Get Results
Once processing is complete, your converted SQL queries along with node-level logic as a ZIP file will be available for download. This ZIP file and the detailed data mapping encrypted Excel sheet will also be stored in Account > Conversions page.
SQL Mapping Engine
Step 1: Select Target Data Processing System
Choose your desired target data processing system from the selection screen to ensure compatibility and optimized SQL generation.
Step 2: Upload Your Encrypted XLSX Mapping File
Upload your encrypted Excel mapping file (.xlsx).You can find this file in Account > Conversions
Step 3: Update Custom Mapping and Generate
After file upload, update your custom table/column mapping according to your target system. Click Process to start the SQL generation based on your mappings.
Step 4: Download Generated SQL
After processing completes, download your generated SQL file. This file contains the transformed SQL queries based on your mapping.
Pro Tips
- Always validate your XML files before uploading to ensure proper formatting.
- Ensure you provide proper new mapping for your target system.
- Minor adjustments may be needed even after converting files with the SQL Mapping Engine.