How to change data connections of tables loaded by Data Manager?

Data connection to a data source has changed, for example your Qlik Sense environment will now connect to Oracle database via an OLE DB connection instead of ODBC.
Users have been using the old ODBC connection in Data Manager. To change the connection, an option is to unlock Auto-generated section in the reload script, remove the old LIB CONNECT TO command and add the new one. However, tables are not editable anymore in Data Manager with this approach.

Is there anyway to change data connection without unlocking the Auto-generated script?
 

Some supported options to change data connections in Auto-generated script are:

• Delete the old data connection in Qlik Sense QMC > Data connections and create the new connection with the same name
• Delete tables related to old connections and re-add these tables with new connections. 

If you don't want to delete the old connection or re-add tables, the closest work-around solution is to unlock Auto-generated section, change the LIB CONNECT command, then use "Synchronize scripted tables" button in Data Manager to create a new Auto-generated section. With this approach, tables are still editable in Data Manager after changing connection.
 


Note that "Synchronize scripted tables" will create a new AutoCalendar, you will need to delete the AutoCalendar in the old Auto-generated section for the reload to work.

Environment:

• Qlik Sense all versions