How can I switch the data source from MySQL to Oracle in QlikView?
How can I switch the data source from MySQL to Oracle in QlikView while ensuring the report retains the same structure and functionality? For example, if in MySQL I have a column named "priceEach," but in Oracle, it might be "PRICEEACH," how can I ensure that if I change the connection, the report will recognize "PRICEEACH" as "priceEach" from the previous connection?Im using sql select query to load data.
I assume you will need various manual adjustments within your entire ETL + Report chain and probably will to start by the sql-layer be the one with the least efforts. But in regard to the long-term maintaining it might be more sensible to switch everything to the new source.
Beside this I don't know if these sql-tools are case-sensitive by field-names or not. If not the sql-script itself may remain unchanged and a rename-mapping might be applied before Qlik accessed the fields in further measurements. In other words in depends mainly on how the current loads are developed if there are some "easy" doings possible which includes also a search & replace approach against the script-text or not.
